Is it possible to export TMSPE user info?

[epicolo]

Is it possible to export TMSPE user info?

We have hundreds of manual users that had been migrated from Legacy Provisioning and are now running on TMSPE.

Now, we have to export the user info to populate a spreadsheet to upload on a new Jabber UC environment (CUCM).

Any ideas?

PS: This customer do not have AD/LDAP. All user info are stored at TMSPE DB.

Thanks.

[Patrick Sparkman]

You can use TMS to export your provisioning phone book to an Excel document.  See tms-export-phonebook-issue for user friendly steps on how to do this, it's also documented in the TMS Admin Guide as well on pg 186.

[epicolo]

Thanks Patrick. This can help, but I was thinking in something from the SQL DB.

The Phonebook method do not include all User fields.

Regards

[Patrick Sparkman]

What user fields or data are you wanting?

[epicolo]

Display Name:    

Username:    

Password:    (we can skip this one)

Email:    

First Name:    

Last Name:    

Title:    

Company:    

Department:    

Office Phone:

[Patrick Sparkman · Accepted solution]

I'm not a SQL admin so I can't say how to export the data, but you can get that information from the tmspe database within the dbo.ur_user table.  Passwords will be hashed, so exporting them is pointless.

Table columns within dbo.ur_user that will be relevant to what you want are:

• username
• email
• first_name
• last_name
• title
• company
• department
• office_phone
• mobile_phone

[epicolo]

Thanks for the info. I´ll research on this way....

Do you know if they are stored by TMSPE groups? There are several groups and they need to export only one or two.

Thanks

Regards