SQL Query for AMT Driver Details

[addax]

Hi All,

 

I am stuck on creating a custom report on AMT Drivers Details.

The one I am trying with is the provided from Intel:

 

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_AMT_AGENT on SMS_G_System_AMT_AGENT.ResourceID = SMS_R_System.ResourceId where SMS_G_System_AMT_AGENT.AMT >= "0" and (SMS_R_System.AMTStatus != "3" or SMS_R_System.AMTStatus is NULL)

 

 

The problem is it doesn't work with SCCM 2012.

Does anyone know how to fix it?

 

Thanks in advance!

 

Regards,

Petar