Pls assist to write transform map script

BanuMahalakshmi
Tera Contributor

‎10-15-2024 02:14 AM

Hi,

Please assist to create Transform map script for below scenario:

 

  • If the value X exists in both source and target table(cmdb), then set CMDB class value = X and update the below fields in CMDB table:
    • Computer exists in Source = yes
    • last login date as same as source
    • Description as same as Source
  • If the value X exists in Source but does not exist in target(CMDB):
    • No action
  • If the value does not exist in Source, but exists in target and CMDB class = X, update this field in CMDB.  
    • Computer exists in Source = no



0 Helpfuls
  • 169 Views
1 REPLY 1

Kieran Anson
Kilo Patron

‎10-15-2024 02:21 AM

Rather than using the legacy transform maps, I'd look into using robust transform maps when importing CMDB data. The best way to create and manage robust transform maps is via IntegrationHub ETL 

https://www.servicenow.com/community/cmdb-articles/integrationhub-etl-introduction/ta-p/2301028 

0 Helpfuls