Hi, I have searched for custom SWQL queries that others have posted which would allow me to search all downloaded configs from today for a string that matches "scp". I understand that the Config Summary exists for this purpose, but in an ideal world, I would like to be able to also use a custom SWQL query. It seems as if…
Hello, I am very new to SWQL and SQL all together. I'm attempting to join an existing query we have with another table to include a custom property value. Both tables share the NodeID column but I am having difficulty in getting them to join together to include the 'Current Value' field. I'm utilizing this in a dashboard…
Hi All I can't seem to use an HTTP/S Post body to unmanage a node in SolarWinds via :17778/SolarWinds/InformationService/v3/Json/Invoke/Orion.Nodes/Unmanage I started with inserting variables but dumbed all the way down to what works in Postman and it still will not work in an Alert Trigger action. I can use the same path,…
Greeting everyone, I am a beginner at SWQL and I'm not very good at SQL neither. I have problems with he bellow sequence. I am trying to create a widget with the Volume size available of my nodes and I want to add the NodeName which is not in Orion.Volumes collection but in Orion.Nodes collection. Unfortunately I can't…
Been digging around on this, wasn't quite sure where to post it, but I'm hoping that someone has invented this wheel already. I haven't been able to dig up quite what I want, and am hoping someone else has done something like this before I start from scratch. I want a report on how many times ALL enabled alerts have fired…
I have created a custom property called "Group_Under_Maintenance" and this is set to "Yes" whenever the site which that group represents is undergoing maintenance. I want to add the "All Nodes" widget to our home Summary page and have it filtered to show only sites that are currently under maintenance. Can anyone tell me…
Hi everyone, I'm new to SWQL here so please bear with me. Trying to return all syslogs from 'yesterday', as in the prior calendar day. Found a thread that covers this but the query doesn't work when I apply it to the syslog message table. I can get other WHERE statements to work that reference the date/time as seen below.…
Hello, on the web interface, there is an option to create automatically the IP addresses when the subnet is created: I'm using the SolarWinds API to Create subnets (mysolarwindsurl:17778/.../IPAM.Subnet), but I don't want any IP Addresses. I couldn't find any possibility to create a subnet without IP addresses. The swagger…
Hello I need to install SwisPowerShell 3.1.0.343 because the SWIS Snap In is not registering when I run a script. The instructions to install it manually from the Microsoft website mention a .PS1 file, but I have not got it in the NuGet folder. I have never done this before so I need help on how to do it. Does anyone know…
We have multiple servers and will have to many users/groups to manage the accounts or even the group permissions manually through the GUI so we are looking at using the API. The problem I am seeing is thtat the "Orion.Accounts" table in SWQL Studio is marked as Read: True Create: False Update: False Delete: False I tried…
It looks like you're new here. Sign in or register to get started.