→ Upcoming Keynote Event - Introducing Lansweeper's 2023 Spring Release: 'Duvel' - Learn More
‎03-05-2019 01:16 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAWSContainer.VpcId,
tblAWSContainer.Region,
tblAWSContainer.InstanceTenancy,
tblAWSContainer.State,
tblAWSContainer.IsDefault,
tblAWSSecurityGroup.GroupId As SecurityGroupId,
tblAWSSecurityGroup.Name,
tblAWSSecurityGroup.OwnerId,
tblAWSSecurityGroup.Description,
tblAWSSecurityGroupPermission.FromPort,
tblAWSSecurityGroupPermission.ToPort,
tblAWSSecurityGroupPermission.IpProtocol,
tblAWSSecurityGroupPermissionIpRange.CidrIp,
tblAWSSecurityGroupPermissionIpRange.Description As RangeDescription
From tblAssets
Inner Join tblAWSContainer On tblAWSContainer.AssetID = tblAssets.AssetID
Inner Join tblAWSSecurityGroup On tblAWSSecurityGroup.AWSContainerId =
tblAWSContainer.AWSContainerId
Inner Join tblAWSSecurityGroupPermission On
tblAWSSecurityGroupPermission.AWSSecurityGroupId =
tblAWSSecurityGroup.AWSSecurityGroupId
Inner Join tblAWSSecurityGroupPermissionIpRange On
tblAWSSecurityGroupPermissionIpRange.AWSSecurityGroupPermissionId =
tblAWSSecurityGroupPermission.AWSSecurityGroupPermissionId
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Order By tblAWSContainer.Region,
tblAWSContainer.VpcId,
SecurityGroupId,
tblAWSSecurityGroupPermission.FromPort
Test Drive Lansweeper Yourself. Explore our interactive Demo or sign up for free 14-day trial.
Try Now