Jump to content

Report on assigned date


Alisha
 Share

Recommended Posts

Hello,

Is it possible to use a filter or create a report for when requests were assigned to a certain team?

It would be helpful if we could have an 'Assigned Date' in the filter.

Many thanks,
Alisha

Link to comment
Share on other sites

@Alisha although there is a field in the database that specifies what team the request resides with, I don't see one for when it was assigned so that would make a filter problematic.  There is also the issue of the request potentially being reassigned several times during its life cycle. 

Link to comment
Share on other sites

@Alisha disregard the above for reports, as _itsm_request_team_assignment  is a separate table  that contains the info you are after.   The h_assignment_timestamp field will contain the assignment time and h_team_id the team it was assigned to.

  • Thanks 1
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...