Reports By Location

[atkinsjd]

Is there any way to easily create reports based on location without creating custom report for each one? I have over 450 locations and would like the ability to run each report in "All Reports" without having to create 450 versions of each one.

[atkinsjd]

Thank you.

[Hemoco]

You could build a report based on the sample report below and filter the IPLocation column within the report results.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetCustom.State = 1

[atkinsjd]

IP Address Range Locations

[Hemoco]

Could you clarify which "location" field you are referring to. There are several.