Can I get a list of on-call people for a selected month with their time spent on on-call?

[Marcel Sarvaš]

Hi all,

I am playing with Postman and Opsgenie. I configured the link between them and I am getting some results. 

I wonder if there is a way to show a list of people on oncall during a selected month with the time they spent on the oncall (preferably divide it if that was just standby or real oncall)? Or if it is not possible through Postman, is there any other way to get this report? 

I tried also analytics directly in Opsgenie, but that is giving me just partial information...

Thank you for any idea

[Rafael Meira]

Hello @Marcel Sarvaš 
Happy to help!

We do have an API that you could pull data from - https://docs.opsgenie.com/docs/who-is-on-call-api 

On the Opsgenie IU, under analytics, you would find a few reports, but nothing like the one available from the API above.

Let me know if you have any questions.

Best,
Rafa

[Marcel Sarvaš]

Hi,

First of all, thank you for the reply...

Unfortunately, I tried all the above and I can not get wanted results. From API I can pull different data but not a list between dates with the time spent oncall. Under analytics I created an almost suitable representation of what I need, I am also getting monthly reports, but still not fully satisfied. 

The analytics report is the closest to what I need. I can list users that were oncall during the previous month, I can set business hours and off hours, and get a monthly notification...but it is still showing just the "standby" part of it... The best would be If I could divide the whole time spent on oncall into three sections and give them a special rate afterward. Also, it would be nice to see weekend hours separately, so maybe all this would be a nice feature request, on how to enhance the analytics. 

Ok thank you, it seems there is no other way to achieve what I want to see, at least now.

[Rafael Meira]

@Marcel Sarvaš Hey!

Thank you for your feedback and suggestions on how to enhance the analytics feature in Opsgenie. I can create a Feature Request from your feedback in case you would want.

While it's not possible to get the exact analysis you're looking for via the current API or UI, you might be able to achieve what you're looking for by exporting the raw data and processing it separately.

For example, you could use the "Get On-Call" API to get a list of all users on-call during a specific time frame, then use the "Get Alert" API to get the details of each alert during that time frame, including the on-call duration. From there, you could write a script to process and categorize the data as needed. Unfortunately, since this is not done from our side we offer the documentation. Let me know if you get any errors that I could assist in solving.

I understand this is not an ideal solution, but it might be a viable workaround.

Best,
Rafa