incorrect reporting of servers that are pending a restart due to security updates

Hi guys

We have a query that should detail machines that are pending a restart. However when the query is run the output isnt accurate, by which is shows machines that do not require a restart along with ones that do

Can anyone notice any glaring errors in the below query?

Thanks in advance

Richard

SELECT DISTINCT

                      sms_r_system.Name0 AS Hostname, dbo.System_DATA.SystemRole0 AS Type, sms_r_system.User_Name0 AS Username,

                      dbo.v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 AS Site, sms_r_system.AD_Site_Name0 AS [AD Site], sms_r_system.Client0 AS Client,

                      sms_r_system.Last_Logon_Timestamp0 AS [Last Logon], sms_r_system.Obsolete0 AS Obsolete,

                      sms_r_system.Operating_System_Name_and0 AS [OS Version]

FROM         dbo.vSMS_R_System AS sms_r_system INNER JOIN

                      dbo.vSMS_Update_ComplianceStatus AS SMS_UpdateComplianceStatus ON SMS_UpdateComplianceStatus.MachineID = sms_r_system.ItemKey INNER JOIN

                      dbo.v_RA_System_SMSAssignedSites ON sms_r_system.ItemKey = dbo.v_RA_System_SMSAssignedSites.ResourceID INNER JOIN

                      dbo.System_DATA ON sms_r_system.ItemKey = dbo.System_DATA.MachineID

WHERE    

(SMS_UpdateComplianceStatus.LastEnforcementMessageID = 9)  AND

(dbo.System_DATA.SystemRole0 = @Type OR @Type IS NULL) AND

(dbo.v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 = @Site OR @Site = '[All]') AND

(AD_Site_Name0 = @ADSite OR @ADSite = '[All]')

ORDER BY Site, Hostname

April 2nd, 2013 7:13pm

This part workes for me, I can't test the other part of the statement.

SELECT DISTINCT
                         sms_r_system.Name0 AS Hostname, dbo.System_DATA.SystemRole0 AS Type, sms_r_system.User_Name0 AS Username,
                         dbo.v_RA_System_SMSAssignedSites.SMS_Assigned_Sites0 AS Site, sms_r_system.AD_Site_Name0 AS [AD Site], sms_r_system.Client0 AS Client,
                         sms_r_system.Last_Logon_Timestamp0 AS [Last Logon], sms_r_system.Obsolete0 AS Obsolete,
                         sms_r_system.Operating_System_Name_and0 AS [OS Version], SMS_UpdateComplianceStatus.LastEnforcementMessageID
FROM            dbo.vSMS_R_System AS sms_r_system INNER JOIN
                         dbo.vSMS_Update_ComplianceStatus AS SMS_UpdateComplianceStatus ON SMS_UpdateComplianceStatus.MachineID = sms_r_system.ItemKey INNER JOIN
                         dbo.v_RA_System_SMSAssignedSites ON sms_r_system.ItemKey = dbo.v_RA_System_SMSAssignedSites.ResourceID INNER JOIN
                         dbo.System_DATA ON sms_r_system.ItemKey = dbo.System_DATA.MachineID
WHERE        (SMS_UpdateComplianceStatus.LastEnforcementMessageID = 9)

Free Windows Admin Tool Kit Click here and download it now
April 3rd, 2013 4:33am

Hi Kent, thanks for testing

Just to confirm the statement also runs and produces an output for me - However the problem is that its reporting back on machines that do not require a reboot, along with ones that do

I have checked the RebootCoordinator.log and windowsupdate.log on machines that do not require a reboot and these log files confirm that a reboot is not required

So I am at somewhat of a loss on why the above statement is coming back with inaccurate data

Richard

April 3rd, 2013 1:26pm

can you check the status messages and verify that the client is sending a correct state message to the MP.
Free Windows Admin Tool Kit Click here and download it now
April 3rd, 2013 1:33pm

Focusing on one of the servers that has had updates installed successfully and rebooted - although SCCM reporting says it needs to be rebooted

RebootCoordinator.log states -

System reboot request succeeded.

Reboot initiated

Checking the client via the CAS it states that the server is active and last activity was today

The deployment for the security updates that went mandatory the weekend also states that this server being compliant

Thanks


  • Edited by ranski Wednesday, April 03, 2013 3:13 PM
April 3rd, 2013 2:45pm

I take it no one else has experienced, or noticed? inaccurate 'pending reboot' status reports since moving to SCCM 2012 SP1?

Free Windows Admin Tool Kit Click here and download it now
April 10th, 2013 8:36pm

Hi Ranski

I am also experiencing the exact phenomenon as you described.

We have SCCM 2012 SP1 CU1 installed.

I am currently checking if its a database issue but with no real conclusion yet.

I found your post trying to see if someone experience this as well.

T.

May 29th, 2013 11:16am

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?

Free Windows Admin Tool Kit Click here and download it now
February 10th, 2015 2:17pm

I am also having this problem. I have a report that gives me a list of servers that require a restart following software updates but if I select a server name from the report and restart it, it quite often remains in the report the following day.

Although the report does contain both physical and virtual servers, it seems to apply more to virtual servers than physical.

February 27th, 2015 9:54am

Since no one has answer this post, I recommend opening  a support case with Microsoft Customer Support Services (CSS) as they can work with you to solve this problem.

Free Windows Admin Tool Kit Click here and download it now
June 13th, 2015 3:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics