Solarwinds custom query replaced names in brackets. In the dropdown called 'Set up Alternatively if that database sits on the same SQL instance as your SolarWinds database, you could possibly write a custom sql variable that queries that database. Is this the best way to do a query Find the best place to learn and ask questions about your SolarWinds products. Select Fields you are looking for. I can write a SWQL query against the various custompoller tables (i. In the Application Monitor Template tab, click Custom. We are in process of creating KPI widgets for a modern dashboard using custom SWQL queries. We are also going to utilize the search function within the resource to pin down easily a Custom Reports Enhancement - Custom Query Reports Ability to build and save custom reports based similar to standard SQL queries. CustomProperties. Now I've created a query that returns the values I actually need! I need to implement this within the Alert overview as a Custom SQL Alert. Basic query structure. Then click on "Preview" so you see the page, go to the new resource box you added and click on "Edit". I have been trying to figure getting a value returned from a SWQL query to display on a Custom HTML page. 1. alphabits , I ran into the same problem when I first started converting things over. WHERE Latency > 120 AND OperationInstanceID like Hi, Using Orion Universal Device Poller I've created a custom poller to read OID 1. I have this query and want to create an object/widget to be put on a dashboard. Stats Find the best place to learn and ask questions about your SolarWinds products. Any help would be appreciated. Looking to create a custom alert, which will trigger when a router has failed/becomes unavailable. Search; Sign In Search; Community but when I got to physical or virtual I couldn't find a drop down for that and solarwinds support told me I needed a custom sql query. I am writing a powershell script where I want to get the data from availability report (Node, Hostname, Availbility %, etc. remer, I think this may be of some help for you. How can I include customproperty I can use a swis. query => SELECT JobsData FROM Orion. Caption as NODE, n. where ComputerName IN ('[list of all our domain controllers]') and message like '%locked out%'; SQL Query - Enter your custom query in this field. Quick query that can be added to a custom query widget on a node details page to show the status of PowerShell Components and their status messages / statistics. It should bring up a box that says "Edit Resource: Custom Query". We have a couple of count queries which are mentioned below:- Hi. Go to Start > All Programs > SolarWinds Orion > Alerting, Reporting, and Mapping > Report Writer. Good Afternoon. node. Then, after you've crafted some of your own, you can return the love and share yours with the community. statement() at SolarWinds. 0 AS SVG1_Weekly. If an interface is not monitored, then you will see "not monitored" and decide, if it should be added. See below for both options. Component AS Component -- Mandatory Query part above INNER JOIN ( Select Count(CA. NodeName AS NODE, i. Also you can go with the <> ' ' option or you can go with IS NOT NULL option. Configure the alert similar to below and paste Hi, I'm looking to retrieve all tickets which have a custom field marked with a specific value via the API. I'm trying to write a swql query that combines 4 universal Device pollers with a custom property on a node. Pop it all into a custom query and you get 3. Native to the SolarWinds Platform, there is a macro The Custom Query resource does not have export capability, but if you can write a SWQL query to get the data you want it is not hard to get a . ; If you’ve integrated an Events API into the Is it possible to write a SWQL query for a dashboard widget that would have a WHERE clause similar to this: WHERE custom poller (status or currentValue) != x for last 12 hours. Flush your DNS and restart AMA 3. Query. Create a custom property to identify nodes running IIS. I have a domain controller dashboard that I added a custom SWQL widget to so these event would show on the page. I have tried multiple ways but unfortunately have not been able to achieve it so far: Now that we’ve covered the main navigation portion of SWQL Studio, let’s build your first query. Can you please suggest how to write dynamic query object in groups for the below conditions. I typically just use a standard custom query widget to display all my SWQL, instead of this fancy table, but I very much prefer the cleaner layout of the table. Observability Solutions; SolarWinds Observability SaaS; SolarWinds Observability Self-Hosted; When you put the SWQL into the table and click on Show Records is it showing all of the columns that you expect to see? Have you puit the code in to a Classic Dashboard on a Custom Query to see if it works on there? I guess the final thing to check is what version of SolarWinds are you running? I am running 2023. select. I've reviewed other posts and have been able to widdle the query down to a couple of options but I can't get the gif image to show correctly for Option #1 and I can't get the icon color to show on Option #2. SolarWinds® Orion platform has a lot of resources you can place in your views (more than 250 in a single SolarWinds Network Performance Monitor (NPM). Note: Web-based reports do not allow the use of variables that are created by preceding a property or database column name with a dollar sign ($) and an open brace ({) and then following it with a close brace (}), as in ${Node. This seemed like the best way to select a bunch of interfaces from different devices of my choosing. Netflow for that matter) but wasn't able to find anything obvious. SolarWinds solutions are rooted in our deep connection to our user base in the THWACK Via this manner I have given our Developers rights to have a restricted view in Solarwinds. where n. Flows (and Orion. On the Select Object panel, select Nodes, and click Next. JitterOperationResultsDetail. Anyone that can help me to find the process I would appreciate it. Scroll down the object explorer until you find the Orion namespace, expand it, right-click on Orion. ” Search for “Custom Query” and drag it to a place on the page. I would like to a Custom Property "Serial_Number" for Nodes in NCM 7. I need this information to true up the SolarWinds inventory for my company. NodeChildStatusDetail a, Orion. Need help creating a KPI for Modern dashboard in Solarwinds using the Custom SWQL query. The following procedure describes how to create a custom WSUS report. Search; Also, we're doing a SolarWinds Lab episode on the SDK, API, SWIS, SWQL, PowerShell, etc. IOSImage, ONPMC. QueryProcessor. I'm trying to replicate the look of the "Top 10 Interfaces by Percent Utilization" resource, in my own custom query resource. You can run this query either from your Orion Report Writer or from your Orion server. I have a custom alert that runs daily, and the query takes about a minute. I have tried cast and convert, but SWQL does not seem to understand the integer property. I want to state again the node has the custom property but one of the UnDP's has the same value as the custom property. I don't have that particular custom property defined, so I've commented it out of my responses. The image below shows the in built SolarWinds Widget, circled in Red is why I require this custom query to filter out the unwanted data within the table and in blue is what I want to add to my custom query. The first workaround to my issue is take the Runbook custom property and mark it to No for Sure. Observability. You would have to give your solarwindsoriondatabaseuser access to query that database of course and specify the database name. In my case, I want to display CPU status of the nodes that trigger the high cpu utilization. For example, in the following query, when I bring up Node Details for Host A, the widget should show only Host A interfaces automatically. Uri, Nodes. Name, AlertConfigurations. Hey, I'm using a custom query ( mesverrum ) that poll alerts that were reset but not acknowledge, but I want to insert 2 things: select ac. CustomPollerName, ONPMC. nsaneone over 6 years ago. So if i want to include both the node Caption patterns in same group, so that i will at SolarWinds. For Within the resource, there are hidden gems to beautify the output, also known as the _IconFor_ and _LinkFor_ columns. Find the best place to learn and ask questions about your SolarWinds products. Set the custom query output to ordered 2. This query will get just the text of the most recent note for node 123: SELECT TOP 1 Note. I setup a custom SAM template and applied it to all of my DCs to monitor for Event ID 4740 when a user gets locked out. Report WHERE ReportID='1193' I checked and verified that the SolarWinds Information Service is started. 1 here. childuri) Assuming you set the data source the same way between the chart and the table you showed the it feels like maybe you are experiencing some kind of bug. Raw Results: As rendered on a Summary Page: Custom Properties Required: BTW I did raise a case with SolarWinds for this too but I just got a reply saying they don't support help with SWQL queries. caption, n. Thankfully, you can download pre-existing widgets directly from THWACK to get you started. Nodes WHERE Nodes. Done! Enjoy your new widget I need a query on custom properties based on the following: 1) Need a query for custom property to find out which is not being used or assigned on any node / Groups / Alerts / Views etc. So I'm needing to create a query to give display in a view of a list of all down nodes but not un-managed ones with a couple of custom fields and the status bubble and clickable link . query ('SELECT NodeID, Caption FROM Orion. I truly believe that Dynamic Query Feature is Freaking Rock! and it makes SolarWinds much more fun to work with. It's currently showing 4 hours ahead. You fixed the node. from dbo. 4. The table should display Application #1, Application #2, etc. For example, we have a 'Location' custom field which has values such as 'Bucket A' and so on I want to return all tickets which have 'Bucket A' selected as the location. LastBoot}. Then select, Custom Query and confirm by hitting the Add Selected Datasource button. I have to admit that I am fairly new to queries in SolarWinds so please feel free to treat me like a newbie. Log in to Orion Server with an admin account. ” Then you should have a very boring Custom Query box on your page. EntityType, b. We all know that reporting on these custom pollers is difficult. i. The result for Custom SolarWinds solutions are rooted in our deep connection to our user base in the THWACK ® online community. Node. Please note the SELECT statement is generated automatically based on the item selected from the drop-down. Text colour to display alerts using custom query I have a Custom Query Resource to display Nodes with their CPU/Ram,etc. RelatedNodeID='${NodeID}'. AlertConfigurations Find the best place to learn and ask questions about your SolarWinds products. Caption, Nodes. Please note this query does not directly identify the Custom Property Type, Name, This article provides steps on how to create a Custom Query widget for the Orion Web Console that displays Node Names and IP addresses of devices being managed in the Orion Platform. I think it is brilliant idea to have groups populated dynamically based on certain rule. I have around 10 nodes each with Caption patterns "ABC" and "DEF". , to query all active alert, please find below the SQL query, hope it will work since its working with me. Search; SolarWinds solutions are rooted in our deep connection to our user base in the THWACK Below Node Details Custom Query widget is showing only linkDown and linkUp traps. This will open a new query in the tabbed query editor and pre-populate it will all properties (but not Inherited Properties) for the Are your nodes setup to only have one BGP link per node? If so, add a custom property to the interface marking it as BGP; then use that as your limiting factor on your query. In the SolarWinds Platform Web Console, click Settings > All Settings > Manage Custom Properties. Observability Solutions; SolarWinds Observability SaaS; SolarWinds Observability Self-Hosted; The custom query widget is one of the most flexible extensions for Classic Dashboards, allowing you to present your data in any way you see fit. Here's how it looks: So if I search XHG or Exchange, C: or D:, it will filter accordingly. NodeID AS NODEID, n. Initial Catalog - Enter the target database. Add a Custom Table widget to the page where you want to display the query output. nodes n. As to your query, it should be fairly straightforward so long as the fields you want to add are being pulled from the same table in the DB. My Solution: I found below query but it only gives the report information. This query is to gather metrics from the DPA repository for reporting. Advanced Orion Platform users are familiar with the power of the Custom Query widget, but getting started can be difficult. SolarWinds Query Language (SWQL) is a proprietary, read-only subset of SQL. When running the query from SolarWinds dashboard, should I prefix the complete table details for columns like Name, Relatenednodecaption, etc ? To use this code, add a Custom HTML resource to your Solarwinds group page and paste in the code in the attachment. " message. SELECT '' AS n, n. Search for widgets, or resources, and drag and drop them on the page where you want them to be, including in new columns. And I'm trying to find out how to restrict this. In this blog post we are going to use the Custom Query Resource to display routing information configured across all devices monitored in Orion. SolarWinds solutions are rooted in our deep connection to our user base in the THWACK ® online community. Whether you didn’t find what you were looking for or just feeling like going custom, the Custom Query resource is powerful enough to meet your needs! When I run the query I get the following message: Error: A query to the SolarWinds Information Service failed. SWQL. Observability Solutions; SolarWinds Observability SaaS; SolarWinds Observability Self-Hosted; Just edit a page and add a Custom Query widget and paste in the above query (changing line 31 to match one of your own NetPath Services) and you should get something very pretty. Hello World before the upgrade to NPM v12 we were using some custom queries in order to extract IOPs per process from the database and create charts and tables with The SolarWinds Query Language (SWQL) is a data retrieval mechanism for querying a SolarWinds Platform product and retrieving data. Click Done Adding Widgets. I need to know how to add formatting to this. If you already have custom HTML on your page, I typically just use a standard custom query widget to display all my SWQL, instead of this fancy table, but I very much prefer the cleaner layout of the table. Observability Solutions; SolarWinds Observability SaaS; SolarWinds Observability Self-Hosted; SolarWinds Platform; Rather than We setup a custom query to show averages of 3 custom pollers. Need help with how to format the output of a Custom Query. StatusLED, Nodes. For Selection Method, select Advanced Database Query (SQL, SWQL) and paste your query in the box: Apply the columns needed for the report. Access Layer VLANs (with good/bad VLAN defined) - Custom Queries - The Orion Platform - THWACK - This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Observability Solutions; SolarWinds Observability SaaS; SolarWinds Observability Self-Hosted; Find the best place to learn and ask questions about your SolarWinds products. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. I would like to retrieve this via SWQL API, but the following query does not work: SELECT Serial_Number From SolarWinds solutions are rooted in our deep connection to our user base I'm new to running sql queries and I need to run a report that solarwinds support has told me I need a custom sql report. It doesn't seem to matter what query I type into the Customer Query box, I always get the "Error: A query to the SolarWinds Information Service failed. Get help when you need The query limits the result set to any session that has been running click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. The custom SLA report SWQL query. ; Click Submit. A basic query uses full-text values. ). Currently thinking of specifying the various Is it possible to embed a SWQL query against the orion db inside of a custom html page. When you create the query fields, use the time picker to select the date range you want the query to cover. Activate only when node down alert is triggered: Down Introduction There is a custom query located here that provides a list of all missing indexes in your environment ranked by the time savings: (2) Global Index Advisor with Time Savings SolarWinds solutions are rooted in our deep connection to our user base in the THWACK Hi aLTeReGo, I am glad you have asked this question, because I have a "story" to tell . How can I apply custom colours within my query (using CASE, so far have not been able to make it work). This information isn't pulled natively by Solarwinds for some reason, so we had to create a custom Poller to query the SNMP OID for the Serial number and then select the first entry from that list and store it as a value. I can't figure out how to path the Orion. LinkedIN: Loop1 Systems; Facebook: Loop1 Systems; Twitter: @Loop1Systems I copied most of this query from thwack and made a few changes. APM. NodesCustomProperties table to use it in the where clause. I want to be able to pull the data out of the DB directly but have the Find the best place to learn and ask questions about your SolarWinds products. My query is . 10. Give your query a title and a subtitle if you want. Try this and let me know. faizan_123 over 3 years ago. By default, the initial search period covers the last hour. installation) and yet little is known of the infamous Custom Query resource. To perform custom searches, click Historical Events in the toolbar. I plan to expand the query. So the way I've set this up, you can search the name of the the node, the name of the volume, or a defined custom property. 8. Edit the new Custom Table resource and click "Select Resource. However, I'm having trouble with the SWQL syntax. Instructions on lines 28-29 about how to alter the query to perform the same, but only query that specific node when placed on a Node Details page. To have SolarWinds correctly interpret OID counters, you need to configure the poller to calculate the AvgRate rather than simply showing the Total. I am not familiar with SolarWinds REST api, and I have never used it. LastBoot '. On the Groups Summary page, click the pencil to edit the page, then click on “Add Widgets. Provided below the modified query. I'm using the following SWQL query to list active alerts in a report: SELECT o. com) This is a custom query that can be put on a global summary page to show all devices which have been unmanaged or muted based AND match a specific filter. FROM Orion. Giving the ability to pull data from a How can I fix the Custom Query error in SolarWinds? 1. Similar to SQL, you can use SWQL to query your SolarWinds database for specific network information. SELECT DISTINCT AlertActive. 5. SWQLParser. here's what I have so far. ” From the admin guide. SolarWinds solutions are rooted in our deep connection to our user base in the THWACK I dialed back my query to focus on muted nodes, specifically those w/o a ending date/time and I've got this. The application custom property for Runbook signoff date will trigger 20 times. The problem I am having is i'm unable to work out how to display the percentages as colored bars. Engine. com under the Database Performance Analyzer. Apparently GetDate and GetUTCDate as input into the Custom Query window are dependent on local browser rather than Orion Server, SQL Server or database? Same dashboard in each, different times from the database. The The custom query widget is one of the most flexible extensions for Classic Dashboards, allowing you to present your data in any way you see fit. Data. However, the same query does not work on the SolarWinds Dashboard Widget "Custom Query". If I add an 'order by' statement it runs fine in the custom query, But I don't want it ordered. SELECT ComponentStatisticData FROM Orion. A simple example Go to your view, add the "Custom Table" widget, edit it and select a SWQL datasource (could be done in SQL as well). AlertObjects. In general I struggle with how to know if tables can be joined, if they are Find the best place to learn and ask questions about your SolarWinds products. More than 200,000 members are here to solve problems, share technology and best practices, and directly Especially SolarWinds® Server & Application Monitor (SAM) and the “SQL User Experience Monitor Component” has helped me in several cases. detailsUrl, b. nodeid, n. This query will support only 2 level of groups. IpSla. At least this is the theory on how the query should look like: SELECT component. I tried it with this query and it worked for me. If You remove the syntax in red above, or finish the comparative statement, it should filter correctly. Built to mimic the Structured Query Language (SQL) used in most database management systems, it is an easy language to understand if you already possess a working grasp of SQL. I'd like to. There is no comparative syntax following 'Node. If we try to do anything more than an hour it times out. -Marc Netterfield Loop1 Systems: SolarWinds Training and Professional Services LinkedIN: Loop1 Systems The Custom SWQL Query of an Alert has it's own pre-defined SELECT Statement at the top which is: SELECT Nodes. Query-based custom metrics use a query to determine the metric value. 2) I am searching a query to find out which custom property is being used. It is also finding correlated monitored network interface in NPM. Support. (Nodes -> child Group -> Parent Group). ApplicationID) AS CountProcess ,MAX(CA. For example, I have a "Custom Query" Resource on a specific page. I would assume that the syntax you provided is for one node only with a known NodeID. Name ,'/Orion/NetPerfMon. Trying to create a custom query widget in Node Details, Interface details, etc. " In the Data Source Picker, choose "Advanced Data Source Query (SQL, SWQL). Can someone help me build a query that. Generate a custom WSUS report. Paste the contents of the query above; Give the Widget a usefule title. any help would be appreciated. 2. Next, click the Edit button (Configure this resource) and make sure you add the Order by condition when you paste the custom SWQL query for all your widgets. Observability Each node in our environment includes a custom property: Team to identify the support team. 2. DeviceType=@DeviceType', DeviceType=deviceType)['results'] Custom timeout for SQL query? MrSampsonite over 13 years ago There are certain queries of our sql environment that take hours to complete due to the size of the db and complexity of the query. Check your antivirus and firewall collection of custom SWQL queries for SolarWinds Orion/HCO - bgoulet00/SolarWinds-SWQL Here's a thread that describes how to do conditional formatting of data using the Custom Table resource. Message Hello, I was wondering if it's possible to setup a query in SWQL Studio to look for flows that have a certain number of packets per second. I'm trying to get a SWQL query to include the Group Container status icons in the table. I've looked through Orion. Hello, I'm trying to come up with a custom query that I can add to a web view for flapping routes. Observability Solutions; SolarWinds Observability SaaS; SolarWinds Quick note: this is an "expensive" query and can be prone to timeouts, etc. from orion. 1. NodeNotes. SolarWinds was founded by IT professionals solving complex problems in the simplest way, and we SELECT * FROM ( SELECT Nodes. THWACK Search The custom SLA report query uses three functions: two date/time functions—datetrunc() and hour()—and the avg() function. On the Choose Properties panel, in the Property Name field, enter Type. APM_WindowsEvent_Detail . Is it Find the best place to learn and ask questions about your SolarWinds products. p. However! They also noted me they want an e-mail. Use the intuitive search builder to create custom search queries. status FROM Orion. NodeID I have the following query successfully working in a custom SWQL resource on a view: SELECT MultiValueMessages FROM Orion. Simply fix the WHERE command to "o. Nodes b Where a. Since the hardest part of the report was the Custom Query, Hey greg. Top 10 resource: I'm not sure when SolarWinds implemented the ability to "Allow HTML Tags" in columns of reports / custom tables but it's there now in the latest versions. Type in Custom Query and click the search icon. I've elected to show Min/Avg/Max in multiple ways, but the issue i am having is that say. I have run . Note: I haven't tested below query but I think it should work. I am trying to take an SQL Query and plug it into the SWQL Custom Query on one of our Orion views. Note: SAM will only monitor a numerical value in the first row of the first column. I've managed to grab this info about the custom field: You will need to customize how the data is handled. LastBoot. Caption, ONPMC. The query builder supports a combination values, operators, and functions. Observability Solutions; SolarWinds Observability SaaS; SolarWinds (like alert severtity , node details (where alert popping ) , can you please help me with the custom query to fetch the active alerts along with alert severity and node I'm trying to replicate the look of the "Top 10 Interfaces by Percent Utilization" resource, in my own custom query resource. -ZackM. Put your query in the box, click submit and it should work. When I run the query with . parenturi) and n. Report: Create a new report. an example of one that I'm trying to bring over is on the nodes to get the last successful install time for windows updates, as well as the Important and Optional counts of available updates. ORDER BY TimeStamp DESC Your problem is with the last part of your statement: Vendor = 'GTE' AND Status<>2 AND Node. Getting Error: A query to the SolarWinds Information Service failed when doing SWQL(Custom query) nfs1004 over 7 years ago. Top 10 resource: Also, in the my query example, I'm using VLAN 2001 as my "bad" because I didn't have your VLANs in my lab. NodeID, StartTime. 6. Thanks for all your help The custom query custom table (reporting) resource allows unquoted HTML. Then click “Done Adding Widgets” and “Done Editing. this is what i have. Node Details Page Usage. Severity, AlertConfigurations. CurrentValue AS FlashSize FROM So, I just was poking around and found the SWQL studio, ran the following query, and got results Ultimately what I'd like to see is the same thing as the individual node results Except a network wide query that can be seen from the Custom Query window on the web view of our choice. I was curious if anyone has built a custom query resource for BGPs showing when the status is down or idle? I'd like to set up a query that will pull the node Find the best place to learn and ask questions about your SolarWinds products. If by alert severity you mean the actual in-SolarWinds warning/critical/etc then I dont know a way to do it in one alert, but it would be easy to make ~5 alerts copies and bucket them to accept a custom property indicating intended priority If by alert severity you mean what's received by the receiving ticketing system then yeah that works great and comes With that in mind, the term “Orion” will continue to be seen within the SolarWinds Platform for many years – specifically when referring to the SolarWinds Query Language and the API. Nodes, and choose Generate Select Statement. uri, component. Even though strictly speaking its not help with the query I want, I just want better documentation/syntax information to correctly construct this custom variable. Interface Details I'm having trouble find the right SWQL to add the current values of two custom pollers to a report. If you want to use it in the custom query widget to enable searching, then just remove the double-dashes from the lines between the BEGIN SEARCH QUERY and END SEARCH QUERY. Caption AS Find the best place to learn and ask questions about your SolarWinds products. I appreciate all the help on this gents!! Thanks, Robert All SolarWinds Academy content is included with every software purchase. Custom wait time metrics track a specific wait type or event. 4. THWACK. 14823. CustomProperties" and all will be right with this query. Click the Add Widgets button on the upper right. . Now in Report menu select "Show SQL" and check the SQL query in SQL tab. Click Submit. use [database] SELECT ComputerName, SourceName, Message. SELECT COUNT (RecordTime)*100/3759. Hello, I was wondering if it's possible to setup a query in SWQL Studio to look for flows that have a certain number of packets per second. Here's an example SWQL query to use: Welcome to the pain that is SWQL - SQL alike but not quite all the way As an aside, I've been trying to get an ad-hoc SWQL study / learning group up and running but see this post for info. Click Done Editing. Observability Solutions; SolarWinds Observability SaaS; SolarWinds Observability Self-Hosted; Insert html code into SQL query to show custom node availability Insert html code into SQL query. Observability Solutions; Custom Queries Classic Dashboard Widget List (and Search) Tags; More; Cancel; Options View all; Previous; Lines 93-98 contain the "search" portion you can use in the search query if you so desire. Here is the link that should do this if you have a SQL Server repo: Custom Report - Top SQL for Database User. This example describes how to customize a report to list and automatically install updates directly from the Report Viewer. So, you will not be able to reference macros in a Custom Table. Here's the SQL I'm using: SELECT StatusLED, Caption, NodeID, GroupStatus, NodeName, Hi, Here is what i have: It basically display the node, when it was down, and how many hours it is down based on the current system time. xxxx application has twenty nodes assigned to it. Uri) AS uri From Due to lack of OOB stats collection for Current user count on my checkpoint firewalls, I had to apply bunch of custom poller through UnDP. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. custom properties in your SELECT field but missed it your WHERE command. SolarWinds ® Orion ® has a cool feature that allows us to create an interactive searchable table, which we are using here as we need one place to go to see all software installed across multiple machines that are within SolarWinds. SQL Server Instance - Enter the instance if needed. You can use a Custom Table resource instead of a Custom Query resource. When I test this against one of our Aruba wireless controllers, it returns a table with 2 columns - Row ID and Test Result. There is a long time feature request to report on DPA's metrics in the product but, for now the data can be mined from the repository database. Loop1 Systems: SolarWinds Training and Professional Services. Netflow. ComponentAlert WHERE ComponentID = '90224' The output is a string containing 4 custom message results fron I am trying to create a custom query that polls a custompoller and returns a numeric value (as text) for the percent of battery load. and it returns the full list of nodes. Go to the view/dashboard to customize. AlertActive. Use native repair tools (Orion Configuration Wizard) 4. Via this manner I have given our Developers rights to have a restricted view in Solarwinds. Nodes AS Nodes. Had referred to a sample here: Text colour to display alerts using custom query. In order to build these, allow customers to submit a request to SolarWinds with the information they are wanting to pull and the SWSD support team can provide the query. Fill in any information you want to change and place your SWQL query into the Query field then click Submit . ip_address. NodeID, b. Create a Custom Poller. Drag the Custom Query widget onto your dashboard. And I am at a loss. CompileQueryExecutionPlan(String qu). it is at the bottom -- of the list. This could easily be adjusted to show other component types etc. Name AS [Alert], SolarWinds solutions are rooted in our deep connection to our user base in the THWACK You are asking for the last 1 hour in the text, but your filter is for the last month, so I'm not sure what you want. This is similar data to the chart in the upper left on the Home screen, but will allow you to see more than 10 days of information. It checks for node status, so if a node is up, it will disappear from the list. Click Add Custom Properties. In the Format field, select Text. NodeID = b. Its running a simple query to give me a count of all the active alerts: SELECT COUNT(AlertActiveID) AS AlertID. Parse(String query) at SolarWinds. WHERE NodeID=123. AlertActiveID, AlertObjects. This does not address the unmanaged nodes, those can be captured w/ a SQL query using the following " Status = '9'" It doesn't get you the details you'd probably want but it works in a pinch until the custom query is fixed up. You'd have to change that as well. You can customize the query to achieve a certain type of alert. Here's a step-by-step guide to achieve this: 1. This can be done via custom reports, which are available on thwack. For simplicity, if you see Orion in the following pages, please be aware that this is synonymous with the “SolarWinds Platform. When your query is complete, click Search to initiate the search. Hi Everyone, I was wondering if anyone had a same or similar issue when building a customer query? The below query works if I remove where AlertHistory. I called mine 'Node Details Root Cause' Update 04/20/2022 re-wrote the SQL query into a SWQL query, the file to download is the SWQL query but I'll keep both versions available here for reference. AssignmentName, ONPMC. Find the CustomPollerID's of those pollers using the 1st query below (not the CustomPollerAssignmentID's), and then update the 2nd query appropriately on lines 8, 9 and 10. This was a query I built some time ago but I'm posting it here -- In no event shall SolarWinds or anyone else involved in In the Alert Trigger conditions section, update the dropdown called 'I want -- to alert on:' to 'Custom SWQL Alert (Advanced)'. -- 3. Giving the ability to pull data from a module outside of reports built into SWSD. You can use this to set the text color, perhaps by using 0 tdanner over 7 years ago I have created a Custom Property "Serial_Number" for Nodes in NCM 7. Solarwinds Custom Alert Query: Failed Router. Merging data within two separate columns with custom format (per above preferred table) 5. If you have an Oracle repo here is the link: Custom Report - Top SQL by Database User. Crafted to be placed on a Node Details or an Application Details Page. The trouble I am having is attempting to convert the text field to an integer so it can properly sort the numbers. This query would be much more faster. if you have a lot of down interface alerts triggered. Node Details Custom Query widgets for Last 300 Syslog and Trap messages. The query I've been working with: SELECT ONPMC. csv file through other methods. s. The query works in the SWQL Studio, but does not show anything in the custom resource. e. Click on “Edit” in the top-right side to setup this I setup a quick SWQL Custom Query (below) to show certain Network Interfaces with the InPercentUtil and OutPercentUtil numbers, but I would rather display the numbers as they are shown in the Top 20 Interfaces by Percent Utilization (shown in snippet). Parser. This will open a new query in the tabbed query editor and pre-populate it will all properties (but not Inherited Properties) for the The image below shows the in built SolarWinds Widget, circled in Red is why I require this custom query to filter out the unwanted data within the table and in blue is what I want to add to my custom query. select n. Search for 'query' Drag the 'Custom Query' resource onto the page; Click on the 'Done Adding Widgets' button; Click on the 'Done Editing' button; Find the new widget on the page and click the 'edit' hyperlink in the corner of that widget. (See this blog post if you are not familiar with this technique: SolarWinds Orion Custom Query Resource - A Hidden Gem! | Prosperon Networks) So, a regular Custom Query resource would look like this: First THWACK post, so take it easy on me. CurrentStatistics Where ApplicationID = 1038. query to find nodes who have a custom property equal to a given value with something like this: nodes = swis. uri not in (SELECT distinct d. 3. IPAddress, ONPMC. You can add a 'Custom Query' resource to a Node You specify what alert and what you want to display in your nodes via #SWQL, pop it into a custom query widget, and then you get nodes with their status (maybe the status is associated with the relevant alert). Actually, I need to query all the nodes from SolarWinds including built-in and custom properties. Note that the Custom Table resource is different than the Custom Query resource and does not recognize the _IconFor_XX and _LinkFor_XX conventions - it has its own way to handle links. will then search the results of the above query and filter accordingly. I haven't found a way to correct how the time is displayed. Do you have a template I can use? I have tried a few different ways and it never returns anything. AlertObjectID, AlertConfigurations. Query building tips and examples. If it is more than 2 groups (like Nodes -> child Group -> Parent 1 Group -> Parent 2 Group), it will not work and not possible to represent in a single swql query. HTH. Your original query is fine, if you want the availability of all 'network' devices over the last month. Apm. I am looking for a query to get the same. With this component, you can query a monitored SQL Instance with almost any query Click the + icon to add a custom object resource. I have zero knowledge of solarwinds. This query will get all the notes for node 123: SELECT AccountID, TimeStamp, Note. I would recommend filtering this further if possible using a specific alert instead of the OOTB "Interface down" alert or by other properties. For reference, here is the whole query from the Create an SLA report showing Inspired by a comment thread from Unmanaged Muted - Report Lab - The Orion Platform - THWACK (solarwinds. The CustomPollerID of snChasUnitActualTemperature should go in line 8 for the first INNER JOIN, then so on with the others. SELECT ac. One of the UnDP's is collated to a custom property that is attached on a Node. In the navigation menu, expand Administration and Reporting > Reporting > WSUS Reports. On your dashboard screen click Edit on your new widget. Click the pencil icon on the upper left. Under Query Type, click the SQL radio button. As a resolution attempt, I tried to create a custom SWQL query resource with similar information. This custom query widget detects any Dynamic Queries for each group that rely upon Custom Properties. Follow these steps: Go to Settings > Manage Pollers > Create New Poller. Stats. 13. I have a custom attribute for nodes that is used to designate the environment. commented out the special custom properties, fixed a typo Ability to build and save custom reports based similar to standard SQL queries. 3. Cheers for help Lots of things that I've tried will work in the SWQL Studio/Custom Query web resource but get rejected when I try to use them as a source for the report/table tools. So The same query works with the email version and if I run the query through SWQL studio it works as well. The same steps can be used also for other tables if you are not sure about the tables, columns and the bindings. CPULoad AS CPU, n. custompollerstatistics), where it equals or does not equal some value, that's easy. There is also a feature request to show data in a better format (mostly tabular). Assign a template. ObjectType, 1. SELECT b. This custom query will return historical wait time data for the specified timeframe, and y default it shows data for the last 90 days while summarizing to a daily level. To use this, you will need to download this HTML/JavaScript file, add a "Custom HTML" widget to a summary view, and then copy/paste the contents into the custom HTML widget. DisplayName FROM Orion. I noticed it was the victim of a deadlock recently, and I want to ensure that it Find the best place to learn and ask questions about your SolarWinds products. The data represented. in which the query results only reflect that specific object. pnbemliyd phrauf dlyk nbwi wvxnyg tdms lhhhs utdda ziukpcm oauhp