NeDi Community

NeDi Software Specific => Discovery => Topic started by: ghermant on June 22, 2020, 12:24:25 PM

Title: Cisco EoL information upload
Post by: ghermant on June 22, 2020, 12:24:25 PM
Hello,
It is mentioned in the NeDi Guide that it is possible to upload the Cisco EoL date and information (ciscoeol.tgz) in NeDi.

Do you know how to use it and what is the format?

Thanks
Title: Re: Cisco EoL information upload
Post by: ascii on June 25, 2020, 06:51:55 AM
well i haven't testet it. NeDi is not our asset tool :(

in the Guide it is listed. https://www.nedi.ch/pub/The NeDi Guide.pdf (https://www.nedi.ch/pub/The NeDi Guide.pdf) Page 20
Quote
If you use System-Files with "update-replace config" and select "ciscoeol.tgz", it'll essentially unpack a file called
"ciscoeol.csv" in the nedi root folder. If nedi.pl is called with -Y options, all device types and module models are compared
against that file for EoL information, which will be added to the asset record.

If i screen to the code:
Code: [Select]
/var/nedi/html/languages/english/gen-Assets.html:               A file called ciscoeol.tgz can be uploaded with <a href="#System-Files">System-Files</a>.
/var/nedi/html/languages/english/gen-MAssets.html:              A file called ciscoeol.tgz can be uploaded with System-Files.
/var/nedi/html/languages/deutsch/gen-MAssets.html:              Das Archiv ciscoeol.tgz kann auf der Seite System-Files hochgeladen werden.
/var/nedi/inc/libmisc.pm: E.g. Cisco products are read from ciscoeol.csv (in the nedi directory):
/var/nedi/inc/libmisc.pm:       if($_[0] eq 'Cisco' and -e "$main::p/ciscoeol.csv"){
/var/nedi/inc/libmisc.pm:               my @l = `egrep -hi '^$_[1](\/K9)?;' $main::p/ciscoeol.csv`;
/var/nedi/inc/libmisc.pm:                       Prt("CHKP:".scalar @l." matches found with $_[1] in ciscoeol.csv\n");
Title: Re: Cisco EoL information upload
Post by: rickli on July 01, 2020, 08:27:44 AM
I've provided the ciscoeol file to my customers, but it hasn't been updated in a while. Here's an excerpt to show the format:

WS-C1924F-EN;1059256800;1161468000;1185400800;STD1014756;;
WS-C2924C-XL-EN-5P;1007161200;0;1162335600;STD1014826;WS-C2960-24PC-L;
WS-C2960S-24TSS-WS;0;1575154800;1606690800;STD1024601;WS-C2960X-24TS-LL;
WS-C3020;1041289200;1104534000;1136070000;STD1013152;;
WS-C3524-XL-EN-5P;1136847600;1239314400;1262991600;STD1011384;;
WS-C3550-24SMF;1402264800;1402264800;1404079200;STD1023614;;
WS-C3560CPD-8TT-L;1402264800;1402264800;1404079200;STD1023614;;
WS-C3560G-48PS-S;1391036400;1493503200;1517353200;STD1020723;WS-C3560X-48P-S;
WS-C3750V2-24TS-E;1494712800;1597183200;1622412000;STD1025151;WS-C3650-24TS-E;
WS-C3750X-24P-S;1509318000;1611788400;1635631200;STD1024997;WS-C3850-24P-S;
WS-C3750X-24T-IND;1509318000;1611529200;1635631200;STD1025706;;

Unfortunately I haven't found a better alternative yet and nothing similar for other vendors either...

Title: Re: Cisco EoL information upload
Post by: sjobergh on July 04, 2020, 01:18:29 AM
Could you give me a explanation of the format/fields
We have API connection to Cisco and I can instruct my programmers to develop a script that download this info every week or month and then publish it here

WS-C2960S-24TSS-WS   0   1575154800   1606690800     STD1024601      WS-C2960X-24TS-LL
               
Not a partnr                 ?   some kind of date   some kind of date   ?   Partnr
Title: Re: Cisco EoL information upload
Post by: rickli on July 07, 2020, 09:29:02 AM
Hi, that would be excellent! But then I'd recomment not even looking at this EoL file, but rather write all data (including maintenance) to your CSV file. It can have the same column order as of the inventory table, or the one you see when clicking on the context help in Assets-Management.

You or your developer can of course email me for direct assistance...