MWA - Expand reporting

[natewalck]

Issue by natewalck
Friday Sep 19, 2014 at 07:08 GMT
Originally opened as munki/munki#246

---

From [email protected] on May 28, 2013 18:48:04

I'm currently using MunkiReport-php but I would like to move to MWA. One enhancement that we made to MunkiReport-php that I would like to see in MWA is something we call queries. Queries is a page that adds up all the items in the database and displays them by field name. So when management asks how many Macs are still running 10.6, I can look at the queries page and see we have 80 Macs running 10.6. This is much quicker than clicking through 600+ individual report pages to compile data.

Each query has a link that shows another page that displays the Mac's name, serial number and the value of the query that's in the database.

I've attached a screen shot so you can get a better idea of what I'm talking about. I can make the php code available if you would like to see it. It's very much a a work in progress for us (student coders) and not every query is live yet.

I realize not every database field needs a query and so folks only what some queries visible. I don't know if there is a way to show/hide the ones you want. I also realize that MWA doesn't have, by default, all the fields that we expanded MunkiReport-php to show.

I showed some folks the queries pages at the PSU Mac Admin Conf Munki BOF and I received very positive feedback. I think this would be a valuable addition to MWA as it makes the data we already collect more useful. For example, we upload the AppleCare expiration date. We have query that compares the expiration date with the current date and lists all Macs expiring within 30 days. This data allows us to be proactive in reaching out to our clients (who often don't report little issues to us) to make sure everything is working before AppleCare expires.

Thoughts?

Thank you,
Marnin

Original issue: http://code.google.com/p/munki/issues/detail?id=246