Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Transform Map on Database Instance Field Assigning Server CIs...

jlaps
Kilo Sage

Recently, our CMDB update forms started acting strangely; worked for years, but problems perhaps after recent upgrade. Anyways...

 

When our DBAs are creating/updating their CIs in the CMDB, for reasons unknown recently, the DATABASE INSTANCE reference field is not limiting to only database instances, and is allowing SERVER CIs to be selected during the transform. Transform map step is below-

jlaps_0-1762177398196.png

 

On the DATABASE CI itself, there are dictionary limits so only DB instances can be selected, but when the transform map is running, it is finding Server CIs with the same name and assigning those instead of instance CIs. Where do I need to look to fix this issue? Instead of field map as shown, use a script? Is there no way to just enforce the dictionary on that field?

 

5 REPLIES 5

Correct, the reference qualifier will only be respected when accessed via the UI, not when setting a value via a script or trasform map.

 

If you update the field map to use a script, you'll need to include the filtering behaviour within your script.