We recently upgraded our Solarwinds Platform 2024.4.2 to Solarwinds Observability Self Hosted Advanced Enterprise 2025.2.1 and we have seen a few oddities with some of our previous custom SWQL Dashboards that pull information on our Call Manager Installation.
We created a dashboard that showed us the number of incoming calls / Emergency Calls and Outgoing Calls for the current / previous month, but as you can see from the screengrab below, it no longer shows any data for the previous month.
also below is the swql that was used to create this information.
------------------------------------------------------------------------------------------------------------------
select count(*) as kpi_number from (SELECT distinct
vcd.DateTime,
vcd.CallingPartyNumber,
vcd.FinalCalledPartyNumber,
vcd.Duration,
Case
When MONTH( DateTrunc('Month', DateTime) ) = 1 Then 'Jan'
When MONTH( DateTrunc('Month', DateTime) ) = 2 Then 'Feb'
When MONTH( DateTrunc('Month', DateTime) ) = 3 Then 'Mar'
When MONTH( DateTrunc('Month', DateTime) ) = 4 Then 'Apr'
When MONTH( DateTrunc('Month', DateTime) ) = 5 Then 'May'
When MONTH( DateTrunc('Month', DateTime) ) = 6 Then 'Jun'
When MONTH( DateTrunc('Month', DateTime) ) = 7 Then 'Jul'
When MONTH( DateTrunc('Month', DateTime) ) = 8 Then 'Aug'
When MONTH( DateTrunc('Month', DateTime) ) = 9 Then 'Sep'
When MONTH( DateTrunc('Month', DateTime) ) = 10 Then 'Oct'
When MONTH( DateTrunc('Month', DateTime) ) = 11 Then 'Nov'
When MONTH( DateTrunc('Month', DateTime) ) = 12 Then 'DEC'
Else ''
End as [Month]
, MONTHDIFF( DateTrunc('Month', DateTime), Getdate() ) as [Months Ago]
from orion.IpSla.VoipCallDetails vcd
LEFT JOIN orion.IpSla.CDRDetails cdr on (cdr.CallID = vcd.CallID)
where OriginalCalledPartyNumber in ('8100','8700','8701','8702','8703','8704','8705','8706','8707','8708'
,'8709','8776','5800','5801','5802')
AND MONTHDIFF( DateTrunc('Month', DateTime), Getdate() ) < 1 and vcd.FinalCalledPartyNumber not in ('8100','8700','8776','5800','7530','6000')
and OrigDeviceName like 'TR_TS%' )
-----------------------------------------------------------------------------------------------------------------
Now on closer looking and breaking the above down, it appears that the orion.IpSLA.CDRDetails table no longer contains a field called 'OriginalCalledPartyNumber' after the upgrade to HCO and therefore the table produces no data.
I have managed to alter the swql slightly so that it produces data now - as per picture above, however the historical info (i.e. last month is still empty) as it apppears that we now only have data available via this query from the 4th October despite upgrading to HCO on the 1st October.
So the questions I have are.
1. Has there been a change to the table structure for CDRDetails between the different versions of Solarwinds (Platform via HCO)
2. Where has the data gone from the previous month as the data retention is set at 90 days.
3. If i query VOIP calls from the Web Console I can see calls from September and before, so what tables is this view using to populate the data that i need to report on.
I appreciate that this may end up as a support case ticket, but was just wondering if anyone had came across anything similar after upgrading to HCO
Thanks
Duncan
