Reboot status reports: differences

[Pablo Llorente]

Hello,

Could someone explain me the differences between the report called: "Computer Requering Restart" that is located under Patch Management Menu:

and the ones that check the table  Inv_AeX_AC_Client_Status. 

Im asking because in the first one, filtering by "All Site Servers"  Im getting that only 1 Task Server is pending of reboot but using the one published by @Igor Perevozchikov here I am getting 64 results (using the same filter) I am getting 66 Task Servers pending to be rebooted. 

In any case Im appliying a policy that reboots Task Servers when it is needed using an schedule, but Im realizing that almost all site servers are being rebooted even when the reports are saying that no reboot is pending. 

Thanks for your help.

[Igor Perevozchikov]

Hello Pablo Llorente!

1. "Restart status" patch management solution report works using stored procedure spPMCore_RebootStatusReport
This stored procedure checks this SQL table "Inv_Software_Update_Distribution_Status" to check there "DistributionStatus" column for value 65536 which is set by event from "Software Update Agent" if there are installed patch update(s) which require reboot
Once computer will be rebooted, then "Software Update Agent" will check that patch is installed, reboot is done and then removes this pending reboot state

2. This custom report https://community.broadcom.com/symantecenterprise/viewdocument/report-to-see-current-pending-rebo?CommunityKey=ef59d715-7ea1-41c6-97f3-dd1bcc10d0c3&tab=librarydocuments is based on "Inv_AeX_AC_Client_Status" sql table and if "MachineState" column = 1 (means that there is a pending reboot state in Operating System and not caused exactly by event from "Software Update agent" after patch update(s) installation, but probably there are other reasons of pending reboots, like computer domain join, computer name rename, WUA installed updates with pending reboot state) this information is checked by Symantec Management Agent in current Operating system registry.

You can try powershell script to check pending reboot state 

Best regards,
IP.

[Pablo Llorente]

Thanks a lot for the clarification Igor, as always.

Best Regards / Saludos
___________________________

PABLO LLORENTE ABAD
EMEA Workplace Services , Workplace Specialist

Calle Albasanz 14, 4th floor
Madrid , Spain
Mobile [phone]
*[e-mail] <[e-mail]>**
<http: www.holcim.com/="">*
*www.holcim.com <http: www.holcim.com/="">*

Follow us on Facebook <https: www.facebook.com/lafargeholcimitemea/=""> |
Twitter <https: twitter.com/lhitemea=""> | LinkedIn
<https: www.linkedin.com/company/lafargeholcimitemea/="">

*To visit our Workplace Connect site click here
<https: connect.lafargeholcim.com/emea-digital-center/functions/it-security/emea-workplace-services="">*

This email is confidential and intended only for the use of the above named
addressee. If you have received this email in error, please delete it
immediately and notify us by email or telephone.


On Wed, Sep 27, 2023 at 3:24 PM Igor Perevozchikov via Broadcom <
[e-mail]> wrote:

> Hello Pablo Llorente! 1. "Restart status" patch management solution report
> works using stored procedure spPMCore_RebootStatusReport This stored...
> [image: Broadcom] <https: community.broadcom.com="">
> IT Management Suite
> <https: community.broadcom.com/symantecenterprise/communities/community-home/digestviewer?communitykey="bf23126f-6eab-4bbe-965d-e26838c079e0">
> Post New Message <[e-mail]>
> Re: Reboot status reports: differences
> <https: community.broadcom.com/symantecenterprise/discussion/reboot-status-reports-differences#bm686241d2-c3c6-4854-b35e-018ad6dd38e9="">
> Reply to Group
> <[e-mail]?subject=re:+reboot+status+reports:+differences> Reply
> to Sender
> <https: community.broadcom.com/symantecenterprise/communities/all-discussions/postreply?messagekey="686241d2-c3c6-4854-b35e-018ad6dd38e9&ListKey=ad954693-81d5-45f1-b537-10e91ba3a313&SenderKey=a5296633-d529-450c-96ec-c4a968a6e9b1">
> [image: Igor Perevozchikov]
> <https: community.broadcom.com/network/members/profile?userkey="a5296633-d529-450c-96ec-c4a968a6e9b1">
> Sep 27, 2023 9:24 AM
> Igor Perevozchikov
> <https: community.broadcom.com/network/members/profile?userkey="a5296633-d529-450c-96ec-c4a968a6e9b1">
>
> Hello Pablo Llorente
> <https: community.broadcom.com/symantecenterprise/network/members/profile?userkey="278d1fe0-fb09-485d-bc03-377654f3d842">
> !
>
> *1.* "*Restart status"* patch management solution report works using
> stored procedure *spPMCore_RebootStatusReport*
> This stored procedure checks this SQL table "
> *Inv_Software_Update_Distribution_Status*" to check there "
> *DistributionStatus*" column for value *65536* which is set by event from
> "Software Update Agent" if there are installed patch update(s) which
> require reboot
> Once computer will be rebooted, then "Software Update Agent" will check
> that patch is installed, reboot is done and then removes this pending
> reboot state
>
> *2. *This custom report
> community.broadcom.com/symantecenterprise/viewdocument/...
> <https: community.broadcom.com/symantecenterprise/viewdocument/report-to-see-current-pending-rebo?communitykey="ef59d715-7ea1-41c6-97f3-dd1bcc10d0c3&tab=librarydocuments">
> is based on "*Inv_AeX_AC_Client_Status*" sql table and if "*MachineState*"
> column = 1 (means that there is a pending reboot state in Operating System
> and not caused exactly by event from "Software Update agent" after patch
> update(s) installation, but probably there are other reasons of pending
> reboots, like computer domain join, computer name rename, WUA installed
> updates with pending reboot state) this information is checked by Symantec
> Management Agent in current Operating system registry.
>
> You can try powershell script to check pending reboot state
>
> Best regards,
> IP.
> *Reply to Group Online
> <https: community.broadcom.com/symantecenterprise/communities/all-discussions/postreply?messagekey="686241d2-c3c6-4854-b35e-018ad6dd38e9&ListKey=ad954693-81d5-45f1-b537-10e91ba3a313">*
> *Reply to Group via Email
> <[e-mail]?subject=re:+reboot+status+reports:+differences>*
> *View Thread
> <https: community.broadcom.com/symantecenterprise/discussion/reboot-status-reports-differences#bm686241d2-c3c6-4854-b35e-018ad6dd38e9="">*
> *Recommend
> <https: community.broadcom.com:443/symantecenterprise/discussion/reboot-status-reports-differences?messagekey="686241d2-c3c6-4854-b35e-018ad6dd38e9&cmd=rate&cmdarg=add#bm686241d2-c3c6-4854-b35e-018ad6dd38e9">*
> *Forward
> <https: community.broadcom.com/symantecenterprise/communities/all-discussions/forwardmessages?messagekey="686241d2-c3c6-4854-b35e-018ad6dd38e9&ListKey=ad954693-81d5-45f1-b537-10e91ba3a313">*
> *Flag as Inappropriate
> <https: community.broadcom.com/symantecenterprise/discussion/reboot-status-reports-differences?markappropriate="686241d2-c3c6-4854-b35e-018ad6dd38e9#bm686241d2-c3c6-4854-b35e-018ad6dd38e9">*
>
> -------------------------------------------
> Original Message:
> Sent: Sep 27, 2023 06:16 AM
> From: Pablo Llorente
> Subject: Reboot status reports: differences
>
> Hello,
>
> Could someone explain me the differences between the report called:
> "Computer Requering Restart" that is located under Patch Management Menu:
>
> and the ones that check the table *Inv_AeX_AC_Client_Status. *
>
> Im asking because in the first one, filtering by "All Site Servers" Im
> getting that* only 1 Task Server *is pending of reboot but using the one
> published by @Igor Perevozchikov
> <https: community.broadcom.com/network/members/profile?userkey="a5296633-d529-450c-96ec-c4a968a6e9b1"> here
>
> <https: community.broadcom.com/symantecenterprise/viewdocument/report-to-see-current-pending-rebo?communitykey="ef59d715-7ea1-41c6-97f3-dd1bcc10d0c3&tab=librarydocuments">I
> am getting 64 results (using the same filter) I am getting *66 Task
> Servers pending to be rebooted. *
>
> In any case Im appliying a policy that reboots Task Servers when it is
> needed using an schedule, but Im realizing that almost all site servers are
> being rebooted even when the reports are saying that no reboot is pending.
>
> Thanks for your help.
>
>
>
>
>
> You are subscribed to "IT Management Suite" as
> [e-mail]. To change your subscriptions, go to My
> Subscriptions
> <http: community.broadcom.com/preferences?section="Subscriptions">. To
> unsubscribe from this community discussion, go to Unsubscribe
> <http: community.broadcom.com/higherlogic/egroups/unsubscribe.aspx?userkey="278d1fe0-fb09-485d-bc03-377654f3d842&sKey=KeyRemoved&GroupKey=ad954693-81d5-45f1-b537-10e91ba3a313">.
>
>
> Copyright © 2005-2023 Broadcom. All Rights Reserved. The term "Broadcom"
> refers to Broadcom Inc. and/or its subsidiaries.
>
> Hosted by Higher Logic, LLC on the behalf of Broadcom - Privacy Policy
> <https: www.broadcom.com/company/legal/privacy-policy=""> | Cookie Policy
> <https: www.higherlogic.com/legal/privacy=""> | Supply Chain Transparency
> <https: www.broadcom.com/company/citizenship/governance-and-ethics#supply="">
> | Terms of Use <http: termsandconditions="">
>