Table of Contents * Sample Tables * Moving the Queries to a more "readable" format * Joining the Tables (Traditional) * The Easier Way - Navigation Properties* What is a Navigation Property? * Summary Because many people (myself included) started to learn the syntax of SWQL Queries based on (sometimes limited) knowledge of…
Can anyone point me how to open a support ticket with OrionSDK team? I opened a normal standard support ticket with Solarwinds and the support engineer immediately told me that they don't support this and instead I need to go to Thwack website? I don't understand how a paying customer can't open a support for a problem.…
If you are interested in being a beta reader for the upcoming SolarWinds API book, please comment below. Currently I've closed the beta reader sign-up. If you are still interested, please navigate to the API eBook Beta Readers/Editors page and request membership. Membership approval will be granted based on the need at the…
My requirement is to create a new ncm connection profile with properties like username, password etc. but I am unable to do it using python Orion SDK. could anyone please help me..
I need to access to my solarwinds database using pyodbc. I am using Orion Log Viewer.
Hi all, I am using this custom query widget when in order to search by node id and find out what maps the node is a part of, it works great for this purpose. SELECT TOP 100 p.DisplayName ,concat('http://{redacted orion IP}/ui/maps/viewer/', p.ProjectID) AS [_LinkFor_DisplayName] ,n.Caption ,n.IPAddress FROM…
Hi guys, as we don't have any answer on GitHub : https://github.com/solarwinds/OrionSDK/issues/309 In SWQL Studio (and using PowerShell too), when we authenticate using certificate, Orion.Report table give 0 row ; whereas using Admin account for example, table returns content. * Orion (v3) certificate : SELECT TOP 1000…
I am getting an error while connecting with Python: Query Test: Traceback (most recent call last): File "/Users/VENV/sdkorion/lib/python3.10/site-packages/urllib3/connectionpool.py", line 703, in urlopen httplib_response = self._make_request( File…
Nothing fancy here. I just need a basic query that will find (fixed disk) volumes across all nodes that have the word "merged" in their path name, and delete them.
Hi All. Wondering if we have a quick way to determine if nightly database maintenance ran correctly? I know how to set up the run time of DB maintenance under Thresholds and Polling. Also know how to check database maintenance execution by parsing the debug log under c:\ProgramData\Solarwinds\Logs . But... do we have some…
It looks like you're new here. Sign in or register to get started.