If your data has been exported from a different tool and/or is in an incompatible format, you may create a CSv template.
You’ll need to create 3 CSV files using this naming convention:
- “sccm_software_inventory” for the software inventory query;
- “sccm_installed_software” for the installed software query;
- “sccm_hardware_inventory” for the hardware query;
These CSV files need to contain the following data attributes keeping to the format described in the sections below.
ℹ Info - device_key is a unique identifier for a given device (virtual or physical). - software_key is a unique identifier for a given software product or product component. - these keys are required for mapping the installed software on each device. |
Hardware Inventory
The discovery output should contain as a minimum the following column headers (in this order):
device_key,
device_name,
os,
device_manufacturer,
device_model,
asset_tag,
number_of_processors,
serial_number,
processor_manufacturer,processor_model,
domain,
number_of_cores,
ht_capable,
ht_enabled,
platform,
virtual_flag
Some columns may be empty but keeping this format is required for the validation template. As a minimum, the following columns should be populated device_key, device_name, os. For best results, the more data the better.
Software Inventory
The output should contain as a minimum the following column headers (in this order):
software_key,
software_publisher,
software_name,
version
Some columns may be empty but keeping this format is required for the validation template. As a minimum, the following columns should be populated software_key and software_name. For best results, the more data the better.
Installed Software
The output should contain as a minimum the following column headers (in this order):
device_key,
software_key
Both columns are mandatory and must contain data.
If you have issues processing the data please contact your account representative.