Azure Security Groups and Rules

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