What is the SCCM to HEAT field mapping used to import Software information via SCCM?

Version 1

    Details

    You need to import software and the mapping is not obvious or in the documentation - what are the SCCM fields and what are the corresponding HEAT fields?


    Resolution

    The mapping to use to import Software item information using SCCM is as follows:

     

    Source   (SCCM)

     
     

    Target   (HEAT)

     
     

    INSTALLED_SOFTWARE_DATA.InstanceKey

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.ID

     
     

    INSTALLED_SOFTWARE_DATA.ProductName00

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.DisplayName

     
     

    INSTALLED_SOFTWARE_DATA.Publisher00

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.Publisher

     
     

    INSTALLED_SOFTWARE_DATA.ProductVersion00

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.DisplayVersion

     
     

    INSTALLED_SOFTWARE_DATA.ProductCode00

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.Guid

     
     

    INSTALLED_SOFTWARE_DATA.InstalledLocation00

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.Path

     
     

    INSTALLED_SOFTWARE_DATA.UninstallString00

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.UninstallString

     
     

    INSTALLED_SOFTWARE_DATA.ProductID00

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.ProductKey

     
     

    INSTALLED_SOFTWARE_DATA.Language00

     
     

    Category.Component.Property-SoftwarePackages.SoftwarePackage.LanguageID