Comments
-
weberam24 After re-reading your post, I think I may have provided you an answer to a question you did not ask. I will leave my initial response, just in case, but I am fairly confident, now, you are asking something that has nothing to do with my response... -Will
-
tborgg Also, you can remove the "WHERE" line at the bottom (unless you need to only be looking at those nodes), and use test it little by little by adding "TOP 50/100/500/1000" up top. Directly after your SELECT, just add TOP 50, then try it again. SELECT TOP 50 Nodes.Caption AS Device_Name,
-
tborgg I'm not sure what's going on in that environment, but I took off the "WHERE" part of you query, and limited it to top 100, and it took about 20-30 seconds to populate results for me. I changed it to top 500, then top 1000, and even removed the top limit altogether, and it seemed to take roughly the same amount of…
-
Not sure why my formatting kept messing up on my post, above, but I shall try again here... SELECTTOP 100 [SWNPMDB].[dbo].[NodesData].[Caption], [SWNPMDB].[dbo].[NCM_PolicyCacheResults].[ReportName], [SWNPMDB].[dbo].[NCM_PolicyCacheResults].[RuleName],SUM(CASE errorLevel WHEN 0 THEN 1 ELSE 0 END) AS Info,SUM(CASE…
-
hcy01uk Okay, I was able to follow your excellent instructions to replicate your results. This is exactly what I need to accomplish, only I need it to show up on our custom sql results/report resource. We have a maintenance type page, which consists of advanced sql custom reports, and when a device has certain options…
-
hcy01uk SCHWEET!!!!!!! that is exactly what I need... I will most definitely work on this when I get back to work on Friday... Thank you very much!! -Will
-
hcy01uk This is actually very helpful!! I had no idea this could be done through reports... outstanding... This will definitely work for us for now. I would still like to be able to have a standard/custom resource available where I could simply pick and choose each individual columns without having to create a report. But…
-
ruzlebiff Check out this post about custom properties. There are several examples that pertain to exactly what you are wanting to do. https://thwack.solarwinds.com/community/solarwinds-community/announcements/blog/2015/10/01/custom-properties-how-do-you-… Thank you, -Will
-
bobmarley We do something very similar with the naming convention too.
-
stibi Thank you very much for the information. It is not exactly what I need, however, your solution is definitely better than the default view, and certainly easier and quicker to accomplish than what I am looking for. So, for now, your workaround wins, and a feature request shall be created shortly. Thank you very much.…
-
Jiri Cvachovec Yes, it would be nice to have a feature to automatically retry backups, only of devices that fail, every xx amount of time.
-
rschroeder If a solution does not present itself in the NPM/NCM setup, and you have the time, perhaps load up a VM and install the UDT module. Then snoop around in there and see if you find something that gives you an accurate count. I would think the UDT module would surely be capable of this, though, I would also expect…
-
mdriskell I would love to have a way to do this, but use custom properties on views, and have those links update automatically... When someone creates a new view, using the "Systems" cp, a link to that view would automatically be generated into that list...
-
carlowen Were you able to get this SWQL query to provide what you needed? Thank you, -Will
-
smiffy85 Here are a couple of my previous requests/comments, in regards to NPM permissions... Just for reference... I need user(s) to be able to add nodes & interfaces in NPM, but not delete them... It does not appear to be high on their list of things to do. -Will
-
kreases Following that document, you should be able to get a fairly decent idea of what you have via a SWQL query... While I'm not certain this will always be 100% accurate, you could probably use something like this to get started. SELECT n.NodeID ,n.Caption ,n.IPAddress ,n.Vendor ,n.EntityType ,CASE WHEN (n.EntityType =…
-
gowen.a@outlook.com I only ask that because, I THINK the list you want is in the NPM/Core side. If so, then do you need the list to be filtered down by some other SAM criteria? If not, then do you have any custom properties, or anything else, you want to filter by? (other than being a server, obviously) Thank you, -Will
-
millenium7 It sounds like you figured out the issue, great job! I am also not familiar with that vendor/device, but I'm glad to see your answers here, as this may help others in the future. Editing the device template is super simple, but if you need any assistance with it, just let us know, and I'm sure answers will…
-
noman4ever We use NFSEN for this purpose. It is free, lightweight, and fairly easy to use. It is a very simple solution, and will alert us very quickly. Unfortunately, we have not seen this basic functionality implemented within NTA/NPM. Here are the subject lines from the emails we get on a few of our NFSEN alerts: *…
-
rob.hock This sounds very helpful, as we have been in this same boat for a while now. Currently, we use "NFSEN" to monitor and alert us of network spikes (ddos), which seem to be happening on a more regular basis lately. NFSEN is a very lightweight and extremely useful tool to easily monitor for these attacks. We also have…
-
I bought a bag of the same name from a place with the same as the one you did... It is our diaper bag now, as it definitely holds...
-
JessicaWalsh Try using: Interfaces.Caption LIKE '*circuit*' OR Interfaces.Caption LIKE '*ckt*' I hope this helps. Thank you, -Will
-
xtraspecialj Schweet!! I like it. I had been trying to do that in SQL, with my tiny brain, but never could get it to work the way I wanted it to work. I reckon I have gone and made this more complicated than it needed to be... figures. Anyway, this is what I have for finding custom properties required in alerts. WITH…
-
tigerr Are you trying to add something INTO your Orion environment, or are you trying to export a list of node details FROM your Orion environment? If you have good data in your system already, you can export just about everything from the custom properties page. You can also import data back into the system as well. Would…
-
tigerr There is a table, Orion.NodeIPAddresses, which I believe holds ALL IPs found for/on ALL nodes. This SWQL query should show you every IP for every node in your system. SELECT NodeIPAddresses.Node.Caption ,NodeID ,IPAddress FROM Orion.NodeIPAddresses If you are wanting to filter it from a specific list of IPs in your…
-
I reckon I just do not understand why it would do that in the first place. If user-a adds 10 nodes, each node separately, then the logs show user-a has added 10 nodes. if user-b adds 10 nodes, all at the same time using network sonar, then the logs show user-b has added 0 nodes, while system has added 10. I do not…
-
fryman, glad to hear you got things running smoothly!
-
njoylif I completely agree with you there. While we do use the active alerts view in some instances, we tend to use more custom resources, utilizing our CP, than anything else. It will be nice when everything within the SolarWinds system can fully utilize all aspects/features of the products. Just takes time, I suppose.…
-
gegriggs@gmail.com Here is the actual step-by-step from the official SolarWinds Success Center: Schedule daily backups of config files - SolarWinds Worldwide, LLC. Help and Support Schedule daily backups of config files SolarWinds NCM installs an example job that downloads the configuration files nightly for all nodes in…
-
rob.hock any plans on implementing ${N=Alerting;M=Downtime;F=DateTime}, or some other formatting condition to easily allow for a "Days Hours:Minutes:Seconds" output? Perhaps something to show output in the same way/format the "Alert Active Time" column shows on the active alerts page...
