The report below gives back a list of Azure assets per subscription.
The report will only list assets when the following criteria are met:
- You have Lansweeper 7.1 or higher.
- There is Azure resource group of virtual machine data scanned.
- The asset state is active.
Select Top 1000000 *
From (Select tblAssets.AssetID,
tblAzureResourceGroup.SubscriptionId,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tsysAssetTypes.AssetTypename As AssetType,
tblAzureResourceGroup.Region,
tblAzureResourceGroup.Tags,
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
Where tblState.Statename = 'Active'
Union All
Select tblAssets.AssetID,
tblAzureResourceGroup.SubscriptionId,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tsysAssetTypes.AssetTypename As AssetType,
tblAzureVirtualMachine.Region,
tblAzureVirtualMachine.Tags,
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 tblAzureVirtualMachine On tblAzureVirtualMachine.AssetId =
tblAssets.AssetID
Inner Join tblAzureResourceGroup On tblAzureResourceGroup.Id =
tblAzureVirtualMachine.AzureResourceGroupId
Where tblState.Statename = 'Active') SQ
Order By SQ.SubscriptionId,
SQ.AssetType,
SQ.AssetName
