The IPSLA "properties" fields are currently stored in one table (VoipOperationParameters) , with each parameter being a row per operation.
Attached below is an example of a report I've created to add the Owner and the TAG fields to a Summary IPSLA report. Needs a simple solution to have these properties accessible for reporting/dashboarding.
Select
- A.[VoipOperationInstanceID]
,A.[OperationTypeName]
,A.[OperationStatusName]
,A.[IpSlaOperationNumber]
,A.[OperationName]
,A.[DisplaySource]
,A.[DisplayTarget]
,MAX(A.Tag) as Tag
,MAX(A.Targetsite) as Targetsite
from (SELECT VCS.[VoipOperationInstanceID] as
[VoipOperationInstanceID]
,VCS.[OperationTypeName]
[OperationTypeName]
,VCS.[OperationStatusName] [OperationStatusName]
,VCS.[IpSlaOperationNumber] [IpSlaOperationNumber]
,VCS.[OperationName]
[OperationName]
,VCS.[DisplaySource]
[DisplaySource]
,VCS.[DisplayTarget]
[DisplayTarget]
,Case when VOP.[VoipOperationParameterTypeID]=31 Then VOP.Value
end as Tag,
Case when VOP.[VoipOperationParameterTypeID]=32 Then VOP.Value end as
Targetsite
FROM [SolarWindsOrion].[dbo].[VoIPOperationCurrentStats]
VCS
left join
[SolarWindsOrion].[dbo].[VoipOperationParameters] VOP
on
VCS.VoipOperationInstanceID=VOP.VoipOperationInstanceID
where
VOP.[VoipOperationParameterTypeID]=31 or
VOP.[VoipOperationParameterTypeID]=32) A
group by
A.[VoipOperationInstanceID]
,A.[OperationTypeName]
,A.[OperationStatusName]
,A.[IpSlaOperationNumber]
,A.[OperationName]
,A.[DisplaySource]
,A.[DisplayTarget]
