Field mapping for CI$User table
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
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?
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.