Bulk update EndUser table

Version 1
    This document was generated from CDN thread

    Created by: Mayank Sharma on 13-04-2009 02:50:51 PM
    Hi,
     
    I can update enduser information in EndUser table in CUCM 6.1 using ExecuteSQLUpdateReq. Is there a way I can bulk update users instead of one user at a time?

    Thanks,
    Max

    Subject: RE: Bulk update EndUser table
    Replied by: Mayank Sharma on 13-04-2009 03:57:26 PM
    Thanks David.
     
    I am just updating existing users using SQL instead of adding users. As of now, I have a CSV file which has userids and the fields that need to be updated.
     
    I read the file, each record one by one and execute the SQL for each record. This takes some time if I have a bunch of users. I was wondering if there something similar to bulk or batch update in AXL.
     
    Regards,
    Max

    Subject: RE: Bulk update EndUser table
    Replied by: Mayank Sharma on 13-04-2009 05:04:51 PM
    Sure, here it is...it's just a simple SQL Update statement:
     
    UPDATE EndUser
    SET department = '<DEPARTMENT>', building = '<BUILDING>'
    WHERE userid = '<USERID>'
     
    Let me check the BAT tool but I really doubt it can update these fields as they are meant to be updated by an Active Directory sync.
     
    Thanks again,
    Max

    Subject: RE: Bulk update EndUser table
    Replied by: David Staudt on 13-04-2009 03:22:35 PM
    The Bulk Administration Tool (BAT) that's available with UCM makes it pretty easy to add bulk end users.
     
    Otherwise, if you're already using AXL+SQL to add users, you should be able to just modify the SQL update request to add additional rows of data..?
     
    What is the current SQL update you're using?

    Subject: RE: Bulk update EndUser table
    Replied by: David Staudt on 13-04-2009 04:34:14 PM
    I don't know a lot about BAT, but I seem to recall you can do updates to existing stuff with it.
     
    There aren't any secret bulk update capabilities in AXL, but you may be able to do something interesting with SQL.  Can you post an example of one of your SQL queries?  What user data/fields are you updating, and with what kind of data?

    Subject: RE: Bulk update EndUser table
    Replied by: Mayank Sharma on 13-04-2009 07:56:25 PM
    That sounds like a good idea.

    Subject: RE: Bulk update EndUser table
    Replied by: David Staudt on 13-04-2009 07:42:47 PM
    Depending on how your update data is structured, about all I could suggest would be to update several users at a time...something like:
     
    UPDATE EndUser
    SET department = '<DEPARTMENT>', building = '<BUILDING>'
    WHERE userid in ['<USERID1>','<USERID2>',...'<USERIDn>']
     
    This should cut down the number of individual updates by at least several multiples.