Detecting Window 7 machines using SCCM
if you are building a collection there are a couple of criteria that work.
I use the following one because I didn’t need to distinguish between 64/32 bit:
Criterion Type: Simple Value
Where: Operating System – Caption
Operator: is like
Value: %Windows 7%
If you know how to do WHQL you can write complex collection building queries.. if you don’t you can cheat.
Make a Collection that filters for Windows 7 as illustrated above. Them using the same Attribute Class (Operating System) make a new collection that uses the previous query as it limiter, then build a collection that uses Operating System – OS Architecture… then keep nesting collections until you get it as narrow and specific as you need it.
If you are trying to do something other than build a collection, that answer gets more complicated.
Or there is a lookup that can be done on dell site?
If it just the first one, then SCCM should be able to do it. If it needs some lookup in spreadsheets then it is not that easy.
If the model numbers/Installation date can give a reasonable guess to the purchase order then SCCM may be able to help to guess those.