SIM - How to create a collection list against CW colum

[Mariano De Luca]

Using SIM 5.1 SP1 w\ISEE\OSEM
Windows 2003 Server
I can't figure out how to do this. I want to be able to create a collections list to list only servers that cannot display a contract\warranty status, so basically all that show a BLUE?.

[David Claypool]

No, that is not a query item for creation of a collection. You can get there from here, though, by clicking the CW column to sort it and put all the blue ones together.

[Mariano De Luca]

Won't help as I have over 1000 servers and would take for ever to do this. I wonder if it can be done in sql?

[Kevin Brusky]

You might try something like

select DeviceKey from deviceStatusValue where statusValue = 0 and statusSourceId in
(select StatusSourceId from deviceStatusSources where StatusSourceName like 'hp.isee.entitlement')

I'm not sure what exact status value you're looking for, so you might want to look in the DB for a device with that status and see what the value is.

Let me know if you have additional questions about this.