Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SolarWinds SDK

Recent Discussions

SQL Query Not Working in Report
I have a very simply SQL query that is not working in a Report but is working in SSMS. Here is the code: SELECT ComponentID FROM SolarWindsOrion.dbo.APM_ComponentSetting Orion Report tool is saying "Query is not valid". BTW: This does not work for any of the fields in that table, individually or all together. Any ideas?…
How to do a query with pagination, how do you know what the highest row number is
Hello Everybody. Im building a query to collect info from all the nodes in Orion.Nodes. I think pagination would be in order to decrease the chance the reply will timeout. I found that you can do pagination like this with SWQL: SELECT NodeID, Status, Caption FROM Orion.Nodes ORDER BY NodeID WITH ROWS 1 TO 1000 But how do…
Hi, Can anyone help me on Which table I can get these data in SDK. Device Performance, Device Fan, Power Supply.
Hi, Can anyone help me on Which table I can get these data in SDK. Device Performance, Device Fan, Power Supply.
How to create group using for a csv
Hello, we are migrating to the SolarWinds platform. I want to create group and populate them using a csv file. I have created a custom property named _group. The filtering doesn't work. Groups are filled with every node. The excepted behavious is to the group populated with the matching name inside _group. Set-Location…
Hi Team, we required API Parameters for Device Performance, Device Fan, Power Supply. The API results would have to be customer specific can we have any refrence tables/columns for these data on SDK?
we required API Parameters for Device Performance, Device Fan, Power Supply. The API results would have to be customer specific can we have any refrence tables/columns for these data on SDK?
Getting latest timestamp for conversation between hosts
Hello guys, I'm trying to get the latest (last hour) conversations between defined hosts. For the purpose I use the following SWQL query: SELECT DestinationIP, Packets, SourceIP, TimeStamp , ObservationTimeStamp, IngressBytes, EgressBytes, TotalBytes FROM Orion.Netflow.FlowsByConversation WHERE SourceIP = 'X.X.X.X' AND…
Query on list of nodes - SWQL requirement
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…
Seeking help with SWQL query for a report.
I am very new to SQL and SWQL and am hoping someone can help me with a query I'm building for a customer report. I started by using an application availability report for the last 30 days. I only want to report on 6 URL/HTTPS monitors I have setup for the customer and need to filter the result by using ApplicationID. I…
Am unable to use LAG function and Over clause in SWQL anyone help me
Am unable to use LAG function and Over clause in SWQL anyone help me
Source entity [Orion.Alerts] not found in catalog
I've been looking at the schema: Orion.Alerts but the query: SELECT Description FROM Orion.Alerts WHERE AlertID = {alertObjectId}fails with: "Source entity [Orion.Alerts] not found in catalog" Is this normal? I can query from Orion.AlertObjects but not Orion.Alerts