Inventory Utilities

[Quali-Community]

Inventory Utilities

The purpose of this utility is to assist in common inventory tasks related to CloudShell.
It is driven by a python script and an associated Excel file.

Repository	Latest Release	README.md
Name Inventory-Utilities Owner QualiSystemsLab Type Script Category Other Min. Compatible CloudShell Version 8.0	Link 1.0.0 (Version / Tag) TAR / ZIP 1.0.0 (TAR) 1.0.0 (ZIP) Author kalsky Published On 09/10/2018 07:42 PM	Inventory Utilities The purpose of this utility is to assist in common inventory tasks related to CloudShell. It is driven by a python script and an associated Excel file. The Excel file contains a number of tabs, each associate with a different function, along with an instructions tab, and a configuration tab. You must ensure that the settings tab on the Excel file is filled out and correct prior to running the script. The Excel file must reside in the same working folder as the script, and must be named 'Inventory.xlsx' Settings Tab There are a series of settings that need to be configured prior to running the script: cs_host: The server hostname or IP of the Quali CloudShell Server being used cs_username: CloudShell Username to login with. Any devices created will be attributed to this user cs_password: Password associated with the user cs_domain: CloudShell Domain to log into; must be a domain available to the user cs_port: CloudShell API port (Default is 8029, only change if installation is configured differently) logfilename: Name for the log file to be created (or appended to) for this operation. Log file is created in the local directory log level: Log Severity Level. DEBUG by default, will capture each step. Installation Download and extract the latest release In your command line, navigate to the folder and run the following to get the relevant requirements: 'pip install -r requirements.txt' Executing In your command line, navigate to the folder and run the python script: 'python inventory_utilities.py' You will be presented with 9 options, plus the option to exit: Create and Autoload Set Attributes Set Connections Bulk Load (1, 2, 3) Add Custom Attributes List Connections Generate Inventory List Generate User List Update User Options Create and Autoload The primary purpose of this function is to create a new, or update and existing, inventory item in CloudShell. The Create and Autoload option will use the '1-CreateAndAutoLoad' tab in the Excel file. The following columns are used in this tab: Ignore: if marked with 'Y' or 'y' will skip this row Update: if marked with 'Y' or 'y' this will cause an existing Resource to be update (vs. being created new) AutoLoad: if marked with 'Y' or 'y' will execute the Shell's Autoload function after creation Parent: if the item is a child resource (e.g. card or port), this is the name of the it's parent Name: Name of this device Resource Family: the name of the Resource Family this item is modeled upon Resource Model: the name of the Resource Model (a subset of Family) that this item is modeled upon Domains: Enter the name of the domain(s) to which this unit is suppose to belong - comma separated list Address: Address of this resource Folder Path: To which folder with in CloudShell (resource manager) the device should be placed when created Connection Type: CLI Connection Type: Auto, Console, SSH, Telnet User: Admin Username to use on the device Password: Password associated with the Username Enable Password: The OS Enable Password for the device Description: Device Description (if any) Driver Name: Name of the Driver to associate with this unit (for most shells there is only 1) SNMP Version: The SNMP Version the unit is configured for: v1, v2c, v3 SNMP Read String: The SNMP Community Read String Location: Location information on the device (Lab, rack/row, etc.) - for some Shells this cannot be manged by User (SNMP only), so it may generate and error during the run Enable SNMP: This is to set the 'Enable SNMP' flag on the device. During autoload if True (Y) then the system will atttempt to login and enable SNMP settings on the device. Default is N Under Power Mgmt: This is to set the 'Power Management' flag on the device. This signifies that you would like CloudShell to power manage this device or not. Default is N. Set Attributes The primary purpose of this function is to set attribute values associated with a device, attributes not associated with the autoload. This allows for the complete set of details to be set on the device when added to inventory. Can also be used to update large sets of attribute values, such as updating 'enable password'. The Set Attributes option will use the '2-SetAttributes' tab in the Excel file. The following columns are used in this tab: Ignore: if marked with 'Y' or 'y' will skip this row ResourceName: Name of the device being modified/updated AttributeName: Set the name of the Attribute you want to update in the column header Only need the basic name of the attribute, so for 2nd Gen Shells use 'Password' and not 'WECSwitchShell.Password' Repeat as many times as needed. If a resource does not have that attribute, leave blank. This will not add an attribute that does not exist already on the Shell - for that use the 'Add Attribute' option Set Connections The primary purpose of this function is to set the connection map on a devices' sub-resource (Ports). The Set Connections option will use the '3-SetConnections' tab in the Excel file. This allows for an easy way to set or update existing connections on a device. You should avoid putting in non-connectible device names into the Excel File. Ideally it should just be the connectable device names. The following columns are used in this tab: Ignore: if marked with 'Y' or 'y' will skip this row From: One side of the Connection To: The other side of the Connection Leave blank to remove an existing connection Bulk Load This function will automatically run the following options in order: Create and AutoLoad Set Attributes Set Connections This is designed to be an 'Easy Button' to preform the 3 major actions needed to completely load a new device into CloudShell. Add Custom Attributes The primary purpose of this function is to add new attributes to 2nd Gen Shells. Currently there are two ways to do this, either via API (as done here), or to modify the 'shell-definition.yaml' file. The Add Custom Attributes option will use the '0-AddCustomAttributes' tab in the Excel file. If any of these attributes are included used by the 'Set Attributes' option, this needs to be ran first. The following columns are used in this tab: Ignore: if marked with 'Y' or 'y' will skip this row ModelName: Name of the Shell Model (Shell Name) to which to add the new Attribute to AttributeName: The name for the Attribute being added. DefaultValue: If you want to include a default value, do so here List Connections The primary purpose of this function is to examine and capture all of a devices sub-modules (blades, ports, etc) and report what it's current connection is. The List Connections option will use the '4-ListConnections' tab in the Excel file. This function will generate (or overwrite) a file named current_connection.csv which will list out for each device the entire structure in the first column, and any mapped connections in the second. Ideal use would be to then copy & paste the child names needed into the 'SetConnections' tab. This ensures that all devices names are correct, and generally speeds the process. The following columns are used in this tab: Device Names: List the name of the device you wish to list all children for Generate Inventory List The primary purpose of this function is to provide a current list of all inventory in the system, organized by Family/Model. There is no tab in the spreadsheet used. This function will generate a .csv name 'inventory_report_YYYY_MM_DD_HH_MM.csv' The report contains the following column headers: Name Address Family Model Reserved (T/F) Domains Location Generate User List The primary purpose of this function is to provide a current list of all users in the system. There is no tab in the spreadsheet used. This function will generate a .csv name 'user_report_YYYY_MM_DD_HH_MM.csv' The report contains the following column headers: Name Email Admin (T/F) Active (T/F) Groups Update Users The primary purpose of this function is to allow basic user management in bulk. The focus here is changing user status (Active/Admin), what Groups they are assigned to (access to equipment), reservation limitations (duration and max concurrent ownership). Updating email is also allowed. The Update Users option will use the '5-UpdateUsers' tab in the Excel file. The following columns are used in this tab: Ignore: if marked with 'Y' or 'y' will skip this row Username: Name of the User to be modified Email: Email Address to be used - if '*' is used, then the user's email field will be made blank Is Active: if marked with 'N' or 'n' then the user will be made inactive Add to Groups: comma separated list of groups the user is to be assigned to Remove from Groups: comma separated list of groups the user is to be removed from Max Concurrent Reservations: the maximum number of reservations a user is allowed to own at once - Blank no changes Max Reservation Duration: the maximum duration, in hours, permitted for any reservation owned by this user
* Updated Weekly	* Update Now	* Repository, release and asset info is updated weekly. * Please allow 30-60 seconds for manual update changes to take effect.

---

 Yaniv Kalsky 09/10/2018 07:52 PM

·  3978  ·