Are you good at SQL? You could build a custom report to grab the data you need. Look at the SQL code from the canned report to identify which tables the data is coming from.

-Tony

• Edited by Tony Chirillo Thursday, April 23, 2015 3:31 PM

Are you good at SQL? You could build a custom report to grab the data you need. Look at the SQL code from the canned report to identify which tables the data is coming from.

-Tony

• Edited by Tony Chirillo Thursday, April 23, 2015 3:31 PM

I'm currently looking for a way to report Computer Activity (users actually using the computer) and found a report in SCCM 2012 called "Power Management - Computer activity by computer".

The report displays computer activity for one computer over the course of one day.  What I would like to do is have that same report, but for for a collection of computers and over the course of a specific date range.  I wasn't able to find another report that can show this, and unfortunately report creation is not my strong point.  

Any ideas on another report that can be utilized to provide this or similar data?  Again, the key piece of information I'm looking for is computer activity, in order to identify devices that are not properly being utilized or can be retired from lack of use.

Thanks in Advance!

Are you good at SQL? You could build a custom report to grab the data you need. Look at the SQL code from the canned report to identify which tables the data is coming from.

-Tony

• Edited by Tony Chirillo 16 hours 15 minutes ago

Unfortunately SQL is not my strong point, I've created some base reports, but nothing as complicated as this one.

Hi,

How about the Power Management - Computer activity report?

Best Regards,

Joyce

Damion

Do you know how to added SQL report into SRS so it can show up in SCCM? -Tony

Yes I know how to add a SQL report.