http://arcsolutions.com/north_america/solutions/products/cueac.aspx
admin:run sql select count(*) from enduser where telephonenumber = ''
--->To see total count of null extn
run sql select first 1 * from enduser where pkid > ‘
IF telephoneNumber of the next user is NULL use this query:
run sql select first 1 * from enduser where pkid > '05dee781-dd86-49f5-a2c4-4b2f59f3867a' and telephonenumber != ''
Once we find the bad user –
run sql update enduser set telephonenumber = '
EAC Troubleshooting.
Login to the database using sa account.
System Databases -> ATTCFG
Then execute the below comman.
select * from dbo.Contact_Header order by Source_Unique_ID
--> To see the total LDAP users on EAC
And if you stuck with any time scroll down and select the last source unique id and copy it and execute the below command.
:run sql select first 1 * from enduser where pkid > '51ad91da-8860-4969-a56e-f04d1c77c971'
And then find it out where its getting stuck. (for ex:- if its stucking at the telephone number then run the below command to edit the telephone number.
run sql update enduser set telephonenumber = '+886-2-2176-9552' where pkid = '
