cnorborg · Network Professional IV · ✭✭✭✭✭

Are those other answers SPAM? I think they're just a random post with a link going elsewhere, not about to click on the links! I went ahead and put your query in SWQL studio, and while it did run, it didn't come back with anything as I expected. When I put it into a resource on a page via the "Custom Query" resource it…

Huh? Back input? Not sure what you're saying…

Quite possibly? I think if you add this to the SELECT section it might give you what you want? n.Interfaces.IPAddress.IPAddress AS [Interface IP],

I know the feeling!!

We tend towards a bit more manual approach. We have simple scripts to load the software onto the box. Then we have another script that installs and reboots. The actual firmware upgrade process is a bit complex. The whole copying the software to the FTP directory and such tends to break down for us.

Hmm… How about Dyson? Dyson Spheres are built to harness all the power of the solar output from a star?

As mentioned in my last comment, the InterfaceName is rather boring and doesn't include any description you put on the interface configuration. So, try this instead. SELECT n.Caption AS Hostname, n.Interfaces.InterfaceName AS Interface, n.Interfaces.Mac AS Mac_Address, n.IPAddress AS IP_Address, n.MachineType AS…

Yep, you can try turning on auto-dependencies to see if that works for you. If not, look into using groups. ie: assign all devices at a site into a group and set up the dependencies on that. The router can't be a member of the group if you want to use a group in a dependency. You can also use it in your alerts if you want…

The second query is definitely "better", but I'm guessing for the WHERE clause that you really want to use "n.interfaces.caption" as the thing to compare against, not the actual name of the interface.

Only 17 years, a newbie!! 😉😜

This would be a good feature request. Where do those go now?

You should be able to get that info out of UDT if you're monitoring all the ports. Something like this? SELECT TOP 1000 AE.ConnectedTo, AE.HostName, AE.IPAddress, AE.MACAddress, AE.PortNumber, AE.VLAN FROM Orion.UDT.AllEndpoints AE WHERE (AE.ConnectionTypeName = 'Direct')

Yep, we do the same. Usually we make a group and do account limitations. The big issue is with things that need administrative access. There is no way to limit that, plus there is no good way to audit it. Even if you do impose limits on an administrator, they can just go and change their own permissions. This includes…

Actually, it does support negative lookaheads, that's actually a big reason I'm an MVP. Unfortunately it looks like that post, or posts actually, were deleted during the upgrade this time… :-( Maybe you can still find them, but I couldn't with a quick look. I don't have time to prototype yours out right now, although it…

Edit your Dashboard, add a "Custom Query" resource if an old style dashboard, if a new style, it will need to be a table widget. Put this SWQL in, modify it to your needs… Should have what you're looking for. You can use it in a report also. SELECT TOP 1000 NeighborIP, N.ProtocolName, ProtocolStatusDescription,…

Very close! But forgot the "AS". This should work. SELECT W.SSID, COUNT(W.SSID) AS Clients FROM Orion.Packages.Wireless.Clients W GROUP BY W.SSID

Sure, have you looked into "Compliance Reports"? You can make a rule for most things that you can either run when it finds a problem, or you can actually have a compliance rule run and fix a problem automatically without intervention. Couple that with Individual "Device Login & User Account Credentials", and "Config…

This works for us? We put this into a report. SELECT OrionNodes.Caption, OrionNodes.DetailsUrl, OrionNodes.Status, OrionNodes.ChildStatus, NcmEntityPhysical.EntityName, OrionNodes.IP_Address, NcmEntityPhysical.EntityDescription, NcmEntityPhysical.Serial, NcmEntityPhysical.Manufacturer, NcmEntityPhysical.Model,…

There is a question above that one, a slider bar. I missed it to the first time I tried…

Should the version really matter? This probably has nothing to do with the application itself?

I'd probably use the Orion.CPULoad table? Has both CPU and memory. Should be simple to do a query to look at the last hours worth, looks like it polls every 10 minutes. Just have to decide what value to use? Min/Max/Avg for each? For memory they have %, but for CPU they do it by Load. Just playing, but you'd be looking at…

You can use the same database server, although it should probably be another database. They used to require a separate server before they moved it to MSSQL. When should you get a separate one? When the SQL server is getting maxxed out, your DBA's should be able to let you know this.

So, the OID you're probably looking for is 1.3.6.1.2.1.197.3, probably the ntpAssocOffset table within there. It does poll on my Cisco 9000 and 3850 platforms. It gives you a table of values for whatever your looking for, in the case of the ntpAssocOffset it gives you the time offset of each time server. An active one will…

While I do believe that there has to be a better way than SNMP, I'm also somewhat of the belief that its popularity stems from how well it works the majority of the time for most applications. Yes, you can complain all you want about SNMPv1 but I don't think very many organizations actually use it. I would definitely be in…

Guess I'm a bit confused, I don't have a problem with this. Not sure why it would be an issue for anyone. I use the same "Connection Profile" for my ASA firewalls as I do my routers an such, having the "Enable Level" set to "enable" on a device that doesn't have a second prompt for an enable password doesn't hurt in my…

Maybe rather than calling it the "Dark Theme", we should shoot for a catchier name so it will gain popularity quicker?! I'm thinking something along the lines of "Baby Dark Theme"? I can hear the theme song already!! Baby Dark, do do do do do do! Baby Dark, do do do do do do! Baby Dark, do do do do do do! Baby Dark!!

Hmm.. Just thought of another feature I'd like. When you're testing a rule in the NCM compliance section and it says your policy is violated even though you don't think it should be. Below it it says, in this case at least, + Config Block - Start Line: line vty 0 4 Line Number: 226 Pattern XXX was not found It would be…

I did actually find a solution that works in my testlab, but not on my production system. Trying to figure out why though! But, I'll go ahead and post it in case it helps someone. On the Cisco box, you are supposed to use the "snmp-server context" command to associate a context with a vrf. ie: "snmp-server context…

Guessing you could probably do this with a custom SQL or SWQL report? Might have to get your database guys to help you out with the query, but if the data is in there, you can probably report on it. There just might not be a report already made up or a way to do it using the GUI...

Duplicate of