On SCCM 2012 v2, the Publisher field on the cmdb_sam_sw_install table is empty when source contains (R),®,™,(TM),Incorporate, Inc. suffixes.

The transformation map "Incremental Import (SAM enabled) 2012 v2" contains the field mapping:
source.[script] = target.publisher [answer = SCCMHelper.mungeVendor(source.u_publisher)];

However, because source.u_publisher is an object and not a string, the string operation can not be applied.


Steps to Reproduce

  1. Install the Integration - Microsoft SCCM 2012 v2 plugin

    (Ref.: Activate a plugin)

  2. Install the Software Asset Management plugin

  3. Import the csv attached in "imp_sccm2012v2_software":

  4. Execute the following script (similar to the transformation field mapping):

    --background script-----
    var source = new GlideRecord ('imp_sccm2012v2_software'), answer;
    source.get ('ResourceID','REID');

    answer = SCCMHelper.mungeVendor(source.u_publisher);
    gs.print (answer);
    --background script-----

    Notice the answer is not "PUBL ...", but instead:

    [0:00:00.003] Script completed in scope global: script
    *** Script:  (empty)



This problem is fixed in Kingston. To resolve the issue in earlier instances:

- Open the transformation map "Incremental Import (SAM enabled) 2012 v2"

- Select the following field mapping:

source.[script] = target.publisher

- Replace the source script with:

answer = SCCMHelper.mungeVendor(source.u_publisher.toString())


tranformation map script to fix

tranformation map script to fix

Related Problem: PRB753735

Seen In

Helsinki Patch 2 Hot Fix 2

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:34:35