I'm trying to monitor for Cisco devices that are routers but where I am not gathering/polling the routing table i.e. when ListResources was run the admin did not select those components to monitor.
Trying to get average Availability for a KPI widget for the last 7 days and using below Query SELECT AVG(E0.[AvgResponseTime]) AS Counter FROM Orion.Nodes AS E0 WHERE ( ( E0.[CustomProperties].[x_x_x] = 'abc' )) AND Date.Time BETWEEN GETDATE() - 7 AND GETDATE() But I am getting below error when validating the query:…
There were changes to the DB after upgrading from 2020.2 to 2023.3. I found that my script calling the table CustomPollerStatistics_Detail failed due to "Invalid object name 'CustomPollerStatistics_Detail'." Please help me answer: What is the new table name? If there is no direct 1:1 replacement, I can share my full query…
Table of Contents * Overview of PIVOT * Poor Man's SWQL PIVOT* The Example Entities * Summary Overview of PIVOT For anyone who has worked with the SolarWinds Query Language (SWQL) for any amount of time knows that it mimics traditional SQL in many ways. But there are some limitations that aren't put on traditional SQL.…
Hi , I want to get a csv file from MSSQL studio or Solarwinds Database manager on Response Time for 30 days for Node with some Custom Property value like "Switch-Garages" assigned. Currently I am getting this data from reports feature on Solarwinds but would rather want to pull this directly from Database. I did see the…
To fetch the date below query is working DATETRUNC('day', [N].Timestamp) To fetch the Hour in the time i try DATEPART('HOUR',[N].Timestamp) but DATEPART is not working. Anyone please help. I need to show Hour details in one column.
Hello Team, Our organization is using SolarWinds tool to maintain data related to IT infrastructure. We want to access that data so that we can create our own dashboards/insights. We would like to have read-only access through API on our own data so that we can import it to our PostgreSQL Database and then use it to create…
I've looked all over and I can't find this answer. Only vague references. I have a solarwinds server that is in a lab environment with no connectivity. I need to bulk import the configurations of several switches, which I already have in text form, via script (powershell). Now I've seen references to using the…
I've taken this from the F5 Summary Modern Dashboard widget: Virtual Servers -- Link to ThwackPost I want to add a column to display the IP Address associated with each virtual server deployed? - The data for the IP is found in Orion.F5.LTM.VirtualIPAddress - The data for the Virtual Server is Orion.F5.LTM.VirtualServer I…
I have a current report but it doesn't display switches in stack and want to incorporate serial numbers of switches (in stack) onto the same report could you please tell me what needs adding? SELECT OrionNodes.Caption , OrionNodes.DetailsUrl , OrionNodes.STATUS , OrionNodes.ChildStatus , NcmEntityPhysical.EntityName ,…
It looks like you're new here. Sign in or register to get started.