Hi, I'm trying to utilize the SolarWinds SWIS powershell module but I'm having trouble when trying to run the following query and I'm having trouble finding any articles that explain what is happening or how to resolve it. If anyone can shed any light on this issue it would be much appreciated! $OrionServer =…
Been trying to diagnose an Information Service and RabbitMQ problem - and Solarwinds support has like that old episode of the Three Stooges when they try to become plumbers. Anyone have any suggestions for how to diagnose this because Solarwinds seems to have no clue.
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…
It looks like you're new here. Sign in or register to get started.