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