SCCM 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’

Comments

Popular posts from this blog