Welcome, Guest. Please login or register.

Author Topic: Cisco EoL information upload  (Read 2441 times)

ghermant

  • Newbie
  • *
  • Posts: 20
    • View Profile
Cisco EoL information upload
« 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

ascii

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: Cisco EoL information upload
« Reply #1 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 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");

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2901
    • View Profile
    • NeDi
Re: Cisco EoL information upload
« Reply #2 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...

Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

sjobergh

  • Newbie
  • *
  • Posts: 45
    • View Profile
Re: Cisco EoL information upload
« Reply #3 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

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2901
    • View Profile
    • NeDi
Re: Cisco EoL information upload
« Reply #4 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...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo