Azure: Security groups and rules (Built-in)

[Esben_D]

The report below gives back a list of Azure security groups and rules.

The report will only list groups when the following criteria are met:

• You have Lansweeper 7.1 or higher.
  
• There is Azure resource group or virtual machine data scanned.
  
• The asset state is active.

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