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
Install the Integration - Microsoft SCCM 2012 v2 plugin
(Ref.: Activate a plugin)
Install the Software Asset Management plugin
Import the csv attached in "imp_sccm2012v2_software":
Execute the following script (similar to the transformation field mapping):
var source = new GlideRecord ('imp_sccm2012v2_software'), answer;
answer = SCCMHelper.mungeVendor(source.u_publisher);
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())
Related Problem: PRB753735