I have this awesome SWQL query which shows all Unmanaged and Muted nodes. I got it from Thwack but I can't seem to find the original post to respond to. My SWQL is not the best and this query is pretty complex, I think because of different people contributing. Could someone please help me add a simple WHERE so I can filter…
We are being asked to provide a report of Remote Desktop Services. They want a SW report that shows how many Total Licenses and Available License on a handful of servers. SolarWinds says that they have the SAM capability but only up to 2003 Servers and all of ours are 2012 and newer. We have run it through PowerShell…
Hello all, I updated recently to version 2020.2.6. I'm trying to make a very easy SWQL sentence about Subnets in the IPAM module, to get the information related with each subnet. Using the default one, that you get in SWQL application, I don't get any result If I use only a field, getting the most simple request... I don't…
suppose if there are 100 nodes in the environment and 23 nodes are down then the query should give the output as 23%, i will be building on the base query but the base query is giving me some errors i have made a draft SWQL query but the output is giving me some errors about aliases missing Base Query <span>select (select…
SWQL returns the following response: no viable alternative at input 'M' in Select clause. Heres the actual query: SELECT ${N=Alerting;M=Downtime}, ${N=SwisEntity;M=CPULoad}, C.SiteID, N.EngineID, N.ObjectSubType AS [Polling Method], N.Status, N.StatusDescription, N.NodeID, N.IPAddress, N.NodeName, N.DNS, N.Description,…
I was trying to figure out the discrepancy in why a SWQL query returned more GlobalProtect clients than the SNMP value returned by the firewall. In performing the query it appears as if sometime in June of last year a number of entries got "stuck" in Orion. They show as STATUS=1, meaning active VPN connections. I can…
Here is my code: SELECT A.Caption, A.NodeID, B.CustomPollerAssignmentID, C.CustomPollerAssignmentID AS ID2, C.CompressedRowID, A.Vendor, C.Status FROM Orion.Nodes A JOIN Orion.NPM.CustomPollerAssignmentOnNode B ON B.NodeID = A.NodeID JOIN Orion.NPM.CustomPollerStatusOnNodeTabular C ON C.CustomPollerAssignmentID =…
I know automated actions are available but looking for options we had in a previous tool that let the NOC trigger scripts to execute run book types of activities (re-check conditions, re-start services, pop tickets,etc)? Thanks for any info. Randy
Hi, I'm trying to generate a chart showing the total number of bytes transferred over specific interfaces on a monthyly level. I can grab this info from Orion.NPM.Interfacetraffic. I'm having trouble figuring out how i can sum all the bytes based on the time stamp though. My query is: SELECT DATETRUNC('month', DATETIME) AS…
I'm trying to tweak our nodes down resource to add the date/time the system went down. I'm trying to figure out why it is listing all the times the nodes have went down and not just the most recent. Here is the query: SELECT NodeName AS [Node Name], '/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],…
It looks like you're new here. Sign in or register to get started.