Hi,

I have a bit of a problem.

One of our customers have used a consultant for a long time, and have now employed this consultant under their own "flag". The requester have since gotten a new username in their AD and a new requester in SDP MSP. 

The problem is that they want all the requests he registered when he was a consultant moved to his new requester. 

So, my question is: Can I somehow, find the ID of the old requester in the database, and with it, change the owner of all the requets he have registered.

E.G: 

OLD_User A = ID 1

NEW_User B = ID 2

All requests Owned/regsitered by ID 1 change owner to ID 2.

Build 9416

MSSQL