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
