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