PENDING SCCM Compliance Status query

[dj3094]

Hello I am trying to create a collection with below query, i ma getting syntax error

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_UpdateComplianceStatus on SMS_UpdateComplianceStatus.machineid=sms_r_system.resourceid
where SMS_UpdateComplianceStatus.LastEnforcementMessageID = 11

when i do it manually, I couldnt find attribute class for SMS_UpdateComplianceStatus. Please help

 

[Garth]

Can you create a query using the above?

 

[dj3094]

I have added all attributes except innerjoin and where clause, as i could not find SMS_UpdateComplianceStatus

 

[Garth]

Not all classes are available within the Interface.

 

[dj3094]

thanks Garath,
So what query should i use to get workstations with failed windows updates?
also workstations with no reboot more than 30 days?

 

[Garth]

I wouldn't I would use the built-in reports for this.

 

[rajeshpramar]

Hi all, i do have one concern, Is there any option to execute .bat or .vbs file on bulk systems.
If yes please suggest how. I will be very thank full.

 

[Garth]

I'm not following you, what does this have to do with Software Update collections?

 

[rajeshpramar]

I have deployed software update on my collection14 days back but still as I can see lots of machines which status are unknown (Client check passed/Active And Client check passed inactive).So wanted to restart SMS agent services in all local machine after renaming Registry.pol file. It is 400 counts of all machines.

 

[rajeshpramar]

Garth,
Your help would be highly appreciated

 

[Garth]

I have deployed software update on my collection14 days back but still as I can see lots of machines which status are unknown (Client check passed/Active And Client check passed inactive).So wanted to restart SMS agent services in all local machine after renaming Registry.pol file. It is 400 counts of all machines.

Why do you want to do that? Have you tested this on one computer to confirm that it solves the problem? Why would you need to restart the SMS Agent to rename the registry.pol services?

Have you written batch file already? Does it work when you deploy it to a test computer?

 

[rajeshpramar]

Thanks for your response Garth,
What is your opinion on this issue (Client check passed/Active And Client check passed/inactive) .