Alisha Posted October 21, 2019 Share Posted October 21, 2019 Hello, Is there a field within h_itsm_requests for the ID of the analyst who updated the request? I can't seem to find anything for that. We need to report on how many times each analyst has added a customer as 'Impacted' each month. I've had a look at h_itsm_request_connections but can't seem to find anything that fits in that one either. Any help would be much appreciated. Many thanks, Alisha Link to comment Share on other sites More sharing options...
Bob Dickinson Posted October 24, 2019 Share Posted October 24, 2019 Hi @Alisha This information would be stored on h_buz_activities. It's not the most user friendly table as it doesn't have links immediately back to the Service Manager Request - but it actually stores all contnet on any timeline in Hornbill (not just requests - Assets, Users Buzzes etc) To help you out, I've created a report which I think covers your needs but you may want to tweak it slightly (please see attached, and you can upload it onto your instance) A few points about it: I've added a Date Prompt to this for you to do some testing. This is based on the date the Impacted connection was added to the request. You may want to change this to something variable (e.g. "Last Month") or even convert this whole report into a Measure/Widget in Advanced Analytics if you are looking for a trend analysis of sorts I havn't added added any Request Type filtering in, so this is looking at everything (Incidents, Service Requests, Changes, Problems etc) - you may want to add your own filtering You will notice that the Analyst is actually the User ID - plus is has a pretty ugly prefix for everyone (urn:sys:user:<analyst name>). I can't remove this unfortunately but hopefully its ok for your needs anyway I hope this helps - or at least points you in the right direction! Kind Regards Bob number-of-times-an-impacted-connection-has-been-added-to-a-request-monthly.report.txt 1 Link to comment Share on other sites More sharing options...
Alisha Posted October 25, 2019 Author Share Posted October 25, 2019 Hi @Bob Dickinson, This is very helpful, thank you so much! Is there a way to add the reference number to the report? Is the Activity Type the column I would use to filter out Incidents? If turned into a widget, is it possible to remove the urn:sys:user prefix? Many thanks, Alisha 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