cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ITninja
Engaged Sweeper
Is there anyway to get relation items like monitors to show up in the same IP location as the assets it is connected to in a report?

Thanks!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
You can use the following report to get all monitors in a IP location. You just need to change the yellow word with the name of the ip location that you want to filter on.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
tblAssets1.AssetID,
tblAssets1.AssetName,
tsysAssetRelationTypes.Name,
tblAssets.AssetName As host,
tsysIPLocations.IPLocation
From tblAssets
Inner Join tblAssetRelations
On tblAssets.AssetID = tblAssetRelations.ParentAssetID
Inner Join tsysIPLocations
On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
tsysIPLocations.EndIP
Inner Join tsysAssetRelationTypes On tblAssetRelations.Type =
tsysAssetRelationTypes.RelationTypeID
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetRelations.ChildAssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets1.Assettype
Where tsysAssetRelationTypes.Name = 'connected to' And
tsysIPLocations.IPLocation = 'local subnet' And tsysAssetTypes.AssetTypename =
'monitor'

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
You can use the following report to get all monitors in a IP location. You just need to change the yellow word with the name of the ip location that you want to filter on.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
tblAssets1.AssetID,
tblAssets1.AssetName,
tsysAssetRelationTypes.Name,
tblAssets.AssetName As host,
tsysIPLocations.IPLocation
From tblAssets
Inner Join tblAssetRelations
On tblAssets.AssetID = tblAssetRelations.ParentAssetID
Inner Join tsysIPLocations
On tblAssets.IPNumeric Between tsysIPLocations.StartIP And
tsysIPLocations.EndIP
Inner Join tsysAssetRelationTypes On tblAssetRelations.Type =
tsysAssetRelationTypes.RelationTypeID
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetRelations.ChildAssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets1.Assettype
Where tsysAssetRelationTypes.Name = 'connected to' And
tsysIPLocations.IPLocation = 'local subnet' And tsysAssetTypes.AssetTypename =
'monitor'