<div>
I'm not a SCCM guy but PowerShell could provide the info you need:<br />
<br />
<a href="http://powershellblogger.com/2016/01/get-last-computer-boot-time-or-up-time-with-powershell/" rel="ugc">http://powershellblogger.com/2016/01/get-last-computer-boot-time-or-up-time-with-powershell/</a>
</div>


I'm not a SCCM guy but PowerShell could provide the info you need:

http://powershellblogger.com/2016/01/get-last-computer-boot-time-or-up-time-with-powershell/ [http://powershellblogger.com/2016/01/get-last-computer-boot-time-or-up-time-with-powershell/]

<div>
<div class="content wysiwyg-content">
hello , <br />
<br />
i need sccm query to get the uptime for machines installed . anyone can help on provide this .<br />
<br />
i have the below query and given syntax error :<br />
<br />
SELECT<br />
cs.Name0 AS 'ComputerName',<br />
DATEDIFF(HOUR, os.LastBootUpTime0, ws.LastHWScan)<br />
AS 'Uptime (in Hours)',<br />
CONVERT(VARCHAR(26), os.LastBootUpTime0, 100)<br />
AS 'Last Reboot Date/Time',<br />
CONVERT(VARCHAR(26), ws.LastHWScan, 101)<br />
AS 'Last Hardware Inventory'<br />
FROM<br />
dbo.v_GS_WORKSTATION_STATU<wbr />S ws<br />
LEFT OUTER JOIN dbo.v_GS_Operating_System os<br />
ON ws.ResourceID = os.ResourceID<br />
LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM cs<br />
ON cs.ResourceID = os.ResourceID<br />
WHERE os.Caption0 LIKE '%server%'<br />
ORDER BY os.LastBootUpTime0 ASC
</div>
</div>


hello , 

i need sccm query to get the uptime for machines installed . anyone can help on provide this .

i have the below query and given syntax error :

SELECT
cs.Name0 AS 'ComputerName',
DATEDIFF(HOUR, os.LastBootUpTime0, ws.LastHWScan)
AS 'Uptime (in Hours)',
CONVERT(VARCHAR(26), os.LastBootUpTime0, 100)
AS 'Last Reboot Date/Time',
CONVERT(VARCHAR(26), ws.LastHWScan, 101)
AS 'Last Hardware Inventory'
FROM
dbo.v_GS_WORKSTATION_STATUS ws
LEFT OUTER JOIN dbo.v_GS_Operating_System os
ON ws.ResourceID = os.ResourceID
LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM cs
ON cs.ResourceID = os.ResourceID
WHERE os.Caption0 LIKE '%server%'
ORDER BY os.LastBootUpTime0 ASC

SCCM query to get uptime for all machines

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Operating Systems

Systems Center Configuration Manager (SCCM, formerly known as Systems Management Server) is Microsoft’s system software for managing large groups of not only Microsoft computers, but those running other operating systems, such as Linux, OS-X, and various mobile technologies.

SCCM

Hardware includes cell phones and other digital living devices, tablets, computers, servers, peripherals and components, printers and scanners, gaming consoles, networking hardware such as routers, hubs, switches and modems, storage devices and security equipment such as firewalls and other appliances.