SOLVED SCCM Query ESU Win7 Activation

[Marcomile]

HI all,
anybody can help me about creating a query that shows up Win 7 client with ESU Key Activated?
I've to deploy ESU Key to 2500 PCs and I need to monitor the status.

 

[Gokul]

Hi There,

Good day..

Create a collection of ESU clients using below query

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_SOFTWARE_LICENSING_PRODUCT on SMS_G_System_SOFTWARE_LICENSING_PRODUCT.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SOFTWARE_LICENSING_PRODUCT.ID = "77db037b-95c3-48d7-a3ab-a9c6d41093e0" and SMS_G_System_SOFTWARE_LICENSING_PRODUCT.LicenseStatus = 1

 

[Marcomile]

Tnks.
I suppose I have to activate Software Licensing Product class in my HW inventories

 

[Gokul]

Yes before that you have enable same in the hw inventory..

 

[Marcomile]

Thank you so much. Problem Solved!
You're always great!

 

[Gokul]

cool