Skip to main content
Solved

Email field update

  • July 28, 2021
  • 3 replies
  • 23 views
B
Forum|alt.badge.img+3

I have a spreadsheet with machine name and serial number of machine.  Another field in the file is email address.  I want to find a way to update the User / EmailAddress field for each matching machine/serial number in Jamf database.   Can that be done and can someone show me the way?

Best answer by damienbarrett

I would do this with the MUT.

https://marketplace.jamf.com/details/the-mut/

    3 replies

    damienbarrett
    Forum|alt.badge.img+19
    • damienbarrett
    • Honored Contributor
    • Answer
    • July 28, 2021

    I would do this with the MUT.

    https://marketplace.jamf.com/details/the-mut/

      bwoods
      Forum|alt.badge.img+14
      • bwoods
      • Honored Contributor
      • July 28, 2021

      @brodeurm , I use the script below to update this information automatically as the machine is being configured via DEPNotify.

       

       

      #!/bin/bash # jamfProUserInfo.sh # Brandon Woods # June 2021 # This script locates the current user and updates Jamf Pro with user details jamfBinary="/usr/local/bin/jamf" currentUser=`python -c 'from SystemConfiguration import SCDynamicStoreCopyConsoleUser; import sys; username = (SCDynamicStoreCopyConsoleUser(None, None, None) or [None])[0]; username = [username,""][username in [u"loginwindow", None, u""]]; sys.stdout.write(username + "\\n");'` fullName=`dscl . -read /Users/$currentUser RealName | tail -1` emailAddress="$currentUser@domain.com" # Declare user details echo $currentUser echo $fullName echo $emailAddress # Set username in Jamf Pro sudo $jamfBinary recon -endUsername "$currentUser" # Set full name in Jamf Pro sudo $jamfBinary recon -realname "$fullName" # Set email address in Jamf Pro sudo $jamfBinary recon -email "$emailAddress" # Exit Script exit 0 ## Success exit 1 ## Failure

       

       

        easyedc
        Forum|alt.badge.img+16
        • easyedc
        • Esteemed Contributor
        • July 28, 2021

        Are you using Microsoft 365 for your corp email? If so, you can query the system locally and get the account that activated the Office Suite (since that would hopefully be 1-1) and report that back as an EA, as well. 

        #!/bin/zsh # Who Activated Office.sh # # Created by Ed Corfman on 4/22/21. # ## Query to get who activated the Office applications to hopefully turn it into a "who owns' this computer" # Get the user whodis=$( /usr/bin/stat -f "%Su" /dev/console ) # Check Office license Activate=$(defaults read /Users/$whodis/Library/Preferences/com.microsoft.office.plist OfficeActivationEmailAddress) # Did you get a real email address? # No? if [[ "$Activate" != *"@"* ]]; then echo "<result>"Office is not activated"</result>" exit 0 # Yes? else # Send it back to Jamf echo "<result>$Activate</result>" fi exit 0

         You can take that output and apply it to any EA you want or simply write it to the Email field. 

        /usr/local/bin/jamf recon -email $Activate

         

          Terms & ConditionsCookie settingsAccessibility statement