Joyce Posted April 24, 2018 Posted April 24, 2018 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
Lyonel Posted April 24, 2018 Posted April 24, 2018 @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.
Joyce Posted April 25, 2018 Author Posted April 25, 2018 @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.
Joyce Posted April 25, 2018 Author Posted April 25, 2018 @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
Lyonel Posted April 26, 2018 Posted April 26, 2018 @Joyce, Have a look in this table: h_sys_timer_events You might be able to join things together
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