→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

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 AWS Instance AMIs.

The report will only list AMIs when the following criteria are met:
  • You have Lansweeper 7.1 or higher.
  • There is AWS Instance AMI data scanned.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAWSInstance.InstanceId,
tblAWSInstance.InstanceType,
tblAWSInstance.Region,
tblAWSInstance.State,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAWSAmi.ImageId,
tblAWSAmi.Name,
tblAWSAmi.Platform,
tblAWSAmi.Description,
Case tblAWSAmi.[Public]
When 0 Then 'False'
Else 'True'
End As IsPublic
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblAWSInstance On tblAWSInstance.AssetId = tblAssets.AssetID
Inner Join tblAWSAmi On tblAWSAmi.AWSAmiId = tblAWSInstance.AWSAmiId
Where tblState.Statename = 'Active'
Order By tblAWSInstance.Region,
tblAWSInstance.Platform,
tblAssets.IPNumeric
0 REPLIES 0