Get an overview of which Instance uses which AMI. Along with other detailed AWS information, Lansweeper retrieves the Amazon Machine Image used by an Instance. With this overview, you can easily find which instance is using which AMI in case you need to set up another instance with the same AMI.
AWS Instances AMI Query
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
