• State Verified Answer
  • Locked Locked
  • Replies 1 reply
  • Subscribers 25 subscribers
  • Views 770 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.

Accessing DPA data using PowerShell or ???

mmuller

I'm interested in being able to extract SQL runtimes from the DPA database.

I've looked in SWQL Studio but hadn't seen the data I was interested in in the Orion.DPA tables (If I'm missing it please point that out to me emoticons_happy.png).

So I tried to use Invoke-WebRequest however I continued to get "Your Session has Expired...". Arguably scraping the HTML is not really what I'd like to do.

The API seems to be centered around DPA Management but not the data.

I think I've googled my brain dead and really need help to bridge this.

Thank you for any help.

Mike

  • 0

    mmuller,

    Most the time if there is data published for any SWQL Studio items or even how to query data in the Orion tables it is done on the Orion SDK wiki Home · solarwinds/OrionSDK Wiki · GitHub

    Most of what is found there will tell you how to get to data that is in Orion with the SDK and SolarWinds Information Service (SWIS). DPA and Orion talk via jSWIS or SWIS for java.

    I find some internal documentation on jSWIS items for DPA only. As far as I know, there isn't a way to query these items from SWQL studio. The tables in the Orion Database that start with DPA_

    are mostly very basic tables that are used for the connection and relationships of DPA instances to applications in SAM or Orion objects such as nodes.

    The data you are looking for when displayed in Orion is polled with jSWIS from the DPA database repository. So the only way I know of that you can query this at the moment would be to write SQL query items against the DPA repository database. I am not sure what platform your DPA repository is (SQL server, Oracle, or MySQL) but, here is a report that sounds close to what you are looking for that is for a DPA SQL server repository database.

    Custom Report - Top SQL for Database

    You are correct in what you say on the API for DPA. So far it was mostly centered around DPA Management. Perhaps you can log a feature request for data via the API or adding jSWIS items for DPA data to the SDK wiki I listed above I could see both being good additions.

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.