Default Sort by IP Address

[sbarbee]

Don't know why this isn't a "feature" already. EVERY TIME you enter the IP Location page you have to sort by IP address manually. Extremely frustrating. Default is by AssetName and apparently can't be changed.

[Esben_D]

Correct. I'll link your topic to the existing feature request.

Since these views are basically just reports, you can use the report below instead of the view. Just change the IP Location to the one you want.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblAssetCustom.Location,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As Type,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress As [IP Address],
tblAssets.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
Where tsysIPLocations.IPLocation Like 'Your IP Location' And
tblAssetCustom.State = 1
Order By tblAssets.IPNumeric