Notification

Icon
Error

AWS: Instance Volumes (Built-in)

Posted: Tuesday, March 5, 2019 1:19:39 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,676
0
Like
The report below gives back a list of AWS Instances and their volumes.

The report will only list volumes when the following criteria are met:
  • You have Lansweeper 7.1 or higher.
  • There is AWS Instance data scanned.
  • The asset has the active state.

Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAWSInstance.InstanceId,
  tblAWSInstance.InstanceType,
  tblAWSInstance.Platform,
  tblAWSInstance.Region,
  tblAWSInstance.State,
  tblAWSVolume.VolumeId,
  tblAWSVolume.VolumeType,
  Case tblAWSVolume.VolumeType
    When 'gp2' Then 'General Purpose SSD'
    When 'io1' Then 'Provisioned IOPS SSD'
    When 'st1' Then 'Throughput Optimized HDD'
    When 'sc1' Then 'Cold HDD'
    When 'standard' Then 'Magnetic Volume'
  End As VolumeTypeDesc,
  tblAWSVolume.Size [Size(GB)],
  tblAWSVolume.Encrypted,
  tblAWSVolume.Iops,
  tblAWSVolume.AttachTime
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 tblAWSVolume On tblAWSVolume.AWSInstanceId =
    tblAWSInstance.AWSInstanceId
Where tblState.Statename = 'Active'
Order By tblAWSInstance.Region,
  tblAssets.IPNumeric,
  tblAssets.AssetName,
  tblAWSVolume.VolumeId

Active Discussions

Lansweeper LsAgent install issue
by  moug   Go to last post Go to first unread
Last post: Today at 3:12:47 PM(UTC)
Lansweeper Spare Hard Drives
by  brodiemac  
Go to last post Go to first unread
Last post: Today at 2:32:31 PM(UTC)
Lansweeper Adding Events via Meeting Request
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 10:32:17 AM(UTC)
Lansweeper Add Document as File Link
by  mowo   Go to last post Go to first unread
Last post: Today at 10:28:33 AM(UTC)
Lansweeper Same Name and Domain
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 10:26:22 AM(UTC)
Lansweeper Logs of User activity
by  Esben.D   Go to last post Go to first unread
Last post: Today at 9:50:00 AM(UTC)
Lansweeper O365 scanning issue
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 9:44:35 AM(UTC)