SQL Query - Get Uptime and Last rebooted date from SCCM database

Query:

SELECT cs.Name0 AS Name, os.Caption0 AS 'Operating System', DATEDIFF(day, os.LastBootUpTime0, ws.LastHWScan) AS 'Uptime (in Days)', CONVERT(varchar(20),
os.LastBootUpTime0, 100) AS 'Last Reboot Date/Time', CONVERT(varchar(20), ws.LastHWScan, 100) AS 'Last Hardware Inventory'
FROM v_GS_WORKSTATION_STATUS AS ws LEFT OUTER JOIN
v_GS_OPERATING_SYSTEM AS os ON ws.ResourceID = os.ResourceID INNER JOIN
v_GS_COMPUTER_SYSTEM AS cs ON cs.ResourceID = os.ResourceID
WHERE (os.Caption0 LIKE '%server%') AND (ws.LastHWScan <> 0) AND (cs.Name0 IS NOT NULL)
ORDER BY Name

SQL Query - Get last patch update date and hotfix installed from SCCM database

Query:

Note: Before run this query has to be enabled QUICK_FIX_ENGINEERING Class on Hardware Inventory from SCCM Primary site.