• State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 32 subscribers
  • Views 313 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Seeking help on a report to display data returned from a component historically.

stephen.black

I am trying to find where the statistic data values are stored in the Orion dB so I can build a custom report. Anyone know which table I would look at by chance? I can find availability but not the actual statistic data. 

TRM Stats.jpg

This is how the monitor appears in Orion.

TRMUX.jpg

 

 

  • 0

    As these types of components can return multiple values, they are stored in a different location to other component stats.

    There are two database views that might help:

    • APM_MultiValueAlertsData - I think this is the most recent poll data
    • APM_ChartEvidence2 - contains historical data with timestamps

    If you use SWQL you can reference these directly from the Orion.APM.Component table making it easier to filter by application or component values.

    image.png

  • 0 in reply to shuth

    Thank you VERY much for this info. Exactly what I was looking for. Really appreciate the help.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.