[rt-users] Reports

[Todd Chapman]

On Sat, Nov 05, 2005 at 03:19:49AM +1100, Ben Robson wrote:
> One thing that has been done very successfully for an RT implementation I have done in the past, is reports generated via MS Access.
> 
> I know, I know... the dark one cometh....
> 
> The scenario was essentially similar for me, but I was -very- disinterested in making reports happen.  Especially for management who were very pro Microsoft.  The answer we chose was that a Read-Only account was set up in the MySQL database, and then the managers in question could query the DB using their Microsoft Access clients.
> 
> This worked very well, because it allowed them to fully view what was going on in the ticket management system, without them having any ability to modify anything.  They could then use all of the gooey goodness (*pukes*) in MS Access to generate their Crayola Compliant management reports.
> 
> The thing that was the biggest pain, was deciphering the schema of the database for RT.  We found an old schema diagram, but even then we had to essentially decode it from scratch.  (Here's a suggestion for you Jesse.  It would be extremely useful at times to have a full Entity-Relation Model data diagram showing the RT schema and its relationships.  As I said there is an older diagram floating around, but its a long way from an ER model). 
> 
> Regards,
> BenR
> 

I never give anyone direct access (even read-only) because there
is no enforcement of ACLs.