Skip navigation

Allowing the Tag and Owner field to be accesible via reporting

score 11
You have not voted. Open for Voting

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

  1. 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]

Comments

Vote history

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website, you consent to our use of cookies. For more information on cookies, see our cookie policy.