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: