Computers requiring reboot information

Products

• Server Management Suite

Issue/Introduction

Pending Reboot status in Windows is tracked by Symantec Management Agent and provided to server in Inv_AeX_AC_Client_Status dataclass

Environment

ITMS 8.7 and above

Cause

n/a

Resolution

Following query lists all computers with pending reboot status:

SELECT
_ResourceGuid,
CASE WHEN ([MachineState] & 0x01) = 0x01 THEN 1 ELSE 0 END AS IsPendingReboot
FROM Inv_AeX_AC_Client_Status