...
We have some options that you can set by directly editing the script. They are below.
name | default value | what it does |
---|---|---|
conf_file | /usr/local/omk/conf/opCommon.nmis | The full path to the Opmantek configuration file. Used to retrieve the UUID. |
debug | 0 | 0 - Summary output only 1 - Commands run 2 - Command outputs (usually file contents). |
filename | cisco.csv | The filename to be imported. If it's not in the default directory, the full path including name is OK to use. |
last_date_of_support | 2019-01-01 | The date in YYY-MM-DD format. Devices with a column value for 'Last Date of Support' that's older than this date will not be imported. |
user | admin | The name of the Open-AudIT user performing the action. Admin is the default user and fine to use. |
Errors and Warnings (oh my!)
...
Below are the columns from our current Cisco spreadsheet. If your order of these columns differs, it shouldn't matter, however your spreadsheet should contain all the columns used in the mappings below.
Serial Number / PAK number | Coverage | Covered Line Status | Business Entity | Sub Business Entity | Product Family | Product ID | Product Description | Asset Type | Product Type | Item Quantity | Covered Line Start Date | Covered Line End Date | Covered Line End Date FY-FQ | Contract Type | Service Brand Code | Contract Number | Subscription Reference ID | Ship Date | End of Product Sale Date | End of Software Maintenance Date | Last Date of Support | LDOS FY-FQ | End Of Life Product Bulletin | Warranty Type | Warranty End Date | Install Site Customer Registry GU Name | Install Site Customer Registry Party Name | Install Site Customer Registry Party ID | Install Site Name | Install Site ID | Install Site Address 1 | Install Site City | Install Site State | Install Site Country | Install Site Postal Code | Product Bill to ID | Product Bill-to Partner Name | Product Partner BE GEO ID | POS Partner BE GEO ID | POS Partner BE GEO Name | Service Bill to ID | Service Bill-to Partner Name | Service Partner BE GEO ID | Product List Price $ | Default Service List Price $ | Default Service Level | Existing Coverage Level List Price $ | Instance ID | Parent Instance ID | Product SO | Product PO | Service SO | Service PO | Web Order ID | Mapped to SWSS (Y/N) | Mapped to C1 (Y/N) | Auto-renewal flag | Configuration |
Mapping the spreadsheet to Open-AudIT
Below are the mappings between the spreadsheet columns and those in Open-AudIT.
Cisco Spreadsheet | Open-AudIT |
---|---|
Product Family | asset_tag |
Product Description | description |
Last Date of Support | end_of_life |
End of Product Sale Date | end_of_production (new, see below) |
Covered Line End Date | end_of_service |
Serial Number / PAK number | hostname |
End of Software Maintenance Date | maintenance_expires (new, see below) |
Product ID | model |
Install Site Customer Registry GU Name | owner |
Product List Price $ | purchase_amount |
Covered Line Start Date | purchase_date |
Contract Number | purchase_service_contract_number |
Product Bill-to Partner Name | purchase_vendor |
Serial Number / PAK number | serial |
Warranty End Date | warranty_expires |
Covered Line Status | warranty_status (new, see below) |
In addition to the above we set a few other fields as below.
Field | Set to | ||
---|---|---|---|
last_seen_by | nmap - so we can override this by discovery, audit or the GUI. | ||
location_id | Calculated by inserting any missing Locations as below, then associating to the device. | ||
org_id | 1 - the default Org. | ||
type | By default, set to 'network device'. If one of the below matches, set.
|
We also import the list of Locations mapping the fields as below. If already present, we leave the Location as is. We test for this using the spreadsheet value for Install Site ID.
Cisco Spreadsheet | Open-AudIT |
---|---|
Install Site Address 1 | address |
Install Site City | city |
Install Site Country | country |
Install Site ID | external_ident |
Install Site Name | name |
1 (the default Org) | org_id |
Install Site Postal Code | postcode |
Install Site State | state |