Close the Gap Between JAMF and ServiceNow: Bring Last Logged-In User Data into Your CMDB

[Anne Marie Duff]

Close the Gap Between JAMF and ServiceNow: Bring Last Logged In User Data into Your CMDB   

Why This Matters (More Than You Think)  

Last logged in User data isn't just metadata. It's the thread that ties devices to people. When you have it in your CMDB, you unlock real workflows:  

• A suspected breach? You know instantly which user's device was compromised.  

• Compliance audit? Device-to-user mappings are already there, verified and current.  

• License reconciliation? Connect device usage to actual users instead of guessing.  

• Automation? Trigger workflows based on device ownership and activity patterns.  

The Technical Snag 

Here's why you probably haven't done this yet: The JAMF Service Graph Connector does not bring in Last Logged in User data as an Out of the Box Field. 

  

The good news? There's a clean path: It’s possible to build a JAMF Extension Attribute(EA) for capturing Last Logged in User at the JAMF Back end  that will then be included in the Extension Attributes data that gets fed to ServiceNow by the JAMF Service Graph Connector. The IntegrationHub ETL Tool can then be used to extract this Last Logged in User data using 3 Transforms which then gets mapped to a Custom Last Logged in User Field in the Target CI.

  

Here's How It Works 

• Step 1: New Last Logged in User Extension Attribute 
  
  Create a new Last Logged in User Extension Attribute at the JAMF Backend 
  
  

• Step 2: Extract and Transform 
  
  Create three Transforms in IntegrationHub ETL:
  
  - Copy the Extension Attribute Json field from the Parent Object to the Child Hardware Object
  - Find the Last Logged In User value in the Extension Attribute Collection
  - Look up that User's sys_id in ServiceNow's Users table. 
  
  

• Step 2: Map it Home 

Drag that Sys_id to your custom Last Logged In User Reference field on the Computer CI. Done. 

What You'll Need Before You Start 

• Access to the IntegrationHub ETL Tool 
• An Active SG-JAMF Computers Scheduled Import Job with a valid Import Set ready to go 
• A JAMF Extension Attribute set up to capture Last Logged in User data in the JAMF Backend (JAMF community has sample BASH scripts if you need them) 
• A Custom Last Logged In User Reference field already created on your Computer CI 

Ready to Dig In? 

We've written a detailed Step-by-Step Guide that walks you through every Configuration Change and includes all the Transform Operations you'll need. It's not complicated—mostly clicking through menus and pasting code. Plan for 30–45 minutes once you have the prerequisites ready. 

→ See the full implementation guide 

One Last Thing 

This pattern isn't just for Last Logged in User data. Once you understand how it works, you can use the same approach to surface any JAMF Extension Attribute—e.g. device location, department  etc