AWS Instances AMI

List All Amazon Web Services Instances AMIs

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