asked on

SCCM 2007- Query for machines that do not have a TPM

I need to check machines that do not have a Trusted Platform Module (TPM). How do I use SCCM 2007 to query for machines that do not have a TPM? DCM or a query?

ASKER CERTIFIED SOLUTION

merowinger

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

clintonbrigham

ASKER

The MOF already had the correct settings. I was missing what type of WMI class to use in the query and you provided it. Ultimately I was looking for WMI class.

Ian-Rolston

I have enabled "OS deployment - Bitlocker" in the SMSdef.MOF
updated the policy on the client and run a hardware inventory.

Two questions

1.What tables will this create in the database?
&
2. How do i query this, Any chance you can post the query syntax?

Thanks

clintonbrigham

ASKER

>>What tables will this create in the database?

I have no idea. I do not deal with the database at my level.

>>How do i query this, Any chance you can post the query syntax?

You can use a simple query when creating a collection or a report. I use this on a collection based on version:

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_G_System_TPM on SMS_G_System_TPM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_TPM.SpecVersion = "Not Supported"