Jump to content

Report Query for Breached ticket


Joyce
 Share

Recommended Posts

Hi,

I am trying to create a report which shows owners of the ticket at the time of breach.

 

Any idea of a  query to do this? it should  select reference ID, owner, Resolve by and team.

 

Thanks

Regards,

Joyce

 

Link to comment
Share on other sites

@Joyce getting the owner at time of breach will be extremely difficult... if not impossible (unless you never change the owner as a department rule).

Using the report module, you will not be able to extract such data I am afraid.

Link to comment
Share on other sites

@Lyonel, ok.

I am trying to do a measure for count of Incidents per month, which were re-assigned after breaching. This is the query I have, I am getting zero value:

h_requesttype ='Service Request' and (h_status = 'status.resolved' OR h_status = 'status.closed') AND h_pk_reference IN(SELECT h_request_id FROM h_itsm_request_team_assignment WHERE h_previous_team_id != 'No previous team' AND h_previous_team_id != h_team_id GROUP BY h_request_id HAVING COUNT(h_request_id) >= 2) AND (h_itsm_request_team_assignment.h_assignment_timestamp > h_itsm_requests.h_fixby)

What Am I doing wrong, as there are some ticket re-assigned after breach.

Link to comment
Share on other sites

@Lyonel, ok.

I am trying to do a measure for count of Incidents per month, which were re-assigned after breaching. This is the query I have, I am getting zero value:

h_requesttype ='Service Request' and (h_status = 'status.resolved' OR h_status = 'status.closed') AND h_pk_reference IN(SELECT h_request_id FROM h_itsm_request_team_assignment WHERE h_previous_team_id != 'No previous team' AND h_previous_team_id != h_team_id GROUP BY h_request_id HAVING COUNT(h_request_id) >= 2) AND (h_itsm_request_team_assignment.h_assignment_timestamp > h_itsm_requests.h_fixby)

What Am I doing wrong, as there are some ticket re-assigned after breach.

Any Thoughts @Lyonel

 

 

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...