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
