The most recent content from our members.
Universal Pollers appear to write metrics to a single table and is inefficiently joined to npm schema that seems to table scan often? we have handful of universal pollers assigned to a large group of devices (50k) which heath checks and deployment health fail due to index health, table row count size, custom property…
You've rolled out NPM, then SAM and maybe you've added in NCM and VMAN. You are thinking about DPA and NTM/SRM, especially when they are fully integrated into the Orion framework and suddenly you realize that you want (or need!) to know how data is formed for all of those lovely reports you are generating, or you want to…
I'm trying to use Database Manager to find the table with the "Custom Properties for Interfaces". I want to get the interfaces and the custom property I've created, "Interfacepriority". We use the priority in the alerts, so that we only page out on high priority interfaces, and not low priority. I have interfaces, and I've…
I see the SWQL table "Orion.Sites" joined to by a lot of queries when looking in the OrionWeb.log files and the SWIS log files. I don't really understand what this table does, so I guess that is my first question. What is the point of the "Orion.Sites" table? What is a "Site" in the context of the Orion SWQL schema? Since…
Hello, I have created a new Universal Device Poller to report in Cisco serial numbers. Here are the instructions that I followed. I confirmed that Serial Numbers are being polled since they are displayed on the Summary page.…
Hello, I am using the SolarWinds API to query our SolarWinds inventory. I will be importing the SolarWinds inventory into our external Configuration Management Database (CMDB) in ServiceNow. In order to properly coalesce hosts that already exist in the CMDB in ServiceNow, there must be a unique value that we can use to…
Hello, I would like to write a python script to query our entire inventory using the SolarWinds REST API. I found some useful information here. https://thwack.solarwinds.com/thread/55527 Question: 1. How can I set up a read-only account that has access to send GET requests to the REST API URL? I found some documentation…
Hi, I would be very interested to know if there is somewhere the SQL map schema, explaining the database structure and the tables information.
When we upgraded to the new Orion schema last year we thought we were extra careful about checking through the schema changes to make sure we didn't break anything, especially since we relied heavily on custom SQL queries for things like reporting and alerting. Then today happened. One of our teams reached out and asked…
Has anyone figured out the schema to connect APM thresholds to the assigned application monitors, or the application monitor templates? APM_Applications APM_ApplicationTemplate APM_ComponentTemplate APM_Component APM_Threshold APM_Applications.TemplateID = APM_ApplicationTemplate.ID APM_ApplicationTemplate.ID =…
It looks like you're new here. Sign in or register to get started.