Jump to content

Report to show number of times assigned


Keith
 Share

Recommended Posts

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

See attached: monitoring---reassignment.report.txt

@Keith if you cannot import the definition attached, here are some screenshots.

image.thumb.png.591d43188d8d4777acafb6b3c55b3a42.png

image.thumb.png.bab13b757658f3cec54a2e52273b1e28.png

image.thumb.png.69f772c55bd36bf053376146999e7a3f.pngimage.thumb.png.3d89fb9aea8c668c92171ac4c2197de5.png

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

@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

image.png.6ec6820a461bbf05c73ac1852bbff79d.png

 

If I look at the table I see 2

image.thumb.png.0ae392a8a59fee5158cacab33364cc86.png

 

I don't quite get why there is a difference in whats reported in the timeline.

 

Keith

 

 

Link to comment
Share on other sites

@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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...