They work in some specific ways in the select statement, and in the from statement at least, and seem to be close-to-required for modern dashboards. If you're asking a DBA for the way they'd write the SQL to solve a problem, the WITH they'd normaly use doesn't work, and it looks as if there's no option for this, which…
Hello, Does anyone know how to use the API to initiate an update of the Orion Agent? It looks like I need to provide 'SolarWinds.AgentManagement.Contract.Models.AgentRecord' data plus a boolean (I assume true/false), but I'm not sure how to construct the AgentRecord. I'm trying to do it via PowerShell, i.e.: $agent =…
I have 2 query's where i count the number of nodes and interfaces with CustomProperties like 'FIN-P' and status <>1 Query for nodes : SELECT count(1) as Number_of_Nodes FROM Orion.Nodes n Where n.CustomProperties.Node_Type like 'FIN-P' and n.status <>1 Query for Interfaces : SELECT count(1) as Number_of_interfaces FROM…
I am working on our integration with xMatters. One of my goals is to have the ACK passed from xMatters into Orion include the user who initiated the ACK within xMatters. Today an inbound ACK is marked as being made by our xMatters User in Orion. xMatters does pass in a message that explains who did ACK in xMatters but that…
Hello, I was wondering if its yet possible to use Ansible to add nodes into Orion? I have a set of playbooks for configuring switches and routers and would like to do the same with adding devices into Orion ideally with relevant information such as location, groups etc. I would then also like the option to select…
Greetings - The server patching team is looking for a dashboard or dashboards to display some custom SAM monitors that monitor services to tell if they are up or down. We have an issue where we patch our SQL nodes and when they come backup up some of the SQL services are not started and that causes some issues with SQL. I…
Hi All, One of our SolarWinds NPM 2020.2 instances is experiencing authentication issues with SWIS and SWQL Studio connections. SWIS and SWQL Studio connections to SolarWinds do not appear to allow authentication of active directory accounts configured for SolarWinds access via "Windows Groups". SWQL Studio simply reports…
Hello, I am trying to write a query that will check to see if the value of a property is not found within another property of the same node. Such as "Site Code" property value is not found in "Site Code + Location" property value (i.e "101" site code not found in "201 - Example Building"). I am probably overcomplicating…
Hello Everyone, I'd like to place Universal Device Poller custom MIB queries on an Orion map. I don't think this can be done; I would love to be wrong. Does anyone know how to do this? Yes, I know you can do this on a Network Atlas map, but I'm trying to work exclusively with Orion maps. Thanks in advance, Brent
I have been trying to manually manage some nodes and wondering how Orion does this so i can replicate the process in a powershell script. The main reason for this is that, most of the servers i manage have Remote Administration turned off but yet Solarwinds is able to add and query these machines. I tried using CimInstance…
It looks like you're new here. Sign in or register to get started.