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, tblAssets.AssetName, tsysAssetTypes.AssetTypeIcon10 As icon, tblAzureResourceGroup.SubscriptionId, tblAzureResourceGroup.Region, tblAzureResourceGroup.Tags, tblAzureNetworkSecurityGroup.Name As SecurityGroupName, tblAzureNetworkSecurityGroup.Region As SecurityGroupRegion, tblAzureNetworkSecurityGroup.Tags As SecurityGroupTags, tblAssets.Lastseen, tblAssets.Lasttried 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 = tblAssets.AssetID Inner Join tblAzureNetworkSecurityGroup On tblAzureNetworkSecurityGroup.AzureResourceGroupId = tblAzureResourceGroup.Id Where tblState.Statename = 'Active' Order By tblAssets.AssetName, SecurityGroupName