I am trying to create a report using a custom application and need to query the ServiceDesk Database to find the following information.
1. Number of incidents opened in a given month
2. Number of incidents closed in a given month
3. Number of change tickets opened in a given month
4. Number of change tickets closed in a given month
The issue I have after looking through the database is that I cannot see what tables give the actual open date and closed date information.
Can anyone help?