→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎03-05-2019 01:13 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAzureVirtualMachine.PowerState,
tblAzureVirtualMachine.OsType As [OS Type],
tblAzureVirtualMachine.Region,
tblAzureVirtualMachine.Tags,
tblAzureResourceGroup.Name As ResourceGroupName,
tblAzureResourceGroup.SubscriptionId,
tblAzureDisk.Name As DiskName,
tblAzureVirtualMachineDataDisk.DiskType,
tblAzureDisk.OsType As DiskOS,
tblAzureDisk.DiskSizeGb,
tblAzureDisk.Region As DiskRegion,
tblAzureDisk.Tags As DiskTags,
tblAzureDisk.TimeCreated,
tblAzureDisk.CreationMethod,
tblAzureDisk.StorageAccountType,
tblAzureDisk.CreationSourceType,
tblAzureDisk.Zones,
tblAzureVirtualMachineDataDisk.Lun,
tblAzureVirtualMachineDataDisk.VhdUri,
tblAzureVirtualMachineDataDisk.ImageUri,
tblAzureVirtualMachineDataDisk.IsWriteAcceleratorEnabled,
tblAzureVirtualMachineDataDisk.IsDiskEncryptionEnabled,
tblAzureVirtualMachineDataDisk.CachingType,
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
Inner Join tblAzureVirtualMachineDataDisk On
tblAzureVirtualMachineDataDisk.AzureVirtualMachineId =
tblAzureVirtualMachine.Id
Inner Join tblAzureDisk On
tblAzureDisk.Id = tblAzureVirtualMachineDataDisk.AzureDiskId
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName,
ResourceGroupName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now