JCALD6 ✭

How could I now tweak this to track call duration in minutes, instead of seconds? 

I found the perfstack you are talking about and the graph doesn't show higher than 8 failed calls for the whole day. 

Here it is: SELECT DISTINCT E0.[Uri], E0.[DisplayName] FROM Orion.IpSla.CCMMonitoring AS E0 WHERE ( ( ( (SELECT COUNT(AGG.[VoipCallDetails].[OrigFailedCall]) as agr FROM Orion.IpSla.CCMMonitoring AGG WHERE AGG.[Uri] = E0.[Uri]) >= '50' ) OR ( (SELECT COUNT(AGG.[VoipCallDetails].[DestFailedCall]) as agr FROM…

Thank you, this is super helpful!

This is great, thank you! Do you have anything for tracking of phone system types? 

It would be great to have it broken down by current and last month (total calls and total minutes) and then by phone system. Is that what you were asking?

That worked great! Thank you very much. Looks like numbers are reporting more accurately now. Just for my knowledge, what about this query pulls in for the current year versus what I had before? 

Hi Tony, thank you for the response! Running your query returned an error for not recognizing "datetime" in the where clause. How do I work around this?

Sorry, where exactly would I paste that into my query above? 

That could be, how would I need to tweak the SWQL to read only for 2021 or current year? I am not much of a SWQL expert

Yes, for example I have the second query I listed reporting a overall type availability of 99.978%. But, the table that is reporting on each individual site for this type looks like this: 100 100 100 98.117 100 100 100 100 100 99.962 100 100 99.981 94.396 100 99.708 The true average is 99.510%. I am not sure where the…

This works great! Thank you! One small change I want to make is to pull the current month and then the previous two months like you have. What do I need to change to make that switch? 

That change was exactly what I was looking for. Thank you very much! 

This has been a major help, thank you so much!

I greatly appreciate the help, but I am not much of a SWQL/SQL expert. What is the easiest way to merge the two? I am having issues with which FROM statement to use when I try to combine them. 

That is super helpful to help begin translating tables from old to modern, thank you! 

Here is the custom table from the old dashboard that we want to replicate in the modern. Is there a way to copy it over? Also, I am not aware if this table has coordinating SQL/SWQL code. I have only seen that from widgets in the modern dashboards. 

This is a great list! Thanks for taking the time to answer. @"vinay.by"