Home Analyst Portal

Field mapping for CI$User table

Brian_WinterBrian_Winter Customer Advanced IT Monkey ✭✭✭

We have a handful of Users in the CI$User table that don't have emailaddress1. However in AD both mail and emailaddress have values. I'm trying to find the field in Service Manager that the CacheBuilder job pulls. Then I can trace back to AD and find the field that Provisioning is missing.

TIA

Answers

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭

    The SCSM database stores the values into two separate tables. First question if you open the user CI and open the Notification tab. Is there any values listed there for the user in question?

  • Brian_WinterBrian_Winter Customer Advanced IT Monkey ✭✭✭

    Hi Brian,

    There is an SMTP value just like all active users. After some digging around, we found that the problem stems from an extension to the ,AD User object. We added a "mail" field that is populated from an excel dump from an AD extract. We needed an email address on the User object itself. Once we created and populated this custom field, Cireson somehow began mapping the emailaddress1 to this new mail field! Dunno how that happened!

    As a interim fix, we have a RunBook that is scheduled nightly. It basically cycles thru AD and updates about 5 extensions (an Employee Type, Business Unit, Region, etc.) We just added "mail" to the list of fields that now gets updated nightly.

Sign In or Register to comment.