Darren Rose Posted February 2, 2018 Share Posted February 2, 2018 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 Link to comment Share on other sites More sharing options...
Victor Posted February 2, 2018 Share Posted February 2, 2018 @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 Link to comment Share on other sites More sharing options...
Steven Boardman Posted February 2, 2018 Share Posted February 2, 2018 @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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now