Send netdisco-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/netdisco-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of netdisco-users digest..."
Today's Topics:
1. Re: Report for Cisco Catalyst 3K Advisory
([email protected])
2. Re: Report for Cisco Catalyst 3K Advisory (Zachary McGibbon)
3. Re: Report for Cisco Catalyst 3K Advisory (Mark Boolootian)
--- Begin Message ---
Hi,
> This said, it would be nice to have a page somewhere on the netdisco site
> where users could contribute custom reports like this.
agreed, +1 for this - there are a lot of field notices out there - and such
a device report is one of the power features of some of the commercial tools
out there
alan
--- End Message ---
--- Begin Message ---
Thanks Mark, helps out!
I then added this at the end, see the most vulnerable at the top
order by d_uptime desc,device.name,pos
BTW, we have had 4 switches fail on us in the past week with this issue!
- Zachary
On Tue, Mar 1, 2016 at 12:56 PM, Mark Boolootian <[email protected]> wrote:
> One of the guys here (John Haskins) made a slight modification that
> might be useful to others - it provides the uptime of the device in
> question.
> Many thanks to Zachary for cobbling this together and sharing.
>
> ---
>
> - tag: cisco_fn_63744_63745
> label: 'Cisco Field Notice 63744 and 63745'
> columns:
> - {name: 'Name'}
> - {ip: 'IP'}
> - {pos: 'Switch Number'}
> - {model: 'Model'}
> - {serial: 'Serial'}
> - {hw_ver: 'HW Ver'}
> - {fw_ver: 'Firmware'}
> - {d_uptime: 'Uptime'}
> - {last_discover: 'Last Discover'}
> query: |
> select distinct
> device.name,
> device.ip,
> device_module.pos + 1 as pos,
> device_module.model,
> device_module.serial,
> device_module.hw_ver,
> device_module.fw_ver,
> age(CURRENT_DATE,
> CURRENT_DATE-((device.uptime/100::bigint)::text)::interval) as
> d_uptime,
> device_module.last_discover
> from device
> inner join device_module
> on device.ip=device_module.ip
> where
> device_module.last_discover >= CURRENT_DATE
> and device_module.model like 'WS-C2350-48TD-S'
> or device_module.model like 'WS-C2350-48TD-SD'
> or device_module.model like 'WS-C2918-24TC-C'
> or device_module.model like 'WS-C2918-24TT-C'
> or device_module.model like 'WS-C2918-48TC-C'
> or device_module.model like 'WS-C2918-48TT-C'
> or device_module.model like 'WS-C2960-24-S'
> or device_module.model like 'WS-C2960-24LC-S'
> or device_module.model like 'WS-C2960-24LT-L'
> or device_module.model like 'WS-C2960-24PC-L'
> or device_module.model like 'WS-C2960-24PC-S'
> or device_module.model like 'WS-C2960-24TC-L'
> or device_module.model like 'WS-C2960-24TC-S'
> or device_module.model like 'WS-C2960-24TT-L'
> or device_module.model like 'WS-C2960-48PST-L'
> or device_module.model like 'WS-C2960-48PST-S'
> or device_module.model like 'WS-C2960-48TC-L'
> or device_module.model like 'WS-C2960-48TC-S'
> or device_module.model like 'WS-C2960-48TT-L'
> or device_module.model like 'WS-C2960-48TT-S'
> or device_module.model like 'WS-C2960-8TC-L'
> or device_module.model like 'WS-C2960-8TC-S'
> or device_module.model like 'WS-C2960G-24TC-L'
> or device_module.model like 'WS-C2960G-48TC-L'
> or device_module.model like 'WS-C2960G-8TC-L'
> or device_module.model like 'WS-C2975GS-48PS-L'
> or device_module.model like 'WS-C2960PD-8TT-L'
> or device_module.model like 'WS-C3560V2-24TS-E'
> or device_module.model like 'WS-C3560V2-24TS-S'
> or device_module.model like 'WS-C3560V2-24TS-SD'
> or device_module.model like 'WS-C3560V2-48TS-E'
> or device_module.model like 'WS-C3560V2-48TS-S'
> or device_module.model like 'WS-C3560V2-24PS-E'
> or device_module.model like 'WS-C3560V2-24PS-S'
> or device_module.model like 'WS-C3560V2-48PS-E'
> or device_module.model like 'WS-C3560V2-48PS-S'
> or device_module.model like 'WS-C3560-24PS-E'
> or device_module.model like 'WS-C3560-24PS-S'
> or device_module.model like 'WS-C3560-24TS-E'
> or device_module.model like 'WS-C3560-24TS-S'
> or device_module.model like 'WS-C3560-48PS-E'
> or device_module.model like 'WS-C3560-48PS-S'
> or device_module.model like 'WS-C3560-48TS-E'
> or device_module.model like 'WS-C3560-48TS-S'
> or device_module.model like 'WS-C3560G-24PS-E'
> or device_module.model like 'WS-C3560G-24PS-S'
> or device_module.model like 'WS-C3560G-24TS-E'
> or device_module.model like 'WS-C3560G-24TS-S'
> or device_module.model like 'WS-C3560G-48PS-E'
> or device_module.model like 'WS-C3560G-48PS-S'
> or device_module.model like 'WS-C3560G-48TS-E'
> or device_module.model like 'WS-C3560G-48TS-S'
> or device_module.model like 'WS-C3560-12PC-S'
> or device_module.model like 'WS-C3560-8PC-S'
> or device_module.model like 'WS-C3560E-12D-E'
> or device_module.model like 'WS-C3560E-12D-S'
> or device_module.model like 'WS-C3560E-12SD-E'
> or device_module.model like 'WS-C3560E-12SD-S'
> or device_module.model like 'WS-C3560E-24PD-E'
> or device_module.model like 'WS-C3560E-24PD-S'
> or device_module.model like 'WS-C3560E-24TD-E'
> or device_module.model like 'WS-C3560E-24TD-S'
> or device_module.model like 'WS-C3560E-24TD-SD'
> or device_module.model like 'WS-C3560E-48PD-E'
> or device_module.model like 'WS-C3560E-48PD-EF'
> or device_module.model like 'WS-C3560E-48PD-S'
> or device_module.model like 'WS-C3560E-48PD-SF'
> or device_module.model like 'WS-C3560E-48TD-E'
> or device_module.model like 'WS-C3560E-48TD-S'
> or device_module.model like 'WS-C3560E-48TD-SD'
> or device_module.model like 'WS-C3560X-48PF-S'
> or device_module.model like 'WS-C3750V2-24TS-E'
> or device_module.model like 'WS-C3750V2-24TS-S'
> or device_module.model like 'WS-C3750V2-48TS-E'
> or device_module.model like 'WS-C3750V2-48TS-S'
> or device_module.model like 'WS-C3750V2-24PS-E'
> or device_module.model like 'WS-C3750V2-24PS-S'
> or device_module.model like 'WS-C3750V2-48PS-E'
> or device_module.model like 'WS-C3750V2-48PS-S'
> or device_module.model like 'WS-C3750-24FS-S'
> or device_module.model like 'WS-C3750-24PS-E'
> or device_module.model like 'WS-C3750-24PS-S'
> or device_module.model like 'WS-C3750-24TS-E'
> or device_module.model like 'WS-C3750-24TS-S'
> or device_module.model like 'WS-C3750-48PS-E'
> or device_module.model like 'WS-C3750-48PS-S'
> or device_module.model like 'WS-C3750-48TS-E'
> or device_module.model like 'WS-C3750-48TS-S'
> or device_module.model like 'WS-C3750G-12S-E'
> or device_module.model like 'WS-C3750G-12S-S'
> or device_module.model like 'WS-C3750G-12S-SD'
> or device_module.model like 'WS-C3750G-24PS-E'
> or device_module.model like 'WS-C3750G-24PS-S'
> or device_module.model like 'WS-C3750G-24T-E'
> or device_module.model like 'WS-C3750G-24T-S'
> or device_module.model like 'WS-C3750G-24TS-E1U'
> or device_module.model like 'WS-C3750G-24TS-S1U'
> or device_module.model like 'WS-C3750G-48PS-E'
> or device_module.model like 'WS-C3750G-48PS-S'
> or device_module.model like 'WS-C3750G-48TS-E'
> or device_module.model like 'WS-C3750G-48TS-S'
> or device_module.model like 'WS-C3750E-24PD-E'
> or device_module.model like 'WS-C3750E-24PD-S'
> or device_module.model like 'WS-C3750E-24TD-E'
> or device_module.model like 'WS-C3750E-24TD-S'
> or device_module.model like 'WS-C3750E-24TD-SD'
> or device_module.model like 'WS-C3750E-48PD-E'
> or device_module.model like 'WS-C3750E-48PD-EF'
> or device_module.model like 'WS-C3750E-48PD-S'
> or device_module.model like 'WS-C3750E-48PD-SF'
> or device_module.model like 'WS-C3750E-48TD-E'
> or device_module.model like 'WS-C3750E-48TD-S'
> or device_module.model like 'WS-C3750E-48TD-SD'
> order by device.name,pos
>
--- End Message ---
--- Begin Message ---
One of the guys here (John Haskins) made a slight modification that
might be useful to others - it provides the uptime of the device in question.
Many thanks to Zachary for cobbling this together and sharing.
---
- tag: cisco_fn_63744_63745
label: 'Cisco Field Notice 63744 and 63745'
columns:
- {name: 'Name'}
- {ip: 'IP'}
- {pos: 'Switch Number'}
- {model: 'Model'}
- {serial: 'Serial'}
- {hw_ver: 'HW Ver'}
- {fw_ver: 'Firmware'}
- {d_uptime: 'Uptime'}
- {last_discover: 'Last Discover'}
query: |
select distinct
device.name,
device.ip,
device_module.pos + 1 as pos,
device_module.model,
device_module.serial,
device_module.hw_ver,
device_module.fw_ver,
age(CURRENT_DATE,
CURRENT_DATE-((device.uptime/100::bigint)::text)::interval) as
d_uptime,
device_module.last_discover
from device
inner join device_module
on device.ip=device_module.ip
where
device_module.last_discover >= CURRENT_DATE
and device_module.model like 'WS-C2350-48TD-S'
or device_module.model like 'WS-C2350-48TD-SD'
or device_module.model like 'WS-C2918-24TC-C'
or device_module.model like 'WS-C2918-24TT-C'
or device_module.model like 'WS-C2918-48TC-C'
or device_module.model like 'WS-C2918-48TT-C'
or device_module.model like 'WS-C2960-24-S'
or device_module.model like 'WS-C2960-24LC-S'
or device_module.model like 'WS-C2960-24LT-L'
or device_module.model like 'WS-C2960-24PC-L'
or device_module.model like 'WS-C2960-24PC-S'
or device_module.model like 'WS-C2960-24TC-L'
or device_module.model like 'WS-C2960-24TC-S'
or device_module.model like 'WS-C2960-24TT-L'
or device_module.model like 'WS-C2960-48PST-L'
or device_module.model like 'WS-C2960-48PST-S'
or device_module.model like 'WS-C2960-48TC-L'
or device_module.model like 'WS-C2960-48TC-S'
or device_module.model like 'WS-C2960-48TT-L'
or device_module.model like 'WS-C2960-48TT-S'
or device_module.model like 'WS-C2960-8TC-L'
or device_module.model like 'WS-C2960-8TC-S'
or device_module.model like 'WS-C2960G-24TC-L'
or device_module.model like 'WS-C2960G-48TC-L'
or device_module.model like 'WS-C2960G-8TC-L'
or device_module.model like 'WS-C2975GS-48PS-L'
or device_module.model like 'WS-C2960PD-8TT-L'
or device_module.model like 'WS-C3560V2-24TS-E'
or device_module.model like 'WS-C3560V2-24TS-S'
or device_module.model like 'WS-C3560V2-24TS-SD'
or device_module.model like 'WS-C3560V2-48TS-E'
or device_module.model like 'WS-C3560V2-48TS-S'
or device_module.model like 'WS-C3560V2-24PS-E'
or device_module.model like 'WS-C3560V2-24PS-S'
or device_module.model like 'WS-C3560V2-48PS-E'
or device_module.model like 'WS-C3560V2-48PS-S'
or device_module.model like 'WS-C3560-24PS-E'
or device_module.model like 'WS-C3560-24PS-S'
or device_module.model like 'WS-C3560-24TS-E'
or device_module.model like 'WS-C3560-24TS-S'
or device_module.model like 'WS-C3560-48PS-E'
or device_module.model like 'WS-C3560-48PS-S'
or device_module.model like 'WS-C3560-48TS-E'
or device_module.model like 'WS-C3560-48TS-S'
or device_module.model like 'WS-C3560G-24PS-E'
or device_module.model like 'WS-C3560G-24PS-S'
or device_module.model like 'WS-C3560G-24TS-E'
or device_module.model like 'WS-C3560G-24TS-S'
or device_module.model like 'WS-C3560G-48PS-E'
or device_module.model like 'WS-C3560G-48PS-S'
or device_module.model like 'WS-C3560G-48TS-E'
or device_module.model like 'WS-C3560G-48TS-S'
or device_module.model like 'WS-C3560-12PC-S'
or device_module.model like 'WS-C3560-8PC-S'
or device_module.model like 'WS-C3560E-12D-E'
or device_module.model like 'WS-C3560E-12D-S'
or device_module.model like 'WS-C3560E-12SD-E'
or device_module.model like 'WS-C3560E-12SD-S'
or device_module.model like 'WS-C3560E-24PD-E'
or device_module.model like 'WS-C3560E-24PD-S'
or device_module.model like 'WS-C3560E-24TD-E'
or device_module.model like 'WS-C3560E-24TD-S'
or device_module.model like 'WS-C3560E-24TD-SD'
or device_module.model like 'WS-C3560E-48PD-E'
or device_module.model like 'WS-C3560E-48PD-EF'
or device_module.model like 'WS-C3560E-48PD-S'
or device_module.model like 'WS-C3560E-48PD-SF'
or device_module.model like 'WS-C3560E-48TD-E'
or device_module.model like 'WS-C3560E-48TD-S'
or device_module.model like 'WS-C3560E-48TD-SD'
or device_module.model like 'WS-C3560X-48PF-S'
or device_module.model like 'WS-C3750V2-24TS-E'
or device_module.model like 'WS-C3750V2-24TS-S'
or device_module.model like 'WS-C3750V2-48TS-E'
or device_module.model like 'WS-C3750V2-48TS-S'
or device_module.model like 'WS-C3750V2-24PS-E'
or device_module.model like 'WS-C3750V2-24PS-S'
or device_module.model like 'WS-C3750V2-48PS-E'
or device_module.model like 'WS-C3750V2-48PS-S'
or device_module.model like 'WS-C3750-24FS-S'
or device_module.model like 'WS-C3750-24PS-E'
or device_module.model like 'WS-C3750-24PS-S'
or device_module.model like 'WS-C3750-24TS-E'
or device_module.model like 'WS-C3750-24TS-S'
or device_module.model like 'WS-C3750-48PS-E'
or device_module.model like 'WS-C3750-48PS-S'
or device_module.model like 'WS-C3750-48TS-E'
or device_module.model like 'WS-C3750-48TS-S'
or device_module.model like 'WS-C3750G-12S-E'
or device_module.model like 'WS-C3750G-12S-S'
or device_module.model like 'WS-C3750G-12S-SD'
or device_module.model like 'WS-C3750G-24PS-E'
or device_module.model like 'WS-C3750G-24PS-S'
or device_module.model like 'WS-C3750G-24T-E'
or device_module.model like 'WS-C3750G-24T-S'
or device_module.model like 'WS-C3750G-24TS-E1U'
or device_module.model like 'WS-C3750G-24TS-S1U'
or device_module.model like 'WS-C3750G-48PS-E'
or device_module.model like 'WS-C3750G-48PS-S'
or device_module.model like 'WS-C3750G-48TS-E'
or device_module.model like 'WS-C3750G-48TS-S'
or device_module.model like 'WS-C3750E-24PD-E'
or device_module.model like 'WS-C3750E-24PD-S'
or device_module.model like 'WS-C3750E-24TD-E'
or device_module.model like 'WS-C3750E-24TD-S'
or device_module.model like 'WS-C3750E-24TD-SD'
or device_module.model like 'WS-C3750E-48PD-E'
or device_module.model like 'WS-C3750E-48PD-EF'
or device_module.model like 'WS-C3750E-48PD-S'
or device_module.model like 'WS-C3750E-48PD-SF'
or device_module.model like 'WS-C3750E-48TD-E'
or device_module.model like 'WS-C3750E-48TD-S'
or device_module.model like 'WS-C3750E-48TD-SD'
order by device.name,pos
--- End Message ---
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Netdisco mailing list - Digest Mode
[email protected]
https://lists.sourceforge.net/lists/listinfo/netdisco-users
