PENDING Computer uptime report

[Bainsey]

I am trying to produce a report that shows each computers uptime since it was last rebooted.

Is there a report in SCCM that I could use to achieve this and if not has someone created one and know how to import it into SCCM?

Thanks

Bainsey

 

[Garth]

No there is not a built in report for this.

If you are using Window 7 or later, the last report time/date are not reliable due to fast booting.

 

[Marek Belan]

declare @cdate DATETIME
set @cdate = GETDATE()

SELECT System_DATA.Name0 , DATEDIFF(DAY,Operating_System_DATA.LastBootUpTime00,@cdate) as Days
FROM Operating_System_DATA INNER JOIN
System_DATA ON Operating_System_DATA.MachineID = System_DATA.MachineID

 

[Bainsey]

Thanks for the responses guys...

Garth - I never knew about "Fast boot" until your post and after reading more into it I have now created a GPO which disables it on all user devices.

Marek - Is that a query or a report?

 

[Garth]

declare @cdate DATETIME
set @cdate = GETDATE()

SELECT System_DATA.Name0 , DATEDIFF(DAY,Operating_System_DATA.LastBootUpTime00,@cdate) as Days
FROM Operating_System_DATA INNER JOIN
System_DATA ON Operating_System_DATA.MachineID = System_DATA.MachineID

Keep in mind that it is not supported to query the tables directly, only SQL views listed within the official docs are supported. https://docs.microsoft.com/en-us/sc.../create-custom-reports-using-sql-server-views There are tech reason for this.

 

[Garth]

Garth - I never knew about "Fast boot" until your post and after reading more into it I have now created a GPO which disables it on all user devices.

OK, but the question that you have to asked yourself, is the data worth more than allow fast boot? Consider that you can kind of get this data from AD logs. or even with an script using the Event logs (with SCCM).

 

[Marek Belan]

Thanks for the responses guys...

Garth - I never knew about "Fast boot" until your post and after reading more into it I have now created a GPO which disables it on all user devices.

Marek - Is that a query or a report?

yes