CUEAC -SQL

Reference -CUEAC


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 = '’ where pkid = ‘BAD USER PKID’





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 = '"