Hi I need to map email address of user record with the related list of AD account email address

[ServiceNow10sun]

Hi,

I need a compare the user email address in user record with the Ad account email address which is in the related list for user record ,

how can i compare this email address and if there is a difference in the email address i need to send an daily to a particular group

how can i achieve this any suggestion

thanks

[Saurabh Gupta]

Hi,
Do you have another table which stores the AD data related the user?

[ServiceNow10sun]

Hi Saurabh,

Yes i need to compare the email address from sys_user table and AD table which is "u_ad_user_account_list"

for every user i need to compare the email address from "sys_user "table to AD table" u_ad_user_account_list"

and if both email does not match i need to send a email on daily basis with the data.

thanks

[Saurabh Gupta]

Hi Do you have any reference of user table in "u_ad_user_account_list" table?

[ServiceNow10sun]

Hi,

in sys_user table "u_number "is the employee number and u_ad_user_account_list table 

"u_employeenumber "both are same these two feilds contains the employee ID of the user which is unique and same

thanks