In the inventory go to 'OS | NT infor', at the right pane there is one attribute for 'Service Pack'. You can query against this field.
You could also use Patch Manager for this - create a custom defnition.
"In theory" Patch isn't really meant as a software distribution tool, but I've abused it as such before in specific situations. The soft-dist mechanisms are quite the same as the rest of LANDesk, so that's great for this sort of scenario.
LANDesk EMEA Technical Lead.
Ive not really used the Patch manager before - How would I get the client to call a distribution script on demand from patch manager....