wluther · Breaker of Things · ✭✭✭✭✭

No worries, there are a bunch of nooks and crannies to get tied up in when it comes to views. Just to make sure we're all on the same page (pun?) here, let me just jot down a few random, and general, points, in regards to views. ViewType ViewID ViewTitle ViewGroupName Edit View/Page Settings Edit Widget With all of that…

@stuartd I'm fairly certain you are applying this query to a widget on a node details view. Try creating a new view, with "Type of View" set as "Summary". Different view types will require different objects to also be loaded along with the view, otherwise they will not work properly. You can add on directly to your URL to…

Just to test and verify if I was able to pass any/all of those 3 characters through, I sent them to a box to update the snmp location. I started with passing just the quotes, and that went through just fine. config t snmp-server location "Head Quarterss" exit copy run start Then I added the quotes and the carat, and that…

@"rednarb" Also, how are you currently attempting to run this command in NCM? NCM job, Configuration Management page, run script/CLI from node details view, device template command? For the commands I need to pull every day, I like to add the command directly to the device template, and just include that new "config" type…

@"rednarb" I'd start by making sure to enable session tracing, this way you can see exactly what is going on between NCM and the device. From the settings page, click the "CLI Settings" link. Then, click the checkbox to enable session tracing. Those logs should give you the play by play, and show you exactly where the…

Yeah, sorry about that. I usually try to comment out/reduce the custom properties and where stuff, but just slipped my mind this time. Glad you got it working! If you need anything else, we're all here to help. Thank you, -Will

I'm not sure I remember who, exactly, I "borrowed" this from, but I'm certain I had asked a similar question to what you are asking now. I use this version on a "Device Details Summary" view, to look at different aspects of similar devices. I had added the NCM config backup info onto the end of this so I could view it all…

@"domagaj" I'm not sure if this is what you are talking about, but you can use the CONCAT function to easily string together just about whatever you want. Combined with the [_LinkFor_] label, you should be able to build out all sorts of custom links. SELECT n.NodeID ,n.Caption ,n.IPAddress ,'NewURL' AS CustomLink…

ecklerwr1​ Yeah, I think it would be pretty funny if someone could get it to work that way.

rlawrence​ I have not forgotten about this, just had a bunch going on lately. While testing, all of my results came back as I would have expected them, and I was not able to see anything that looked out of place. Just so I don't leave you empty handed while I look into it more, you can add the following line to the SELECT…

npereira1‌ Oh, hmmm... 3 days ago, and still no response... I would definitely call support, even though they should contact you first, on their own, and get things moving. I usually open my tickets through the customer portal, upload my diagnostics files, as well as screenshots and anything else they may need, and then I…

npereira1‌ Well, unfortunately, I do not have the knowledge, or experience, to give you an answer on this one. I would recommend you create a new discussion/thread, separate from this one, and ask Thwack Nation for assistance. I think you will get a better response, asking this specific question in its own, new, thread, as…

rlawrence​ Hmm... I am not sure on this one. The field that has those lines is basically just the entire config, all in the same place. I suppose we could pull just the first line, or xx number of chars. If not able to get it done in SWQL, I am certain this can be done in SQL. I will check it out, and see what we can come…

dgsmith80​ The way they told me, was if Kiwi forwards the messages from 5 different nodes using the option to forward as source, then yes, it would consume 5 licenses. However, if you have kiwi forward those messages without retaining the source address, then those messages should arrive on you SolarWinds server with Kiwi…

brinky​ Well done! Glad they could get you fixed up. And thank you for marking your answer as correct. Thank you, -Will

npereira1‌ Hmmm... well, that is strange... I have copied the query you previously posted, and it works for me. SELECT * from (SELECTStartTime.EventTime AS Down_Event_time,(SELECT TOP 1EventTimeFROM Events AS EndtimeWHERE EndTime.EventTime >= StartTime.EventTimeAND EndTime.EventType = 5AND EndTime.NetObjectType = 'N'AND…

nafees.khan​ Another semi-useful trick allows you to do a multi-search, using just the single search box. It is nothing fancy, but it can sometimes help, if you are familiar with the various tables, and what data is available. Basically, all you need to do is continue the WHERE clause in the search box. The search box just…

sja​ That seems odd. So, you are saying once you click on that "06-06-2017 15:11 - ShowChassisHardware" link, it takes you in to view the config, but the results are showing as if the command ran one of the default config backups, or does it show you the data you would expect to see? If I had to guess, from what you have…

сергей Starting with just a little piece of the query, as this is probably all you should need to show the stats/count for a single node... SELECT TOP 1 SUM(((LEN(XmlResults) - LEN(REPLACE(XmlResults, 'access profile BB12', '')))/LEN('access profile BB12')-1))OVER() as "BB12"FROM SWNPMDB.dbo.NCM_PolicyCacheResultsWHERE…

sotherls​ & orioncrack​ I have been doing a few upgrades recently, and figured a way to keep the custom resources alive in NPM 12.1. While initially running the config wizard will remove all of the custom resources, I was able to see my old resources after I made an edit to the "/inetpub/SolarWinds/PrecompiledApp.config"…

I actually really liked the way it used to work (pre NPM 12). Seemed to be very easy, and simple, to get custom resources added. Seems like they have been getting away from that for a long while now. I believe it was, possibly, version 9, where you could make simple ".resource" files. Then they upgraded tech, but things…

No, not yet. I am still in the long process of upgrading, so I have not really had too much time to start working on the fun stuff. Hopefully I will be able to finish all of my upgrading prep work soon, and get back to customizing it.

@"Last_Ninja" , sure. Using Dan's example: SELECT ca.NodeID, ca.DownloadTime, ca.Config FROM NCM.ConfigArchive ca INNER JOIN ( SELECT NodeID, MAX(DownloadTime) AS LatestDownloadTime FROM NCM.ConfigArchive GROUP BY NodeID ) cam ON cam.NodeID = ca.NodeID AND cam.LatestDownloadTime = ca.DownloadTime ORDER BY ca.NodeID Just…

One of the AEs I spoke with suggested we simply send it all to Kiwi (which is a bloody nightmare to manage in the first place), then have kiwi forward over things we need (which we currently do anyway). He said, since it's coming from Kiwi, it would only take a single license. While I initially wrote that off as the worst…

newkidd2‌ 30 days... nope... that is too far out of the powers of my time machine. It would be nice to have some sort of "SolarWinds DataBase Converter Tool" type of program... Backup the db, take that backup file, import into conversion tool, enter NPM version to convert to, take newly converted backup file, restore to…

bsciencefiction.tv Thank you very much for your prompt replies and assistance. I finally got everything setup, however, I do not think this solution has improved anything for us. I think our problems are hiding elsewhere. Just wanted to say thank you nonetheless. -Will

npereira1‌ Your report will ALWAYS fail, in report writer, when you use the "NodeID = '${NodeID}' " filter. However, just because it fails, doesn't mean it will not work. Just go ahead and save your report, and add it to your resource. Does it fail on the node details page too? I copied and pasted exactly what you have,…

I completely agree with you. While it's not the same, I'd say the current PerfStack option is the closest SolarWinds has to the example above.

@"Last_Ninja" , you should be able to add ca.NodeProperties.Nodes.Caption as one of the fields, which should pull back your node names.

cahunt​ I wonder why they always show up in this thread...?