I'm not sure if this is an SP3 specific bug or perhaps an issue with the query but most recently we when upgraded our consoles to SP3 we noticed that some queries seem to be sorting incorrectly.
I am looking at the column "Computer"."Software"."Add or Remove Programs"."Program"."Version" which I know contains more than just numbers so I am not sure if that's the issue.
Example, we have a query that looks for what version of AV client that computers are running.
The order goes like this..
That would be correct for a text field as 1 comes before 8, It isn't looking at 10 vs. 8, it is 1 vs. 8 as it would look at AF vs. B.
LANDesk Silver ESP
The One-Stop Shop for LANDesk Enhancements
- Wake-On-WAN - Distributed Wake-On-LAN, Scheduled Power Down, and SWDist Sequencing
- State Notifier - Real-Time Device & User State Inventory Updating & Alerting
Retrieving data ...