Client Management Suite

Hi All,

I have created a easy SQL Query for Task Server "Pending Reboot" status.

In this query output, You have check the Version of task server where server is pending for reboot. You can create a report on ITMS console as create SQL report. Below is the query:-

=========================================================

select 
vc.Name,vc.[IP Address],vc.[User],ap.DisplayName,ap.DisplayVersion, 
(CASE WHEN cs.[MachineState] = 1 THEN 'Yes'    ELSE 'No'    END) AS PendingReboot
from Inv_AddRemoveProgram AP
join vComputer vc on vc.Guid=ap._ResourceGuid
inner join [Inv_AeX_AC_Client_Status] cs on cs._ResourceGuid=vc.Guid
where ap.DisplayName like '%Client Task Server%'

=========================================================