It would be nice to have a number of pre-packaged administrative reports included with Jet Web Portal now that things are being tracked such as run history, errors, etc.

SQL Server, for example, has a number of administrative reports that render in SSRS to give the admins info like table sizing, disk usage, etc. (screenshot attached)

These could be reports that ship with the Jet Web Portal and are only visible to admins to allow them to better administer Jet in their organization. Some ideas for these types of reports are:

Top run reports: shows which reports have been run the most

Top reports with errors: Shows which reports get run with errors the most so that somebody can spend some time to fix them

Least run reports: Reports that have uploaded but are seldom run. Maybe they could be improved to add more value to the business

Permissions reports,  who has access to which reports: WIth a lot of reports and a lot of users people will eventually want to be able to get a quick look at who has access to what.

Since all of the data for these should live in the JetServices database that the Jet Web Portal can already connect to then permissions shouldn't be a problem. In many cases I think a table builder report and a pivot table would suffice. The goal isn't that these reports need to look gorgeous, the idea is to provide administrative insight and a pivot with column filters would be good for this.

SQL_Reports.png

Attachments Open full size