cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
The report below gives back a list of Azure virtual machine assets and their primary network interface.

The report will only list assets when the following criteria are met:
  • You have Lansweeper 7.1 or higher.
  • There is Azure virtual machine data scanned.
  • The asset state is active.

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,
tblAzureNetworkInterface.Name As InterfaceName,
tblAzureNetworkInterface.MacAddress,
tblAzureIpConfiguration.PrivateIpAddress,
tblAzureIpConfiguration.PrivateIpAllocationMethod,
tblAzureIpConfiguration.PublicIpAddress,
tblAzureIpConfiguration.PublicIpAllocationMethod,
tblAzureNetworkInterface.Region As InterfaceRegion,
tblAzureNetworkInterface.Tags As InterfaceTags,
tblAzureNetworkInterface.IsAcceleratedNetworkingEnabled,
tblAzureNetworkInterface.IsIpForwardingEnabled,
tblAzureNetworkInterface.IsPrimaryNetworkInterface,
tblAzureNetworkInterface.InternalDnsNameLabel,
tblAzureNetworkInterface.InternalDomainNameSuffix,
tblAzureNetworkInterface.InternalFqdn,
tblAzureNetworkInterface.DnsServers,
tblAzureNetworkInterface.AppliedDnsServers,
tblAzureIpConfiguration.IsPrimary,
tblAzureIpConfiguration.Fqdn,
tblAzureIpConfiguration.ReverseFqdn,
tblAzureIpConfiguration.LeafDomainLabel,
tblAzureIpConfiguration.IdleTimeoutInMinutes,
tblAzureIpConfiguration.HasAssignedLoadBalancer,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAzureVirtualMachine On tblAzureVirtualMachine.AssetId =
tblAssets.AssetID
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.Id =
tblAzureVirtualMachine.AzureResourceGroupId
Inner Join tblAzureNetworkInterface On
tblAzureNetworkInterface.AzureVirtualMachineId = tblAzureVirtualMachine.Id
Inner Join tblAzureIpConfiguration On
tblAzureIpConfiguration.AzureNetworkInterfaceId =
tblAzureNetworkInterface.Id
Where tblAzureIpConfiguration.IsPrimary = 1 And tblState.Statename = 'Active'
Order By tblAssets.AssetName,
ResourceGroupName
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now