Report on Ticket Update

[Darren Rose]

Hi

I'm trying to report on when a ticket update history, in particular when done by an analyst and not a system update (BPM system manager etc...) 

I expected something to be in h_itsm_requesthistupdates, but the table is empty. Any ideas where I get ticket update history from? 

Thanks

Darren 

[Victor]

@Darren Rose from h_buz_activities... you link this table with requests table (h_itsm_requests). You make the link on h_itsm_requests.h_activity_stream_id = h_buz_activities.h_target

[Steven Boardman]

@Darren Rose another option if you are looking to get a detailed report from a request, and include and exclude certain options is to use the print option on the actual request. 

 

In your example you can exclude system updates or any others and then save to PDF.

Just another option to compliment the reporting route.