wluther · Breaker of Things · ✭✭✭✭✭

I agree with Mr. Shore here, 100%, it's the knowledge you gain and what you do with it that matter. You could take and pass every SCP exam there is, but it's probably not going to impress the pizza delivery guy. These exams are a great way for you to gauge where you're at with where you might want to be heading towards. In…

Sorry, I just re-read what you said, and it looks like you are wanting to pull all nodes, and the SwitchStack info. I'm sure there are better ways to do it, but a quick and easy way is to UNION the SwitchStack SWQL above with a normal SWQL with node data which is not in the SwitchStack results. That should give you data…

I'm not sure about what is required for a SQL query to the DB, but this SWQL query might point you in the right direction. You can use the implicit joins with SWQL, and should be able to filter out however you'd like by adding a WHERE and whatever you need there. SELECT DisplayName,…

No worries, we've all been there. Well, at least I've been there, a bunch, nearly enough to be considered a permanent resident. lol A long time ago, I had put out some SWQL stuff to help me manage my views, back before dashboards were even a consideration. I found a few links to those old posts, but it looks like some of…

 @"ConnorS68" , Classic dashboard, or views, are built completely different compared to the newer "dashboards". You would need to look through the tables for views, resources, and the properties for each. The ResourceProperties make up the Resources, and the Resources live on a View.

This is a great addition, and very useful. Thank you for sharing.

It looks like I left out the... well, the LEFT on that JOIN. SELECT TOP 1000 AlertHistory.AlertHistoryID ,AlertHistory.EventType ,CASE AlertHistory.EventType WHEN '0' then 'Triggered' WHEN '1' then 'Reset' WHEN '2' then 'Acknowledged' WHEN '3' then 'Note' WHEN '4' then 'AddedToIncident' WHEN '5' then 'ActionFailed' WHEN…

@"kenyamson" The EventTypeWord, as created in the view, is a case statement, which should be fairly straightforward to replicate, if needed. The entirety of the view, at least to me, in my db, is below. USE [SolarWinds] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create view [dbo].[AlertHistoryView] as SELECT…

Glad to hear you got it working. Don't forget to show off your dashboard and share it with the community once you've finished it. I'm a big fan of customizations here, and I know I'd love to see the end result, no matter how simple or advanced it may be.

Also, in case it's of any use, though I know it's super old, this link has numerous references to other info in regards to playing with the HTML widgets. Using Your Custom HTML Resource To Properly Display SWQL Query Results

@"Tahmaseeb" I'm not sure it's exactly the same thing, but I ran into something similar to this a long while back when working to display some Google charts in a different layout. I had started with everything all in a single HTML widget on a view, which worked fine. Then I wanted to break each piece off into its own…

@"Tistopher" There should be a few default alerts already out of the box for this. I have the following SWQL query sitting on a view for various NCM stuff. SELECT TOP 10 TransferResults.NodeProperties.Nodes.Caption AS [Script Executed on Node] , UserName AS [Who Executed Script] , MAX(DateTime) AS [When The Script Was…

I'm not sure if it'd always work out as expected, but you might be able to have the alert fire off a PowerShell script to manipulate the string data, then store it into a different custom property. Then, you might be able to have a 2nd level escalation fire off to do the email part of it which would call the data you…

@"mgebauer" Just a quick question on display names. While I understand updating the software/version will likely clear this out, would there be any additional negative side effects of manually adding the names to the .js file (C:\Program Files (x86)\SolarWinds\Kiwi Syslog Server NG\wwwroot\main.js)? Other than having to…

 @"mgebauer" Not to dig up old posts, but I'm in the process of setting up new NG servers, and was wondering about settings as well. Aside from possibly having to change some server specific info for each new server, would there be any issues with simply copying the files from a production server…

 @"sw44" Just out of curiosity, what happens if you run it through the SDK? I presume the account you're running in the script has permissions to accomplish the task(s) at hand, yes? Does your script work for any other nodes, or does it fail (same results/error?) for all nodes?

@"ShawnJohnson_DBA" Well, you're already off to a great start, having loaded up the SDK side of things already. I have found a wealth of information in the THWACK community, though it usually seems to be buried away and pretty well hidden, unless you already know what you need to find (which most of us didn't until we…

@"Sheetalkumar.Akkolli" You should be able to find that data under the HardwareHealth section. You can probably start with Orion.HardwareHealth.HardwareItem, or one of those, and build out from there. Is this what you were looking for?

Are you just wanting to include the total node count within the query, or are you actually wanting to know the single highest nodeID value? If you just want to know how many, I suppose you could just add a count in there, or you could drop in the highest nodeID too. SELECT NodeID ,(SELECT COUNT(NodeID) AS [TotalNodes] FROM…

@"Mike_Lomax" Do you still get an error if you remove the "SolarWindsOrion.dbo." part? SELECT ComponentID FROM [APM_ComponentSetting] And, not to be silly, but you are running it as SQL and not SWQL, yes?

@"CARION" Hey there, just wanted to clarify you are actually trying to go from SQL to SWQL... As far as I can tell, this already appears to be SWQL. What, exactly, are you needing from the query? You could probably trim it up a bit, and should be able to get away from using the join, otherwise I think you are already where…

You always do great work, sir!

@"JeffLyon23" You should be able to click on the "1-5" in the middle of the bottom area, and then choose a different number of alerts to display.

I can't speak to the latest and greatest version, but I have always just used NCM to accomplish this, at least for basic stuff. For more advanced actions, I've built out scripts on the Linux boxes, then trigger the alert to run commands via NCM and initiate the server scripts. But for simple one liners, using NCM (either…

You can definitely pull those values with this method, though it may end up being more work down the line if you have replaced all the vendor, machine type, and sysOID values, as those are fairly important for general use. I 100% use this method to supplement various data points across many of our device types, but I try…

Also, nothing fancy needed for the report options, other than grouping, and sorting (if it matters).

@"robert777" I think this might be something closer to what you're looking for, at least compared to the example I provided previously. SELECT DISTINCT n.Vendor ,CONCAT(n.Vendor,' (',[VendorCount].[VCount],')') AS [VendorTotals] ,n.MachineType ,CONCAT(n.MachineType,' (',[MachineTypeCount].[MCount],')') AS…

@"robert777" As Seashore said, you can use SWQL to do a simple count and push it into the caption, or wherever you want to show it. This is a wee bit inefficient, but figured it would get the point across. There are probably many ways to get this info, or something similar, into your report, but it depends on how detailed…

If you have already replaced the default fields with that data, you can sometimes, and very easily, just reference that data with a simple macro and lay it out however you want to in a HTML widget. SysName: ${SysName} Contact: ${Contact} EngineID: ${EngineID} LastBoot: ${LastBoot} LastSync: ${LastSync} Otherwise, since you…

This shows the same info, but polled via each method. You could get more specific if you drill down and filter the UnDP data by directly picking the named poller. SELECT CustomPollerName ,StatusDescription ,CurrentValue FROM Orion.NPM.CustomPollerAssignment WHERE NodeID=${NodeID}