Tuesday, July 18, 2017

SQL Query To Retrieve Clients Last Boot up Date

SQL Query To Retrieve Clients Last Boot up Date:
-------------------------------------------------

Select

SD.Name0 ‘Machine Name’,

SD.User_Name0 ‘Last Logged on User Name’,

Convert(VarChar(10), OS.LastBootUpTime0, 101)  ‘Last Boot Date’

From v_R_System SD

Join v_Gs_Operating_System OS on SD.ResourceID = OS.ResourceID

Order By ‘Machine Name’





No comments:

Post a Comment

site backup job manually

Start a scheduled SCCM 2012 site backup job manually You might want to start a scheduled SCCM 2012 site backup job manually. off co...