Hardware based collections in SCCM
I thought it might be useful to have a separate collection for desktop and laptop clients.
There are off course multiple ways how this can be achieved:
- -create an LDAP query to the respective OUs in AD
- -modify the mof file and edit battery information by changing the battery and setting the battery status info to true
- -use the System Enclosure class.
I have used the last example;
First of all I created a Collection called “All Desktops or compatible”, then used a query rule with the following properties:
- Type = List of Values
- Where = System Enclosure – Chassis Types
- operator= is in
- Values: 3, 4, 6, 15
the meaning of these values can be found here: http://msdn.microsoft.com/en-us/library/aa394474(VS.85).aspx
This collection is then limited to another collection that I created earlier: “All Approved Clients” (if you want, I can post the howto about this another time …)
Finished, now for the “All Laptops or compatible” collection, the query properties are almost the same except for the values off course;
values = 8, 9, 10, 14
again this collection has been limited to my other collection called “All Approved Clients”
Then, in my environment the difference between “all approved clients” minus the sum of “all desktops” and “all laptops” (which is in fact the value 1 = other) results in all virtual computers.
Hi,
“all approved clients” — you apparently have such a collection. Can I get the query you use to identify them? We’d like the ability to distinguish approved clients in some collections and reports. It looks like it should be in v_r_system, but I can’t seem to find any such field.
Thx.
Jeff, sure you can !
this is it:
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_CM_RES_COLL_SMS00001 on SMS_CM_RES_COLL_SMS00001.ResourceId = SMS_R_System.ResourceId where SMS_CM_RES_COLL_SMS00001.IsApproved= ’1′