CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

AWS Instances AMI

Cloud

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 Instance 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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.