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

[Adam Toms]

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