My client is Using Version 6 and I need to show a simple SQL view that reports their incidents and requests separately just with basic data on age of request, closed or open etc. 

I've never seen your product before and just looking at the huge table structure makes no sense to me. 

Could you point me to a link to an Entity Relationship Diagram or at least to the "incident" "request" etc table that I need to show the live and closed reported events.

Thanks

Bob