In case anyone was interested: select a.DataItemID,b.SMSClassID,a.Filter,a.Timeout from DataItem a inner join InventoryClass b on a.ClassID=b.ClassID where a.ActionID=N'<Inventory Report ID' ORDER BY SMSCLassID Thanks Mr. Russ Rimmerman! I was having an issue where if I deleted a Client Setting that was the original of a copied client setting SCCM would also delete the HW inventory class selections of all client settings copied from it. Essentially SCCM would delete the SMS_InventoryReport class instance on the site server that all the client setting copies are referencing. The root cause is that each time you copy a client setting it is not creating a NEW SMS_InventoryReport instance. It is a known bug and should be fixed in a later release. -Stephen
From: [email protected] To: [email protected] Subject: [mssms] Extracting HW Inventory Selectings of Client Settings in SQL Date: Tue, 10 Mar 2015 10:41:17 -0500 Does anyone know how to extract what classes are selected in a client settings policy via SQL? The ClientSettings table has the name of each client settings, however I'm unsure of how to extract exactly what the settings are and what HW inventory classes are selected. Thank you, Stephen
