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 (Zachary McGibbon)
--- Begin Message ---
Here is the added field notice 63744 which adds some 2K switches
http://www.cisco.com/c/en/us/support/docs/field-notices/637/fn63744.html
- 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'}
- {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,
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
On Mon, Feb 29, 2016 at 3:17 PM, Zachary McGibbon <
[email protected]> wrote:
> We have a lot of Cisco switches on our network and we were just made aware
> of a sort of recall for some models of switches due to bad memory. I wrote
> a custom report and wanted to share it with everyone in case you want to
> use it.
>
> This said, it would be nice to have a page somewhere on the netdisco site
> where users could contribute custom reports like this.
>
> http://www.cisco.com/c/en/us/support/docs/field-notices/637/fn63745.html
>
> Add this in environments/deployment.yml
>
> reports:
> - tag: cisco_fn_63745
> label: 'Cisco Field Notice 63745'
> columns:
> - {name: 'Name'}
> - {ip: 'IP'}
> - {pos: 'Switch Number'}
> - {model: 'Model'}
> - {serial: 'Serial'}
> - {hw_ver: 'HW Ver'}
> - {fw_ver: 'Firmware'}
> - {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,
> 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-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
