PRUEBA AHORA

Azure Resource Groups’ Security Groups

Cloud Security

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

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

Show

Hide