Find All Azure Security Groups and Detailed Information About the Rules Included
Along with other detailed Azure information, Lansweeper retrieves security groups and their details from Azure. You can find all your Azure security groups along with the rules that are part of the security group. Additional details like priority, protocol and port range are also included in the report.
Azure Security Groups and Rules Query
Select Top 1000000 tblAzureNetworkSecurityGroup.Name As SecurityGroupName,
tblAzureSecurityRule.Priority,
tblAzureSecurityRule.Name As RuleName,
tblAzureSecurityRule.RuleType,
tblAzureSecurityRule.Access,
tblAzureSecurityRule.Description,
tblAzureSecurityRule.Direction,
tblAzureSecurityRule.Protocol,
tblAzureSecurityRule.DestinationPortRange,
tblAzureSecurityRule.SourcePortRange,
tblAzureSecurityRule.DestinationAddressPrefix,
tblAzureSecurityRule.SourceAddressPrefix
From tblAzureSecurityRule
Inner Join tblAzureNetworkSecurityGroup On
tblAzureSecurityRule.AzureNetworkSecurityGroupId =
tblAzureNetworkSecurityGroup.Id
Order By SecurityGroupName,
tblAzureSecurityRule.Priority,
RuleName
