Importing a bunch of monitor information

[nesbarut]

I took a physical inventory of the monitors we have in use here and would love to import then from a CSV file. I have the manufacturer, serial number (for most of them), and an asset tag. I created a Monitors Group and a Monitor Asset Type, in the CSV file what will the column names be for these ? Right now my CSV looks like the following:

name, type, manufacturer, serial_number, asset_tag

Am I using the correct column names? I see that there’s variations of some of the columns (b_asset_tag, b_manufacturer). Also, which column is used for the Group? I don’t see it in SQLite Manager. Thanks

[marcosjuliomendoza0181 (Marcos_Julio_)]

try the column Type for the group, Device_type for the column type group.

Design…

Table: DEVICES

fields:

id, name, type, description, server_name, domain, uuid, manufacturer, model, os_serial_number, windows_product_id, serial_number, ip_address, mac_address, operating_system, version, windows_user, primary_owner_name, memory, management_oid, up_time, last_boot_up_time, service_pack_major, _version, service_pack_minor_version, number_of_licensed_users, number_of_processors, processor_type, created_on,up,dated_on, kernel, page_count, install_date, device_type, current_user, bios_version, location, online_at, offline_at, asset_tag, manually_added, bios_date, c_purchase_price, c_purchase_date, b_name, b_location, b_device_type, b_asset_tag, b_manufacturer, b_model, b_primary_owner_name, b_serial_number, warning_alert_count, error_alert_count, open_ticket_count, a,uto_tag, dn, user_tag, exclude_tag, last_scan_time, spice_version, vpro_level, last_backup_time, user_id, user_primary, swid, product_categories, domain_role, b_description, site_id, reported_by_id, ip_comparable, scan_state, last_qrcode_time, md, m_service_id, product_info_id, processor_architecture, os_architecture, scan_preferences, raw_model, raw_manufacturer, raw_operating_system, raw_processor_type, port_scan_results, vm

[nesbarut]

@marcosjuliomendoza0181

try the column Type for the group, Device_type for the column type group.

Design…

Table: DEVICES

fields:

id, name, type, description, server_name, domain, uuid, manufacturer, model, os_serial_number, windows_product_id, serial_number, ip_address, mac_address, operating_system, version, windows_user, primary_owner_name, memory, management_oid, up_time, last_boot_up_time, service_pack_major, _version, service_pack_minor_version, number_of_licensed_users, number_of_processors, processor_type, created_on,up,dated_on, kernel, page_count, install_date, device_type, current_user, bios_version, location, online_at, offline_at, asset_tag, manually_added, bios_date, c_purchase_price, c_purchase_date, b_name, b_location, b_device_type, b_asset_tag, b_manufacturer, b_model, b_primary_owner_name, b_serial_number, warning_alert_count, error_alert_count, open_ticket_count, a,uto_tag, dn, user_tag, exclude_tag, last_scan_time, spice_version, vpro_level, last_backup_time, user_id, user_primary, swid, product_categories, domain_role, b_description, site_id, reported_by_id, ip_comparable, scan_state, last_qrcode_time, md, m_service_id, product_info_id, processor_architecture, os_architecture, scan_preferences, raw_model, raw_manufacturer, raw_operating_system, raw_processor_type, port_scan_results, vm

Thanks, when I am creating my CSV file do I need to include every single field of the device table or just the ones I will be populating?

[marcosjuliomendoza0181 (Marcos_Julio_)]

The only mandatory fields are: ID and NAME, the rest you can skip them or assign them to your convenience. Also, i think you must to set the field MANUALLY_ADDED to “t”, it has “f” by the default.