Jump to content

Widgets and Dashboard SQL Statement assitance required to provide resolved OOH P1 data


Adam Toms
 Share

Recommended Posts

Hello all,

I've been asked to look in to P1 data for one of support teams.

Essentially what I am after is all P1s in the two support queues that make up this support team that are outside of our defined office hours:

Mon - Thurs 0730 to 1715
Fri 0730 to 1645
Also weekends and bank holidays
 
I'm far from a guru in SQL but I am learning all the time. I wonder if anyone could help me build some SQL logic, to allow me to capture this data?
 
In my head I would look at request type: Incident, Priority is P1,  Team is: Team X and Team Y P1  resolved on between the following time frame: 
Mon - Thurs 0730 to 1715
Fri 0730 to 1645
Also weekends and bank holidays
During previous month.
 
Is this something that would be possible to build, or has anyone been able to get some data out similar to look what I am trying to achieve?
 
Many Thanks
Adam
 
 

 

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