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.
... View more