Removing Technician
I've removed a technician from SDP, and have re-scanned AD to re-add them as a standard user. This has created a new ID file for them and they are now not able to view their previous requests. I've followed advice from last time I needed to do this (about a year ago), but its not transferred their old requests to their new user ID.
These are the steps I've followed...
Logon to the server - In command prompt goto folder c:\AdventNet\Me\ServiceDesk\mysql\bin, then type 'mysql.exe -u root -P 33366 servicedesk'
On SDP, create a New Query Report
'select * from aaauser where first_name like 'Wayne%'' - shows all users names becoming with Wayne
Two accounts are shown - 610, and 10202
'select * from sduser where userid=610' - shows status of account
610 shows resigned, 10202 shows active
'select count(*) from workorder where requesterid=610' - counts how many requests have been created by specific userid
610 counts 5 requests, 10202 counts 0 requests
On server CMD console
'update workorder set requesterid=10202 where requesterid=610' - changes requests from old user to new new user id.
Goes to a mysql prompt
I've then re-run 'select count(*) from workorder where requesterid=610' and the request counts are the same.
These are the steps I've followed...
Logon to the server - In command prompt goto folder c:\AdventNet\Me\ServiceDesk\mysql\bin, then type 'mysql.exe -u root -P 33366 servicedesk'
On SDP, create a New Query Report
'select * from aaauser where first_name like 'Wayne%'' - shows all users names becoming with Wayne
Two accounts are shown - 610, and 10202
'select * from sduser where userid=610' - shows status of account
610 shows resigned, 10202 shows active
'select count(*) from workorder where requesterid=610' - counts how many requests have been created by specific userid
610 counts 5 requests, 10202 counts 0 requests
On server CMD console
'update workorder set requesterid=10202 where requesterid=610' - changes requests from old user to new new user id.
Goes to a mysql prompt
I've then re-run 'select count(*) from workorder where requesterid=610' and the request counts are the same.