Notification

Icon
Error

AWS: Security Groups (Built-in)

Posted: Tuesday, March 5, 2019 1:16:54 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,676
0
Like
The report below gives back a list of AWS security groups.

The report will only list groups when the following criteria are met:
  • You have Lansweeper 7.1 or higher.
  • There is AWS VPC and Instance data scanned.

Code:
Select Top 1000000 tblAWSSecurityGroup.GroupId As SecurityGroupId,
  tblAWSSecurityGroup.Name,
  tblAWSContainer.Region,
  tblAWSSecurityGroup.OwnerId,
  tblAWSSecurityGroup.Description,
  tblAWSSecurityGroup.LastChanged
From tblAWSSecurityGroup
  Left Join tblAWSContainer On tblAWSContainer.AWSContainerId =
    tblAWSSecurityGroup.AWSContainerId
Order By tblAWSContainer.Region,
  SecurityGroupId

Active Discussions

Lansweeper Add Document as File Link
by  AZHockeyNut   Go to last post Go to first unread
Last post: Today at 3:18:49 PM(UTC)
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 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)