bucweat ✭✭✭✭✭

I think that was the query I originally provided... @"adam.beedell" was just telling you to use it as your images had your original query... Bottom line I'm glad you figured it out...I learned some things about report generation while playing with this... Can you share here what finally worked for you? For the next person…

https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions You'll need to experiments with those in SWQL Studio, but the building blocks are there...

I created a simple table widget...the query I provided validated and the widget displays the same results as SWQL Studio. I only have SAM license so not sure if network device uptime is part of another package or not....

Also note I commented out the having so that I would get a result since nothing here had Availability = 100. Bottom line is you'll need to vet the final result but first you need a query that works...

How are you running it?

This query is not SWQL...it looks more like SQL that you'd run in Database Manager except it uses SWQL table names. Very odd that you'd get this "SWQL" from support... Try this SWQL tested in SWQL Studio 3.2.0.50049: SELECT [Nodes].Caption ,AVG([Nodes].ResponseTimeHistory.Availability) AS [AverageAvailability] FROM…

If you want SWQL query, this should get you started in the right direction: SELECT node_name ,app_name ,comp_name ,Availability ,[sm].DisplayName as [Avail] ,date ,numrecs ,total ,ROUND(((numrecs*1.0)/(total*1.0))*100.0,1) as p FROM ( select [as].Application.Node.NodeName as node_name ,[as].Application.Name as app_name…

I really wish more folks would provide the working example code/sql when asking these questions... Here is my example using Orion.APM.ComponentAlert: SELECT ca.ApplicationID, ca.ComponentID, ca.ApplicationAvailability, ca.ComponentName, ca.ComponentType, cd.Name as componentTypeName, ca.ComponentAvailability,…

If [some of] your apps are set to run remote you might have to look on the remote machine for these files too.I believe the process is similar.

https://github.com/solarwinds/OrionSDK/wiki/SAM-Application-Monitoring-Templates should get you well on your way...you can export, modify the template xml, and import all in the same script. There are plenty of examples in the powershell samples folder https://github.com/solarwinds/OrionSDK/tree/master/Samples/PowerShell.

I'm assuming by "SolarWinds Discovery process" you are including remotely installing the agent executable from the web console. I know the Discovery process can be bit of a challenge (vs local install of agent), but I think you are right...once you figure it out the results are better. It does require access to…

https://www.comparitech.com/net-admin/snmpwalk-examples-windows-linux/ is a command line tool for windows/linux/mac that can be used to test SNMP. It supports version: 1, 2c or 3. Could be helpful for troubleshooting. Other possibilities that I haven't tried: https://ezfive.com/snmpsoft-tools/snmp-get/…

Maybe something like this...and if there is an issue connecting with credentials then your script will return critical and you can look at the contents of Message.Error in the components pane of the Application Details page of the Solarwinds web console or the log file…

My guess without running your code is that not all paths are returning a value. Try putting an exit 1 at the very end and see what happens. You should probably wrap your script in try/catch block and handle errors. Also check the log files generated by your app monitor for errors. 

OK yes if all the shares you care about are shared on the workstation you wish to monitor then you are ok. I thought some of your paths might be from remote shares...my bad. Also just realized get-smbshare is for local shares...I had Get-SmbConnection on the brain...

Assuming you want table to show up in Solarwinds Web Console and that you are mostly interested in CurrentUsers. One possibility is you'd need to figure out how to capture this information to the Solarwinds DB so that it can be queried. That "could" be done with SAM via application monitor running powershell Component…

Hi all, Everyones comments seem to line up with what I've seen. I started using Solarwinds with 2023.X so never seen working history data here... Here is a working query I use (sorry for the formatting I don't see how to format code in this forum wish they used markdown). Note the join of Orion.APM.DynamicEvidenceCurrent…

Hi, For the ticket I submitted 01368039 all I got was when I asked about null in StringData was "I do not know if it is correct or not, but I get the same results in my lab, so two out of two may be right. Unfortunately, SWQL is out of our scope of support and you will need to go to thwack.com if you have questions about…

I think you need to add "exit" to your powershell script. From the link I reference at end of post: * When Exit 0; (status of Up) is reported, the message and statistic are displayed and the monitor shows a status of Up. * When Exit 1; (status of Down) is reported, the message and statistic are not displayed and a status…

The time with the "T" is ISO-8601 format https://www.w3.org/TR/NOTE-datetime How arre you running the query? Which version of SAM do you have? I have 2023.2.1 when I run that query in SWQLStudio I get times that loook like 2023-06-19 16:30:34.76. Check out https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions there…

I have been using SWQL Studio but apparently not looking hard enough :-P I see it now. This explains why Orion.APM.DynamicEvidence is displayed with strikethru in the tree...and if you uncheck Preferences > Show Obsolete then it doesn't show up in the tree at all. Since I could not find the string "DynamicEvidence" in the…

Thanks for the reply!!! This is very helpful. I already have a ticket in but all support has done is verify they are seeing the same result as I am. BTW if you go looking in the database directly you'll see the same issue with 2023.2, so I don't think this is an issue with SWQL as it is pulling what is in the database. I…