Hello, I am trying to add something like SLA breached column if the response time if higher than what is in the threshold. SELECT VoIPOperationCurrentStats.OperationName AS Operation_Name, VoIPOperationCurrentStats.Description AS Description, VoIPOperationCurrentStats.RoundTripTime AS Round_Trip_Time, CASE WHEN…
Hello everyone, Looking for some help. I am trying to find a way to retrieve the recovery modes of my SQL databases. I cannot seem to find a query to do this within Solarwinds. We are using the Appinsight for SQL but I don't seem to find a way to pull this out into a report. Any help appreciated. THanks
Hi Team, I am very new to working with Solarwinds and looking for guidance on how to extract dashboard data from solarwinds through an API. I believe we can create Dashboard instances within Solarwinds and these can be accessed through SWQL studio to get an extract of the dashboard. However, I want to get the extract on a…
Hi Team, I am very new to Solarwinds and the SWQL query. We are trying to pull the below fields data for devices. I have no idea which objects in Solarwinds have this information and the list of objects is overwhelming to go through each. Any pointers would be greatly appreciated. Field Name Details Sample Data Serial…
I really wish there was an official SolarWinds Ansible collection that was covered under support, but I have been using this Ansible collection to manage my SolarWinds nodes: jeisenbath/ansible-collection-solarwinds-orion: An Ansible collection for managing nodes in Solarwinds Orion (github.com). It has been working pretty…
Anyone help me with the Ps to test the NCM connection profile which exist already to a node.
How to calculate node availability and kindly provide the query to fetch last month data
Hi, I have installed the trial version of the Solarwinds SAM & Log Analyzer module in my environment, and installed several agents on the node. For monitoring logs purposes, I changed the Log & Event Monitoring status to Enabled in the monitoring target, but the log data did not appear. can anyone help me solve this…
The Node Details widget remains empty after adding a node by using PowerShell. If I change the Category field by by hand the widget gets populated. How can I ether trigger autodiscovery via code like on other nodes added by hand or modify category field via PowerShell code? This code produces an error: $newNodeProps = @{…
Hi, need to sum the counts of two diferent entities. Here the queries I'm using to get the count of monitored nodes and the one used to get the total number of switches that are stacked across the network. How to get the sum of this in a single query? SELECT COUNT(NodeID) as value FROM Orion.Nodes WHERE (SysName LIKE…
It looks like you're new here. Sign in or register to get started.