Hello,

I import about 5000 new resources (not it, asset) to service desk 7.5.0 Build 7509 from csv files. I have about 2000 users from AD in service desk. I want to assign that users to resources. I have in excel columns resourceownerid, resourceid,userid,deptid from service desk database. I try to import new table (import) to sevice desk database. and run query like:

 

  
  
update resources, import
set resources.RESOURCESTATEID = 2
where resources.RESOURCEID = import.RESOURCEID
 

  

   
 
insert INTO resourceowner (resourceownerid, resourceid, userid, deptid) 
select import.resourceownerid, import.RESOURCEID, import.userid, import.DEPTID from import