Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Jamf SG Connector Creating Incorrect core_company Records

LeelaVinodK
Tera Contributor

Hi Community,

We’re facing an issue where the Jamf Service Graph Connector is creating core_company records from employee names (e.g., “Abhishek Bathina”). These values are not present in the sys_user table — they come from Jamf fields like user/department/site and are being misinterpreted as company references. We're using the OOB Jamf SG setup with no custom mappings yet.

Looking for guidance on:

  • How to block or filter these values using transform maps or pre‑import scripts
  • How to configure IRE/Normalization to prevent unwanted company creation
  • Best practices for mapping Jamf fields during the initial SG Connector setup

Goal: Prevent junk company records while keeping the CMDB clean.

Thanks!

1 REPLY 1

Tanushree Maiti
Kilo Patron

Hi   @LeelaVinodK 

 

Since you are using out-of-the-box (OOB) mappings, the best way to handle this without modifying the core data source is to
1. use a onBefore Transform Script on the transform map (IRE) which is responsible for this issue.
 
  • Add a script to ignore the company mapping if it looks like a person's name or is not in a specific format.

e,g If the value in source table in format First name  Last Name

  Then use following regex to validate the value.

 

Regex :  /^[A-Z][a-z]{2,}\s[A-Z][a-zA-Z]{2,}$/

 

Refer: JAMF servicenow integration 

 

Data Sanitization in Jamf (Long-term Fix)
  • Review Department/Site: Ask your Jamf Administrator to review the computer records in Jamf and ensure that "Department" or "Site" fields are populated with actual department names, not user names.
  • Check User Records: Ensure the "User" information is mapped to the correct, existing user record, not free-text.

 

 

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin: