LAST REBOOT REPORT IN SCCM

SELECT 

CS.Name0 as‘PC Name’, 

CS.UserName0 as‘User ID’,

OS.lastbootuptime0 as‘Boot Time’

FROM 

v_GS_COMPUTER_SYSTEM CS,

v_GS_OPERATING_SYSTEM OS,

v_GS_WORKSTATION_STATUS WS

WHERE 

CS.ResourceID = OS.ResourceID

          and CS.ResourceID = WS.ResourceID

          and datediff(dd,lastbootuptime0,Getdate())> 5

          and datediff(dd,WS.LastHWScan,getdate())< 5

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s