ecscmdb 1.6.20

Dump the OpenManage database.

-- coding: utf-8 --

Do NOT edit this system file by hand -- use git.

See "URL to git source" below.

Author: $Id: Thomas R. Stevenson [e-mail] $

Last Changed: $Date: Wed Feb 8 18:31:56 2023 -0500 $

URL to git source: $URL: [e-mail]:ECS_Projects/ECScmdb.git $

cmdb

cmdb: Download the devices in the OpenManage database into a spreadsheet, one work sheet for each device.

cmdbdiff: Compare two cmdb spreadsheets for differences.

Installation

Use Python virtual environment and install package ecscmdb.

Version

cmdb --version

cmdb: ecscmdb(1.6.20), ecspylibs(1.1.14)

cmdbdiff --version

cmdbdiff: ecscmdb(1.6.20), ecspylibs(1.1.14)

Help

cmdb --help

Program to download the data from the OpenManage DB and build a spreadsheet.

Some default option values listed below can be overridden within the configuration file.

Usage: cmdb [-v] [-L LEVEL] [--LOG=DIR] [-F] [-c CONFIG] [-s SECTION] [-o OUTPUT] [-p PWFILE] [-D] [-P SIZE] cmdb [-vl] [-L LEVEL] [--LOG=DIR] [-c CONFIG] [-s SECTION] [-a ID]... [-d ID]... [-p PWFILE] [-D] cmdb (-h | --help | -V | --version)

There are no required options.

Options: -h, --help Show this help message and exit. -V, --version Show version information and exit. -F, --full Show all data, no filtering. -c CONFIG, --config=CONFIG The configuration file. Default: "/home/tom/Run/ECScmdb/Testing/etc/ecscmdb/cmdb.yml" -s SECTION, --section=SECTION The configuration file version (default defined within the configuration file). -o OUTPUT, --output=OUTPUT Output file or directory. Default: "/home/tom/Run/ECScmdb/Testing/output/OpenManage-cmdb.2023-02-08-18-14-30.xlsx" -p PWFILE, --pw=PWFILE The password file. This file is used when a login to a website or webpage is required. Default: "/home/tom/Run/ECScmdb/Testing/etc/ecscmdb/cmdb.pw" -l, --list List all of the IDs in the password file and exit. If both the --list and --verbose options are included, list both IDs and Passwords and exit. -a ID, --add=ID Add (or update) an ID and Password and exit. Program will prompt for the Password to be saved to the password file. -d ID, --delete=ID Delete an ID (if it exists) from the password file and exit. -v, --verbose Print verbose messages. -L LEVEL, --log=LEVEL Print log messages at log value LEVEL. Valid levels are: TRACE, DEBUG, INFO, WARNING, ERROR, and CRITICAL. Default: WARNING --LOG=DIR Log directory. Default: "/home/tom/Run/ECScmdb/Testing/log/cmdb.log" -D, --dryrun Only print out what would be done. -P SIZE, --poolsize=SIZE Call OpenManage using pools of size SIZE. Default: set by the OS.

cmdbdiff --help

Program to analyze two spreadsheets for differences.

Some default option values listed below can be overridden within the initialization file.

Usage: cmdbdiff [-v] [-L LEVEL] [--LOG=DIR] [-c CONFIG] [-s SECTION] [-r REPORT] [-D] SPREADSHEET1 SPREADSHEET2 cmdbdiff (-h | --help | -V | --version)

Variables SPREADSHEET1 and SPREADSHEET2 are required, all other parameters are optional.

Options: -h, --help Show this help message and exit. -V, --version Show version information and exit. -c CONFIG, --config=CONFIG The configuration file. Default: "/home/tom/Run/ECScmdb/Testing/etc/ecscmdb/cmdbdiff.yml" -s SECTION, --section=SECTION The configuration file version (default defined within the configuration file). -r REPORT, --report=REPORT Report directory or file. -v, --verbose Print verbose messages. -L LEVEL, --log=LEVEL Print log messages at log value LEVEL. Valid levels are: TRACE, DEBUG, INFO, WARNING, ERROR, and CRITICAL. Default: "WARNING" --LOG=DIR Log Directory, Default: "/home/tom/Run/ECScmdb/Testing/log/cmdbdiff.log" -D, --dryrun Only print out what would be done.

The GIT Home can be found Here. The README file can be found Here. The LICENSE file can be found Here. The ChangeLog file can be found Here. The pyproject.toml file can be found Here. My contact information can be found Here.