Working With Usage Data

joelande
Contributor

There is a lot of useful information in the Casper Logs.

Doing something useful with it is another thing.

Anybody have any ideas on how to reasonably achieve the following:

I want to know how often some computers are used.
In this case, they all have "Title" in the computer name.

I know I can:
1) go to inventory
2) search for Title
3) click on a computer record
4) click on Usage
5) manually select the Usage table (scrolling on into forever)
6) paste the data into a spreadsheet
7) import the spreadsheet data into a database
8) create reports in the database to summarize the data

Is there anyway I can streamline steps 1 - 6, into something that does:
Export the Usage Logs for this computer group?
(P.S. I know I can create a Smart Group based on the Title name)

''''''' ^-O-O-^
+----oOO----(_)--------------+
| Joel Anderson |
| Director of Technology |
| Hibbing Public Schools |
| www.hibbing.k12.mn.us | +----------------------oOO---+ ||| || || ooO Ooo

1 REPLY 1

jarednichols
Honored Contributor

Why go to another database? Why not just open up the JSS database with read-only access to get at the data? You could probably make some custom reports too

j