→ 🚀What's New? Explore Lansweeper's Fall 2024 Updates! Fall Launch Blog !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
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
0 REPLIES 0