Table of contents

Summary

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.

Requirement

TODO

Solution

TODO

Installation

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

Run it

To run it on a single node, check the embedded help.

                       oss_export_cisco.pl - 2.0.0


NAME
       oss_export_cisco.pl -  Exports nodes and ports from NMIS into an Excel spredsheet.

SYNOPSIS
       oss_export_cisco.pl [options...] dir=<directory> [option=value] ...

DESCRIPTION
       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.

OPTIONS
 --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

ARGUMENTS
     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.
                                (default: '/usr/local/nmis9/util/../conf')
     [debug=<true|false|yes|no|info|warn|error|fatal|verbose|0-9>]
                             - 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'.
                                 (default: 'oss_export.xlsx')
                          
EXIT STATUS
     The following exit values are returned:
     0 Success
     215 Failure

EXAMPLE
   oss_export_cisco.pl dir=/tmp separator=comma