https://community.blueprism.com/t5/Product-Forum/Scheduler-Database/m-p/83027#M34363 I think BPATaskSession table holds below attributes, you can use it. But not sure does this allow direct write permission from sql: BPATaskSession The assignation of a process / resource to a task - a ""session"" in scheduler. Field: TaskID,processid, id and resourcename should be something to consider. Mon, 23 Apr 2018 12:05:00 GMT syed.viqar.raza 2018-04-23T12:05:00Z https://community.blueprism.com/t5/Product-Forum/Scheduler-Database/m-p/83026#M34362 In control room i have a list of processes scheduled on different different resource pc's in virtual machines. But due to a network update in the virtual machine I need to again map all the processes to the respective resource pc's in the control room scheduler. I want to write a database query that could do it automatically instead of doing it manually. Mon, 23 Apr 2018 08:11:00 GMT https://community.blueprism.com/t5/Product-Forum/Scheduler-Database/m-p/83026#M34362 ankitbass 2018-04-23T08:11:00Z https://community.blueprism.com/t5/Product-Forum/Scheduler-Database/m-p/83027#M34363 I think BPATaskSession table holds below attributes, you can use it. But not sure does this allow direct write permission from sql: BPATaskSession The assignation of a process / resource to a task - a ""session"" in scheduler. Field: TaskID,processid, id and resourcename should be something to consider. Mon, 23 Apr 2018 12:05:00 GMT https://community.blueprism.com/t5/Product-Forum/Scheduler-Database/m-p/83027#M34363 syed.viqar.raza 2018-04-23T12:05:00Z https://community.blueprism.com/t5/Product-Forum/Scheduler-Database/m-p/83028#M34364 ohkz...thanks a lot...i will try this one. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Wed, 02 May 2018 12:22:00 GMT https://community.blueprism.com/t5/Product-Forum/Scheduler-Database/m-p/83028#M34364 ankitbass 2018-05-02T12:22:00Z