Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Bulk delete Enduser Primary & IPCC Extension possible?

Hi everyone,

Is there a way to bulk delete / reset to <None> to Enduser's Primary Extension and IPCC Extension?  In the BAT User Update Custom File, I tried NULL,&lt;None>, nothing helps.

I read somewhere there may be some fancy database query but I couldn't find it anymore.  Any details would be appreciated! 

Using the latest CUCM 9.1. - I would imagine Cisco must have prior request from customers, wonder why such feature is still missing from BAT.  There are many reasons why BULK RESET DN may be useful.  The alternative is to manual go through each Enduser and click drop down to <none>.  If there are hundreds or thousands, I can't imagine that's feasible.  There has to be a work around, especially for large deployments.

Unless I'm mistaken.  This should have been resolved around 6.x/7.x - wonder why no obvious documentation exist after all this time?

Thanks in advance,

John

3 REPLIES
New Member

Hi has anyone found a

Hi has anyone found a solution to this ? I need to set the User IPCC extension in bulk back to <none> tried many syntaxes without success.

New Member

i used this method  to update

i used this method  to update all my users with their Primary Extension, saved me a lot of work of having to do it one by one. i populated my CSV with the correct values for the Primary Extension field and then deleted all other fields except for User Id and Primary Extension and then uploaded as custom file. havent yet tried this method fro removing entries

Cisco Employee

Here is the procedure. Create

Here is the procedure.

 

Create a csv file with the template included below.

goto

Bulk Administration >> Upload/Download Files

Click Add New

Click Chose File

Search for the file you created earlier

On the Select The Target combo box choose Users

On the Select Transaction Type combo box choose Update Users - Custom File

Click Save

Verify that the Upload was successful

 

 

goto

Bulk administration >> Users >> User template

add new

Fill profile User Template Name

Example: "IPCC_EXENSION"

Click Save

 

goto

Bulk administration >> Users >> Update Users >> Custom File

On the File Name combo box select your file

On the User Template Name select your template

Fill Value for field ignored with "#" without the quotes

On the Job Information section leave the Job Description as it is and check the Run Immediately radio button

Click Submit

 

 

File template

USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,PRESENCE GROUP,SUBSCRIBE CALLING SEARCH SPACE,DIGEST CREDENTIALS,REMOTE DESTINATION LIMIT,MAXIMUM WAIT TIME FOR DESK PICKUP,ALLOW CONTROL OF DEVICE FROM CTI,ENABLE MOBILITY,ENABLE MOBILE VOICE ACCESS,ENABLE EMCC,DIRECTORY URI,ACCESS CONTROL GROUP 1,CONTROLLED PROFILE 1,CONTROLLED DEVICE 1,CTI CONTROLLED PROFILE 1,MLPP USER IDENTIFICATION NUMBER,MLPP PASSWORD,MLPP PRECEDENCE AUTHORIZATION LEVEL,HOME CLUSTER,ENABLE USER FOR UNIFIED CM IM AND PRESENCE,UC SERVICE PROFILE

johns,abcde,Daviss,12,12345,johnProfile,English United States,9728135047,9725557154 in EST,johns-pc,9728126675 in WST,johns,Standard Presence group,JohnCSS,johnCredent,4,10000,t,t,t,t,data@uri,CCM Users,johnprofile,SEP1231123245AB,johnProfile,123456789,12345,4,t,t,ucprofile

 

Here you have 2 options:

 

  1. Use the entire string of field names and use '#' to ignore the fields you do not want to update

USER ID,PASSWORD,MANAGER USER ID,DEPARTMENT,PIN,DEFAULT PROFILE,USER LOCALE,TELEPHONE NUMBER,PRIMARY EXTENSION,ASSOCIATED PC,IPCC EXTENSION,MAIL ID,PRESENCE GROUP,SUBSCRIBE CALLING SEARCH SPACE,DIGEST CREDENTIALS,REMOTE DESTINATION LIMIT,MAXIMUM WAIT TIME FOR DESK PICKUP,ALLOW CONTROL OF DEVICE FROM CTI,ENABLE MOBILITY,ENABLE MOBILE VOICE ACCESS,ENABLE EMCC,DIRECTORY URI,ACCESS CONTROL GROUP 1,CONTROLLED PROFILE 1,CONTROLLED DEVICE 1,CTI CONTROLLED PROFILE 1,MLPP USER IDENTIFICATION NUMBER,MLPP PASSWORD,MLPP PRECEDENCE AUTHORIZATION LEVEL,HOME CLUSTER,ENABLE USER FOR UNIFIED CM IM AND PRESENCE,UC SERVICE PROFILE

johns,#,#,#,#,#,#,#,9725557154 in EST,#,9728126675 in WST,#,#,#,#,#,#,#,#,#,#,#,#,#,#,#,#,#,#,#,#,#

 

  1. Or delete the fields that you don’t want to update (USER ID is mandatory)

USER ID,PRIMARY EXTENSION,IPCC EXTENSION

johns,9725557154 in EST,9728126675 in WST

 

Note that Primary Extension and IPCC Extension should be in following format

a. If Partition is not None - 'DirectoryNumber in Partition'

  For example, '1000 in EST' where 1000 is DirectoryNumber and EST is Partition

b. If Partition is None - 'DirectoryNumber'

  For example, '1000'

349
Views
0
Helpful
3
Replies
CreatePlease login to create content