Hi All, This is my first post, I'm hoping someone can help me with my SWQL query. I simply want to show A list of devices that have a node status of 2 or 3 and the country in their custom properties is not equal to 'Cloud' SELECT A.DisplayName as NodeName, IPaddress as IPAddress, A.Status as NodeStatus, B.Country as…
I am trying to install an Orion Agent with following code. Invoke-SwisVerb -swisconnection $swis -entityName Orion.AgentManagement.Agent -verb Deploy -arguments @( $engineId,` $agentName,` $hostname,` $machineUsername,` $machinePassword, ` $Ip) I keep getting this error. Any ideas? Invoke-SwisVerb : Password can't be null…
i am trying to run following script to deploy agent via powershell but i am getting error again and again . can anyone point the mistake .. i made.. Invoke-SwisVerb : One or more errors occurred. At C:\Script-Tools\Deploy_of_agentbase_device.ps1:42 char:1 + Invoke-SwisVerb -SwisConnection $SwisConnection -EntityName…
Hello Team, I trust you're all doing well! I'm reaching out for guidance to create a SWQL query for Alerts which can i use in modern dashboard. The requirement is to display all active alerts pertaining to node down and whose node ownership is "FT" in a separate view. Additionally, there should be a distinct view for All…
Sorry for the cross-post. I didn't know this section was here. I installed the SWQL program on my SolarWinds server and started poking around. I see that system.DateTime seems to be the holder of Date and Time info. I tried a simple SELECT ALL query and each time I try the ALL it errors with "No alternative in Select…
Hi, I'm facing some issues while UnDP custom poller for Power device. That power device have 5 interfaces but i need only 1 interface and remaining 4 needs to be removed from custom poller. I need to use the formula like P[dBm]= 10*log10(P[mW]) P[dBm]= 10*log10(1000*SNMPreading*10^-6*0,1) here snmpreading value will get…
Good morning, Apologies but this will very likely be a very newbie question, as I am not a DBA... I have a SWQL query that works well for single interfaces (access switches) for calculating the total amount of data (in and out): ---------------------- --CALCULATE TOTAL AMOUNT OF DATA IN GB - TODAY SELECT…
I've been re-working my nightly List Resources script to improve/cleanup things a bunch. One of our bigger issues is that we have interfaces on nodes that are not up, yet are imported to the node. I have found that I can query NPM.Interfaces to see the status of nodes that have ALREADY been imported, but I want to…
I would like to create alerting that triggers an alert if for 4 nodes UNDP value is different then 1 node Active and 3 Nodes Standby. We have theoretical SWQL statement but how to implement it into Orion Alerting to only alert when condition is not met. SELECT Nodes.NodeID, Nodes.Caption, PollerStatus.Status FROM…
I'm tyring to get a list of all my devices, some of which are NCM licensed and some aren't. The query below has the answer, but won't show the nodes that aren't in NCM. Any input? End state: I want a list of all devices within SolarWinds and have a link if there is a config file. SELECT n.IPAddress ,cn.NodeID ,n.Caption…
It looks like you're new here. Sign in or register to get started.