Notification

Icon
Error

AWS: Instance Security Group Permissions (Built-in)

Posted: Tuesday, March 5, 2019 1:20:06 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 2,187
0
Like
The report below gives back a list of AWS Instances and their security group permissions.

The report will only list permissions 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,
  tblAWSSecurityGroup.GroupId As SecurityGroupId,
  tblAWSSecurityGroup.Name,
  tblAWSSecurityGroup.OwnerId,
  tblAWSSecurityGroup.Description,
  tblAWSSecurityGroupPermission.FromPort,
  tblAWSSecurityGroupPermission.ToPort,
  tblAWSSecurityGroupPermission.IpProtocol,
  tblAWSSecurityGroupPermissionIpRange.CidrIp,
  tblAWSSecurityGroupPermissionIpRange.Description As RangeDescription
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 tblAWSInstanceSecurityGroup On
    tblAWSInstanceSecurityGroup.AWSInstanceId = tblAWSInstance.AWSInstanceId
  Inner Join tblAWSSecurityGroup On tblAWSSecurityGroup.AWSSecurityGroupId =
    tblAWSInstanceSecurityGroup.AWSSecurityGroupId
  Inner Join tblAWSSecurityGroupPermission On
    tblAWSSecurityGroupPermission.AWSSecurityGroupId =
    tblAWSSecurityGroup.AWSSecurityGroupId
  Inner Join tblAWSSecurityGroupPermissionIpRange On
    tblAWSSecurityGroupPermissionIpRange.AWSSecurityGroupPermissionId =
    tblAWSSecurityGroupPermission.AWSSecurityGroupPermissionId
Where tblState.Statename = 'Active'
Order By tblAWSInstance.Region,
  tblAssets.IPNumeric,
  SecurityGroupId,
  tblAWSSecurityGroupPermission.FromPort

Active Discussions

Lansweeper Windows user activity tracking
by  DaveP   Go to last post Go to first unread
Last post: 6/28/2022 6:57:09 PM(UTC)
Lansweeper Report showing app even after it has gone
by  Andy.S  
Go to last post Go to first unread
Last post: 5/30/2022 3:19:37 PM(UTC)
Lansweeper Creating a schduled task on remote computer
by  TassieTrooper   Go to last post Go to first unread
Last post: 4/12/2022 8:49:36 AM(UTC)
Action Internet history of an user (IE and Firefox)
by  Tizi@no  
Go to last post Go to first unread
Last post: 4/1/2022 1:32:49 PM(UTC)
Action Remote Uninstaller
by  Tizi@no   Go to last post Go to first unread
Last post: 4/1/2022 9:29:17 AM(UTC)
Lansweeper uVNC Config
by  RatWolf  
Go to last post Go to first unread
Last post: 3/17/2022 3:16:53 PM(UTC)
Lansweeper Change computer name by custom field
by  Don  
Go to last post Go to first unread
Last post: 3/4/2022 3:44:08 AM(UTC)