Am I just missing something? When I run a discovery and gives me the interfaces to select, I want to pick up anything that's not Admin Down, but
when I select "opearationally down", de-select "Administratively Shutdown", and hit "reselect interfaces" it still selects the "Administratively shutdown" interfaces. Bug? PEBKAC?
Can you post some screenshots to highlight the issue? I tried some filtering options here, and seems to be working as expected. NPM version is 11.5.2
I think that about captures it.
If I select only 'Administratively Shutdown' it *does* get the right interfaces, but I can't get it to give me only the interfaces that are down, but enabled.
And I confirmed it's 11.5.2 (per the text at the bottom of the page)
Right. I see what you are trying to do now. An interface that is in an 'administratively shutdown' interface is also 'operationally down' by default.
"If ifAdminStatus is down(2) then ifOperStatus should be down(2)"
So, the real issue is that you need an 'AND' logic operator for this filtering but is not available at the moment (may want to submit a feature request, as it can be very useful in a lot of other situations too)
the only workaround I can think of is
- From the discovery, import everything that is Operationally Down.
- Create a new Interface custom property called say 'DeleteInterfaces'
- From the Orion server, launch database manager, click on 'Add default server'. run the following query (I haven't tested this. You can first run a SELECT * from [dbo].[Interfaces] WHERE AdminStatus=4 ) The idea is to identify Admin Shutdown interfaces that were added as a result of operationally shutdown filter.
UPDATE [dbo].[Interfaces] SET DeleteInterfaces='Delete1234' WHERE AdminStatus = 4
- Go to Manage Nodes, change dropdown to Interfaces, include the custom property in the column list and search for the word 'Delete1234'. It should display just the ones you want to delete, and you can delete them in bulk
So I did this and it worked, so thanks!
What occurred to me, however, is that what I'm really doing using the value of a column in the table to populate another column in the same table... Is there not a more direct way to sort/filter on those columns themselves? Instead of creating a custom property whose value depends on 'AdminStatus', is there a way to just sort/filter on 'AdminStatus' itself from within the web console?
hrmm... That's bizarre to me. You'd think something like this would be higher on people wish-list, especially for a product licensed per switchport. Crazy. To my mind the three boxes would represent three separate classes.
enabled and up
enabled and down
I guess I'll make due with what I've got.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.