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