Sort monitor report by IP/Location or asset group of parent device

[nick9876]

Is it possible to sort the monitor list by the PC it is connected to location?

[Hemoco]

Please use the following report to get the ip location:

Select Top 1000000 tblAssets1.AssetID,
tblAssets1.AssetName,
tsysIPLocations.IPLocation
From tblAssets
Inner Join tblAssetRelations
On tblAssets.AssetID = tblAssetRelations.ParentAssetID
Inner Join tblAssets tblAssets1 On tblAssetRelations.ChildAssetID =
tblAssets1.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets1.Assettype
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetRelations.Type = 3 And tsysAssetTypes.AssetTypename = 'monitor'
Order By tsysIPLocations.IPLocation



The following report will give the asset groups:

Select Top 1000000 tblAssets1.AssetID,
tblAssets1.AssetName,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblAssetRelations
On tblAssets.AssetID = tblAssetRelations.ParentAssetID
Inner Join tblAssets tblAssets1 On tblAssetRelations.ChildAssetID =
tblAssets1.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets1.Assettype
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetRelations.Type = 3 And tsysAssetTypes.AssetTypename = 'monitor'
Order By tblAssetGroups.AssetGroup