Find which security groups are active in your AWS environment. Along with other detailed AWS information, Lansweeper retrieves security groups and their details from Amazon Web Services. This report gives you an overview of all security groups in your AWS environment so you can easily find detailed information about them like their name, region and owner ID.
AWS Security Groups Query
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
