‎03-05-2019 01:16 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now