‎03-05-2019 01:17 PM
Select Top 1000000 tblAWSSecurityGroup.GroupId As SecurityGroupId,
tblAWSSecurityGroup.Name,
tblAWSContainer.Region,
tblAWSSecurityGroup.OwnerId,
tblAWSSecurityGroup.Description,
tblAWSSecurityGroupPermission.FromPort,
tblAWSSecurityGroupPermission.ToPort,
tblAWSSecurityGroupPermission.IpProtocol,
tblAWSSecurityGroupPermissionIpRange.CidrIp,
tblAWSSecurityGroupPermissionIpRange.Description As IpRangeDescription
From tblAWSSecurityGroup
Left Join tblAWSContainer On tblAWSContainer.AWSContainerId =
tblAWSSecurityGroup.AWSContainerId
Inner Join tblAWSSecurityGroupPermission On
tblAWSSecurityGroupPermission.AWSSecurityGroupId =
tblAWSSecurityGroup.AWSSecurityGroupId
Inner Join tblAWSSecurityGroupPermissionIpRange On
tblAWSSecurityGroupPermissionIpRange.AWSSecurityGroupPermissionId =
tblAWSSecurityGroupPermission.AWSSecurityGroupPermissionId
Order By tblAWSContainer.Region,
SecurityGroupId,
tblAWSSecurityGroupPermission.FromPort
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now