I created a custom query and tested it in a classic view. I copied the code over to a another view and it did not display any data. Only difference is that the destination view has view limitations. The data should have displayed regardless as the query results would have been covered by the applied view limitations. Is…
I have followed the SolarWinds guide to build Orion and APEs in AWS. I am wondering if anyone has successfully worked with PowerShell to deploy applications from user-data in AWS? We have to regularly use golden images on the Windows Servers, which will require regularly restarting systems on new images. I realize if…
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
It looks like you're new here. Sign in or register to get started.