Keith Posted June 25, 2018 Share Posted June 25, 2018 Hi All, Wondered if anyone has created a reported to show the number of times a request has been assigned/reassigned? It looks like this should be possible via table h_itsm_request_team_assignment but am not sure how to best utilise the data to count number of assignments. Regards Keith Link to comment Share on other sites More sharing options...
Victor Posted June 25, 2018 Share Posted June 25, 2018 @Keith if you return all records and then group by request you should get what you need... Link to comment Share on other sites More sharing options...
Lyonel Posted June 26, 2018 Share Posted June 26, 2018 See attached: monitoring---reassignment.report.txt @Keith if you cannot import the definition attached, here are some screenshots. You can of course add the h_itsm_requests table and join on Request ID should you want more details (e.g. Service Name, Catalog, Date logged, etc.) Of course, feel free to change a few filters and stuff But be careful when adding more columns, they will screw up your report. Only 1 field from the assignment table should be returned by the report. Let me know if you need more help Link to comment Share on other sites More sharing options...
Keith Posted June 26, 2018 Author Share Posted June 26, 2018 @Victor / @Lyonel Many thanks for your help here. However, I am struggling with what is being reported. e.g. I have a request which reports 2 assignments. If I look at the request timeline I see only 1 assignment If I look at the table I see 2 I don't quite get why there is a difference in whats reported in the timeline. Keith Link to comment Share on other sites More sharing options...
Victor Posted June 26, 2018 Share Posted June 26, 2018 @Keith maybe you have an assignment somewhere in the process but the assignment node is not configured to create a timeline entry? Link to comment Share on other sites More sharing options...
Lyonel Posted June 26, 2018 Share Posted June 26, 2018 @Keith in my experience, the system will first assign the request to the team (1 line in DB) then to an analyst (another line in DB), even if this action is done at the same time. But yeah there is something funny about assignments and logging. I personally exclude from my analysis anything with less than 2 records count and focus on the rest (I have some going up to 10!). Link to comment Share on other sites More sharing options...
Keith Posted June 26, 2018 Author Share Posted June 26, 2018 @Victor That could be the case. I'll check. @Lyonel Sensible approach I think. I guess we are doing ok if the highest is 2 Link to comment Share on other sites More sharing options...
Lyonel Posted June 26, 2018 Share Posted June 26, 2018 @Keith DEFINITELY!!! I would love to have a problem with a total of 2 assignments as far as the database is concerned 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