Table of contents
The NOC team required an export of data for their OSS systems. This data needed to be included in a series of Excel Spreadsheets which were loaded by an ETL for upload into the OSS.
The code for this solution is included in the NMIS9 contrib folder which is available in the installation or from NMIS9@GitHub, it will be in the folder nmis9/contrib/noc_inventory_export
A good option to install is to create a util folder e.g. /usr/local/nmis9/util and then create a symbolic link so the file will run with the correct paths.
Some handy commands (sudo might be required):
sudo mkdir /usr/local/nmis9/util
sudo ln -s /usr/local/nmis9/contrib/noc_inventory_export/oss_export_cisco.pl /usr/local/nmis9/util/oss_export_cisco.pl
sudo ln -s /usr/local/nmis9/contrib/noc_inventory_export/oss_export_mpls.pl /usr/local/nmis9/util/oss_export_mpls.pl
sudo /usr/local/nmis9/bin/nmis-cli act=fixperms
To run it on a single node, check the embedded help.
oss_export_cisco.pl - 2.0.0
oss_export_cisco.pl - Exports nodes and ports from NMIS into an Excel spredsheet.
oss_export_cisco.pl [options...] dir=<directory> [option=value] ...
The oss_export_cisco.pl program Exports NMIS nodes into an Excel spreadsheet in
the specified directory with the required 'dir' parameter. The command
also creates Comma Separated Value (CSV) files in the same directory.
If the '--interfaces' option is specified, Interfaces will be
exported as well. They are not included by default because there may
thousands of them on some devices.
--debug=[1-9] - global option to print detailed messages
--help - display command line usage
--interfaces - include interfaces in the export
--usage - display a brief overview of command syntax
--version - print a version message and exit
dir=<directory> - The directory where the files should be stored.
Both the Excel spreadsheet and the CSV files
will be stored in this directory. The
directory should exist and be writable.
[conf=<filename>] - The location of an alternate configuration file.
- Set the debug level.
[separator=<character>] - A character to be used as the separator in the
CSV files. The words 'comma' and 'tab' are
understood. Other characters will be taken
literally. (default: 'tab')
[xls=<filename>] - The name of the XLS file to be created in the
directory specified using the 'dir' parameter'.
The following exit values are returned:
oss_export_cisco.pl dir=/tmp separator=comma