wluther · Breaker of Things · ✭✭✭✭✭

Comments

  • jeffreyc‌ I'm glad you got what you needed to work. Thank you, -Will
  • rhrohde​ I would remove it, as your goal would be to always have these fire off whenever one of the properties exists. I would remove the eval frequency, and time of day. I would also remove that reset condition, and use the "Create a special reset condition for this alert" reset condition instead.
  • nato​ Well, unfortunately, it's pretty plain and simple for the most part, and nothing fancy going on. The most important change we made was jumping onto the dynamic To/CC/BCC bandwagon a while back. By adding these custom properties to the nodes/interfaces/volumes/etc., you are able to send your alerts dynamically, based…
  • I agree with this too... there are far too many unused pixels there. I would rather have a full screen window/pop-up, allowing me to see all the information, or as much as my desktop will hold. Also, on a tiny little side note, why can't SolarWinds use that "double click column" technology, similar to a basic excel window,…
  • rschroeder‌ After you get the SDK installed and running, try the SWQL query below to view all of the different interface types you have, and how many of each you are working with. SELECTDISTINCT(Type), TypeName, TypeDescription, InterfaceType, COUNT(InterfaceType) AS tncount, InterfaceSubType, InterfaceTypeName,…
  • rschroeder‌ No worries, we are in the same boat here... I would love to have the UDT module, however, it is simply at a price point that does not match our use cases yet... Hopefully, some day soon, we can get this one. As far as doing this in NCM, perhaps you can take a look at the "Cirrus.EntityPhysical" table, through…
  • Best of luck on your adventures. Let us know how it goes, or if you need any assistance. -Will
  • npereira1‌ Try changing the "ORDER BY eventtime desc" on the last line to one of the following: ORDER BY Down_Event_time desc ORDER BY UpEventTime desc ORDER BY Caption desc ORDER BY Message desc ORDER BY outageDurationInMinutes desc All of these appear to work for me, and we are running the following: Orion Platform…
  • kcai​ Yeah, I think the syslog part of it basically just takes anything that meets the criteria of the filter, and uses the RTNForwarder.exe program to send the output to SolarWinds, which does an all or nothing email. If that is the case, I suppose you could setup 2 different rules on the syslog side to at least…
  • rob.hock We are still very very interested in this functionality... We are also willing and waiting to discuss anything SolarWinds can do, with anyone SolarWinds has available, in regards to getting this option up and working. (fortunately, hcy01uk has presented another way to skin the proverbial cat... but it still seems…
  • I would most definitely be interested! This is basically the "missing link" to bridge the gap between departments and get rid of that old MRTG system. Please include me in everything you have that will help me out here...
  • I would think, if the syslog message comes from a licensed node, then it has the ability to become tagged. If the syslog message is not licensed, then a tag cannot be applied, regardless if anything in the message matches the rule. Process the rules, only applying tags for nodes which are licensed. I'm sure it's not that…
  • JessicaWalsh‌ Well, I got a little busy and did not really have much time to do too much. However, when all else fails, just peek under the hood... Here is the SQL used to create the default "Top XX Interfaces By Percent Utilization" resource. SELECT TOP 10Nodes.NodeID,Nodes.Caption as…
  • JessicaWalsh‌ I am not aware of a way to sort via the SQL filter line. You would probably be best to put together a little SWQL query into a "Custom Query" resource, and sort it that way. I will check and see if I am using something similar, and will post it back here. -Will
  • rschroeder​ Nope... After that big NPM 11 to 11.5 debacle, a couple years ago, our upgrade process has changed severely. The NPM 12 upgrade would have killed too many things for us, and we would have lost a bunch of custom resources... My first project of the new year will be a 1:1 conversion of every custom resource we…
  • llinteau12​ Yeah, that custom table resource does limit the output, by default, which is why I went ahead and converted it to SWQL, and hardcoded the profiles. However, using the same SQL query as you have done in the custom table resource, you should be able to use the "Orion Report Writer" (program needs to be ran from…
  • rmothersbaugh‌ Maybe better idea to test out cnorborg‌'s idea. I think his would be the better solution.
  • cvachovecj‌ Then it is settled. cnorborg‌ is hired! Now, with Jiri & Craig teamed up, the NCM team is unstoppable... Yeah, I know what you meant, I was just messing around. But, it is really cool that a user can find a new, and unintended, way to use a tool, and then the staff just comes right on board to investigate the…
  • valleyman​ I think there is a custom property (system/default), which indicates the node is being managed by NCM. Using that value, you might be able to simplify your selection in the report(s).
  • gsmann​ Glad to hear you got the first part working. As for the next problem, it shouldn't be much trouble at all. NCM allows the use of NCM/Orion variables, so you should be able to easily pass the node name through the command. Here is an example I have used to update the SNMP Location field, via NCM, reading the value…
  • bobmarley​ For what it's worth, maybe this could hold you over until something better is created... Using the "All Nodes - Tree (AJAX)" resource, on the filter line, you can utilize a SQL sub query within the WHERE clause, allowing you to pull nodes in from the groups table. (ContainerMemberSnapshots) Now, this works fine…
  • Jiri Cvachovec I think we can manage a work around for the password of the day issue. It would be nice to be able to build a "Properties" page for these devices (which I know we can do, by device type) to show all the SNMP data we need to view. Then, on this same page, be able to manage the device creds (ssid, wpa2 key,…
  • noobes​ Well, I'm not sure why it would double up there, but perhaps we can work through this by stripping things down to basics. Have you tried to bypass all the macros? If not, try the following: Not being familiar with your equipment, and the commands required to accomplish your task, do you actually need to exit the…
  • bsciencefiction.tv just so I make sure to get this correct, based on your screenshot... We have npm1.server.com, npm2.server.com, and db.server.com, and our sqldb is called npmdb, using the default settings/ports during the initial install... SERVER ALIAS: does it matter what this is called? SERVER NAME: you said Database…
  • tdanner​ I probably got a little overexcited, and carried away there... I use those custom query resources all over my environment. They are great, and I am able to do almost everything I need with them. The one thing I find myself doing, over and over again, is manually building the node management links into the query.…
  • patriot​ You can just combine the poller name with the total poller elements, and then group by that, which should give you a single line, containing both the poller name and the total count for that poller... Just change the "PollerName" line to the following: TOSTRING((n.Engine.ServerName) +' - '+…
  • Actually, after having had a stern talking to with my brain, I realized the ones I have been waiting for are "Resources" and "ResourceProperties". Oh well, close enough... We will get there, soon enough.
  • lorenzo.schittone​ Well, I thought there was an option for this somewhere, however, I cannot seem to find it, so I am thinking I am simply mis-remembering my options. You can check the advanced settings, /Orion/Admin/AdvancedConfiguration/Global.aspx, but I am now uncertain if the setting actually has a global option. You…
  • cobrien​ I have opened a support ticket, case # 994757, as well as uploaded the diagnostics file. If anyone wants/needs to poke around in the system, I should be around most of the day. I'm sure it is just user error, but I suppose time will tell. Thank you, -Will