List All Amazon Web Services Security Groups
Find which security groups your AWS instances are in. Along with other detailed AWS information, Lansweeper retrieves security groups and their details from Amazon Web Services. This report gives you an overview of all instances and which security groups they are a part of in your AWS environment. This overview allows you to quickly see if an instance is not yet part of a security group it should be in.
AWS Instance Security Groups Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, tsysIPLocations.IPLocation, tblAssetCustom.Manufacturer, tblAWSInstance.InstanceId, tblAWSInstance.InstanceType, tblAWSInstance.Platform, tblAWSInstance.Region, tblAWSInstance.State, tblAWSSecurityGroup.GroupId As SecurityGroupId, tblAWSSecurityGroup.Name, tblAWSSecurityGroup.OwnerId, tblAWSSecurityGroup.Description From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Inner Join tblState On tblState.State = tblAssetCustom.State Inner Join tblAWSInstance On tblAWSInstance.AssetId = tblAssets.AssetID Inner Join tblAWSInstanceSecurityGroup On tblAWSInstanceSecurityGroup.AWSInstanceId = tblAWSInstance.AWSInstanceId Inner Join tblAWSSecurityGroup On tblAWSSecurityGroup.AWSSecurityGroupId = tblAWSInstanceSecurityGroup.AWSSecurityGroupId Where tblState.Statename = 'Active' Order By tblAWSInstance.Region, tblAssets.IPNumeric, SecurityGroupId