update requester info via SQL
Hi
I would like to update requester informations (i.e. phone number, mobile number and email address) via SQL, from data which has been exported from our HR application. The primary key is the SDPlus "employee ID" field.
In which table from the servicedeskplus MySQL database can I find the data? Which table(s) do I need to SQL update? Has anyone an SQL statement for this?
Thanks a lot
Marc
I would like to update requester informations (i.e. phone number, mobile number and email address) via SQL, from data which has been exported from our HR application. The primary key is the SDPlus "employee ID" field.
In which table from the servicedeskplus MySQL database can I find the data? Which table(s) do I need to SQL update? Has anyone an SQL statement for this?
Thanks a lot
Marc