The BP DB contains a lot of information that could useful for admin/BAU/audit/upgrade yet much of it cannot be extracted into a report. It would be nice to have a suite of reports made available. For example:
- Asset inventory
- All objects, pages, input/outputs, descriptions
- Top-down dependencies, ie what objects, queues etc each process uses
- Bottom-up dependencies, eg what is using each object, queues etc
- Credentials - expiry date, last used date, access rights etc
- Queue volumes
- Asset 'last used date' (eg what is obsolete)
- Activity reports
- Session history including termination reasons
- Change log per process/object/whatever
- Activity log per resource (which machines are used most and least)
- User reports
- Users, roles, permissions etc
- Activity per user
- Current user activity (who's logged in now, who's got control room open etc)
- System reports
- All BP client system settings (for comparing environments)
Perhaps users could call stored procedures via Data Gateways instead of having to query tables directly.
