Skip to content
Sign in

MDM template

File Upload

Use the MDM template to process Microsoft data from any source.

Use this template when your tool isn’t supported directly, to load software and hardware data pertaining to Microsoft analysis. Download the template from its data source: open Datasources, click MDM - Template, then click Download Template. Download a fresh copy each time, as templates are updated.

For a complete analysis, also give Infrastructure Mapper your virtual relationships, from at least one of these data sources:

  • RVTools
  • VMware PowerCLI
  • IFMP - Template

See all data sources here

The sheet is split in to two sections, the top half shows which columns are required, with information surrounding the contents to be filled in said columns.

MDM template header rows for device_name, software_publisher, software_name and version, with required and optional flags

In this example “software_publisher” is a required field and should be filled with a value listed beneath it, e.g. Microsoft

Next we have the section that requires completion, where all lines beneath “DATA LINES TO BE IMPORTED” will be imported.

The MDM template DATA LINES TO BE IMPORTED section, with example Microsoft rows for SQL Server, Project Server, Exchange, Office and Teams

When completing the template make sure to remove the example data provided in the grey section.

Make sure to save your changes.

The MDM file upload is Datasources, then MDM - Template.

  1. Click Download Template if you do not already have a current copy. Reset data clears what this source has already taken in.
  2. Drag the file into Drag & drop files & folders here, or click Upload. The accepted types are .xls, .xlsx, .xlsm and .xlsb.
  3. Check Runs, Files Uploaded, Validation Errors and Processing Errors on the same page. Upload history is also on Upload history.

MDM - Template on Datasources, with Reset data, Download Template, Drag & drop files & folders here, Upload, the .xls .xlsx .xlsm and .xlsb chips, and Runs, Files Uploaded, Validation Errors and Processing Errors