How to use a template for MDM

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.