The most recent content from our members.
when i run a query in SWQL Studio, it seems to be using port 17777 and not the new port 17774. anyone figured out how to reconfigure it to use the new port?
getting an error when i attempt to run a query:
Hello! First time poster. I have what feels like a complicated ask (hopefully it's not and i'm overthinking it) and would like to gain insight or assistance coming up with the best way to go about this. I work at a company with 1100+ sites. Each site should have multiple switches, firewalls, security panels, DVRs, etc. I…
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…
I have been asked as DBA to create a view querying some external data to Solarwinds that our Solarwinds team would like on one of their node dashboards. So far we have this data in the backend SQL Database as either a table or a view however we can not get it into SWQL Studio to be utalised in the dashboard. Is there any…
Google gives me the way to Clear List of Recent SQL Server Connection From SQL Server Management Studio, as shown within the URL attached below. Clear List of Recent SQL Server Connection From SQL Server Management Studio (scholarhat.com) What is the equivalent procedure for the SWQL Studio App?
Anyone know what table the interface IP address and Subnet mask is located in? Everything that I am seeing either goes back to outdated information or gives me the node IP address. Any help would be greatly appreciated. I would think it would be under the "Orion.NPM.Interfaces" table but no luck. SELECT…
Coming from a SQL background I've started working with Solarwinds SWQL and using the SWQL Studio. All things the same, though, I like developing in VS Code or Visual Studio. Things like the black background, color-coded syntax checking, other features are a real plus. I'm wondering if some kind of template or plug-in for…
Running queries against table NCM.NodeProperties. In regular Orion the query works fine. Attempting the same query in EOC returns an error: "Subqueries are not supported". No subqueries here. Just a simple SELECT statement against a single table We recently upgraded our Orion and EOC to version 2022.3. Using SWQL Studio…
Hi, I have a requirement to work on, where a user wants to see the list of all the nodes which is grouped by custom properties along with their status. I have below query that shows the count of nodes based on their custom properties and its status: SELECT n.CustomProperties.Comments, COUNT (CASE n.Status WHEN '1' THEN 1…
It looks like you're new here. Sign in or register to get started.