Azure Resource Groups’ Security Groups

Find All Your Azure Resource Groups' Security Groups

Get an overview of all Azure resource groups' security groups along with additional details such as the region and subscriptionId. Along with other detailed Azure information, Lansweeper retrieves security groups and their details from Azure. This report gives you an overview of all Azure resource groups and the security groups they are in. This lets you check whether security groups are missing, have not correctly been applied, or simply have the information in one central location.

Azure Resource Groups' Security Groups Query

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAzureNetworkSecurityGroup.Name As SecurityGroupName,
  tblAzureNetworkSecurityGroup.Region As SecurityGroupRegion,
  tblAzureNetworkSecurityGroup.Tags As SecurityGroupTags,
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblAzureResourceGroup On tblAzureResourceGroup.AssetId =
  Inner Join tblAzureNetworkSecurityGroup On
    tblAzureNetworkSecurityGroup.AzureResourceGroupId = tblAzureResourceGroup.Id
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName,

Run This Report in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting