dhanson

I did a bit of network support/help desk/on-call at a major healthcare provider at my old job. I also handled a lot of projects, and this is where customer service tends to mean significantly more...especially when you're sitting in a meeting with a bunch of people who want you, as an engineer, to solve all the problems…

I've got the LEM "Connecting to Demo Server" issue as well. Just sits there. Waiting multiple times on multiple browsers for 10 minutes or longer, no change. Anyone found a fix for this yet?

This should really be a native feature, and the fact that it is not is rather confusing.

Dear Network, I'm really sorry about the last few months. I couldn't control our ISP from causing so many outages, and I keep planning ways to resolve this, but Mr. Budget won't let me use any of them. Oh, and that wireless bridge thing...not my idea, bro. Totally a headache, and it got you a lot of scornful looks...kinda…

Cisco's wireless web GUI's make more sense than their CLI's. Of course, there are things you can only perform through the CLI, but for everyday maintenance and operation, the GUI is satisfactory. This applies to practically every wireless device I've managed through Cisco (autonomous WAPs, WLCs, WCS). Herein lies the…

Say (god forbid) you have cancer. Your Oncologist tries the first two logically suggested treatment options for your type of cancer, but they have no effect. It continues to spread. You're rightfully scared, and fearful that the next treatment might be just as ineffective. Your doctor calls Caris (the company I work for)…

Have you tried using Custom Node Properties to add this? I can imagine this working for your need. Imagine here you have "Vendor_Portal" and the address...and you can use "manage nodes" to modify multiples at the same time. This wouldn't be difficult to implement, even in a large deployment. Even if the hyperlink doesn't…

So I don't think I'm good enough to color code this stuff, but I'll look into it. As far as limiting it to a specific temperature, you can add a HAVING statement to limit results to values that contain "x <operator> y" like x > y. for instance, if you want this to only display results with values in excess of 30, you can…

Yeah, a couple of the queries I put up were SQL. That's my fault for not re-reading the original question. The final working one I've got below includes the [Last Polled] column that pulls the DateTime from the pollers. n.LastSync can be way off from the last polled time, but if you're lucky they're pretty close. I'd keep…

Ok, here we go! SELECT n.Caption AS NodeName, a.Status AS OutputFreq, b.Status AS InputFreq, c.Status AS OutputCurrent FROM Orion.Nodes AS n INNER JOIN ( SELECT a.NodeID, c.Status FROM Orion.NPM.CustomPollerStatus c INNER JOIN Orion.NPM.CustomPollerAssignment a ON a.CustomPollerAssignmentID = c.CustomPollerAssignmentID…

I've been testing queries through the Database Manager and SWQL Studio. When I get a successful parse, I'll plug it into Report Writer to verify it will return results. The first query I gave you worked in Database Manager and Report Writer, but not in SWQL. The 2nd one was done solely in SWQL, so it should work there.…

Oh, and just in case you were curious, here's a 3rd way to pull the exact same data....This uses pivots and can replace the first SQL query I gave you...it's significantly shorter. This does not work in SWQL Studio (Studio doesn't like PIVOT's) but will work in Report Writer or Database Manager. SELECT DISTINCT TOP 1000…

Why not add a custom property to all your interfaces...basically used/unused...initially, this requires quite a bit of overhead and management, but once it is in place (assuming it works), it may be helpful. Once the property is in place, you can change your alert logic to include the status of the custom property as a…

Ok, back to paying attention to the initial question! I've tested the below query in SWQL Studio, so you should be good to go. You want this in SWQL. Sorry. I've went and bolded the flex values for this SWQL Query. EDIT: apparently bolding something in the advanced editor doesn't necessary become visible, but I'm sure you…

Ahh, so I believe I've figured it out. If you are using SWQL Studio this doesn't work. Let me see if I can find you another way of doing this. My bad.

Don't forget to mark jm_sysadmin response as the correct answer. Does a world of good for people who might be in the same boat, and jm benefits from a couple extra thwack points. =)

Yeah, that browse button isn't appearing on my screen, no matter how I modify the query to populate the column. =( It does appear (with the same query) when I put it in the web-based report, but will not populate when I throw the query in to the Custom Chart. When I was searching for an answer, I saw something about…

You have an extra comma in there after the last parentheses. Remove this and give it another shot! (...) ORDER BY s.Status DESC ) , <------this can go SELECT n.Caption AS NodeName (...)

Sounds like a positive result. =) Don't forget to mark questions as answered, if this yields the results you are looking for. =)

Represent!

Don't think it makes a significant difference, unless you start observing repeats in your query. Otherwise, glad it's working for you. =)

What I mean here is that I could populate the Time column just fine in the report, but it isn't seeing it in the Custom Chart Resource. As with the report, it requires a Time Column, and my query provides one, but it isn't seeing it as an option here. Any ideas?

Ok, I'm working on this, but my tables are a bit different. What version of NPM do you have? I'm in the process of creating a couple nested groups so I can validate this.

Ok, got one for you, and it could potentially be optimized and improved to be shorter and a lot cleaner, but this will get you the results you want. Just replace "POLLER#Name" with the name of the appropriate UnDP's you want to filter on. Don't forget to name your columns properly in the final query (e.g. row 36…

I saw your first version of the message (filter results based on a similarity between node names) and this is very easy to do. Check out the bold below, as it is the only change (this isn't your ideal output, but the output I described before): SELECT c.UniqueName AS [Poller Name], s.Status AS [Current Status],…

If I figure out how to embed links in custom SQL queries, I'll let you know. If you'd like to give it a shot, I'm looking at this article (Node Details URL in custom SQL Report) to hopefully learn how to do it. Right now, I can't seem to figure out what they mean by " add Details Page Link display setting to your caption…

I'd play with the final query as much as you can. Since I don't have anything similar (nor can I set up something similar) in my environment, it's difficult for me to diagnose what could be going wrong with the query. I really wish I could, because this sounds like a fun request. =/ I'd start with: 1. simply selecting all…

"now I am getting alerted on the UnDP, but always alerted now" - This might have to do with what you're triggering on. Can you send some SS's of your configured alert and action? ciscoEnvMon alerts are based on either temperature, power, or internal hardware. If you're getting these alerts, I'd definitely investigate those…

It is. Otherwise, my report would not have worked originally...and I checked again, just in case. =)

designerfx​ mentioned that you've been talking about read/write community strings but your screenshot shows that you've placed "public" in the read-only community string location with success. Can you confirm that your system is properly set up with public as the read/write community string? By default, many systems have…