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
From tblAssets
Inner Join tblAWSContainer On tblAWSContainer.AssetID = tblAssets.AssetID
Inner Join tblAWSSecurityGroup On tblAWSSecurityGroup.AWSContainerId =
tblAWSContainer.AWSContainerId
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Order By tblAWSContainer.Region,
tblAWSContainer.VpcId,
SecurityGroupId
Explore the full platform, free for 14 days.
No credit card required.