Reporting on Activities

[Ann-MarieHolloway]

Morning all,

My apologies if this has been raised before, I wasn't able to locate it via a quick look.  We have a number of reports running to give us figures on tickets being resolved/closed etc by various teams and individuals however it would appear activities are not recorded in these figures.

Is there a way to report on active/resolved/closed activities within Service Manager?  

Many Thanks

[Lyonel]

@Ann-MarieJones yes there are multiple ways to report on activities. The table you need is "h_sys_tasks" from where you can get all the details you need from the activity. What are you looking for exactly?

[Ann-MarieHolloway]

Brilliant, thank you Lyonel.

I basically want to ensure all the work being carried out by the teams is recorded, to provide a true picture to management about how many 'tickets' we are closing.   The reports we currently use go into great detail, however activities aren't accounted for and it's a big part of the work of our Business Processes.