What tables are needed to write a crystal report on how many incidents my analysts have closed?

Version 1

    These tables should provide the basic information required – tps_user usually holds the analyst names under tps_name and the im_incident_closure table holds any closures which they have made.  If you prefer to use resolution data then the table you need is im_incident_resolution and this links in the same way as im_incident_closure does.

    table linking.bmp

    Here I am showing who the analyst was who closed the incident rather than who it was currently assigned to when closed.  If you would prefer to look at who the incident was assigned to please also see this community document:

    http://community.landesk.com/support/docs/DOC-3571