List All Amazon Web Services Instances Vpc Security Groups
Find out in which security groups your AWS VPCs are. Along with other detailed AWS information, Lansweeper retrieves security groups and their details from Amazon virtual private clouds. This report gives you an overview of all VPCs and exactly which security groups they are in. You can check whether the VPCs are in the correct security groups or if they are still missing security groups they should be included in.
AWS VPC Security Groups Query
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
