All assets report in cloud sorting on IP

[Adri]

Hi Would it be possible to sort the IP addresses in this report correctly per octet? and not 1, 100, 11, 12, 2, 21, 3, etc. thanks

[rom]

Oh, my bad - i thought you meant an on-prem report about cloud assets (like Azure) - I haven't really used the cloud portion very much due to the fact that I am MSSQL-based and write more flexible queries in SSMS, as well as integrate with on-prem applications in addition to Cloud/API services.

[rom]

I'm not sure which report that is (I don't have it)  but this should work/give you the solution, you just put in whatever the IP address field the report uses in there:

Order By Cast(ParseName(tblAssets.IPAddress, 4) As INT),
  Cast(ParseName(tblAssets.IPAddress, 3) As INT),
  Cast(ParseName(tblAssets.IPAddress, 2) As INT),
  Cast(ParseName(tblAssets.IPAddress, 1) As INT)

[Adri]

HI Rom, thanks for your reply, the report that I am referring to is a standard report view in cloud (there is also on in the on prem version) to list all assets, one of the columns is ip address and that sorts not the way it should do. I am aware that in reports you create yourself it is possible to fix the sort order, Thanks, Adri