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’
Subscribe to:
Post Comments (Atom)
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...
-
Application app enforcement deployment status with installation errors select distinct vrs.user_name0,fn.machinename,fn.applicationnam...
-
select SMS_R_System.Name, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS...
-
select Name0, netbios_name0,user_name0,ProdID0 ,Displayname0, installdate0,publisher0,version0 from v_r_system inner join v_Add_Remove_Prog...
No comments:
Post a Comment