MySQL query - List of ticket(s) resolved within specific days.

MySQL query - List of ticket(s) resolved within specific days.

Hi,

Please help me to create a query for :

1) List of resolved ticket within 3 days
2) List of resolved ticket within 6 days

I also want to manipulate the query to list ticket for specific department only. Hope you can show me example.

I'm using SDP Version : 7.5.0 Build 7506 with MySQL database on SuSe.

Thanking you.

regards,
Kyle














                  New to ADSelfService Plus?