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
