AWS: Security Groups (Built-in)

[Esben_D]

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.

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