BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-17-2009, 02:14 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: May 2007
Location: Holiday, Florida
Model: Pearl
PIN: N/A
Carrier: Cingular
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question Export user name and email address

Please Login to Remove!

I've tried everything to export just the user name and email address with no success. I did place a call with RIM who had me do a OSQL query, but the output was so mangled that it would take me hours to get displayname, email address into an excel spreadsheet. I've looked into the resource kit and found nothing either. Can anyone help - I only want those 2 things. TIA
Nancy
Offline  
Old 02-17-2009, 03:43 PM   #2 (permalink)
rsk
Thumbs Must Hurt
 
Join Date: Jan 2007
Model: 9630
Carrier: Sprint
Posts: 134
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

this is the easiest I could come up with in one line, replace <SQLServer> with your SQL server:

Quote:
Originally Posted by sqlcmd
sqlcmd -S <SQLServer> -W -s ; -Q "select mailboxSMTPAddr,displayName from besmgmt.dbo.UserConfig" > userList.csv
you should be able to import userList.csv into Excel, the -s option is the colums seperator, you can change that to suit.
Offline  
Old 02-17-2009, 04:06 PM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: May 2007
Location: Holiday, Florida
Model: Pearl
PIN: N/A
Carrier: Cingular
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

thank you - I'll give that a try. We don't have a seperate SQL server, it's all local to the BES - will that make a difference?

It didn't work - sorry.

Last edited by NancyStevens : 02-17-2009 at 04:27 PM.
Offline  
Old 02-17-2009, 04:46 PM   #4 (permalink)
BlackBerry Extraordinaire
 
Frank Castle's Avatar
 
Join Date: Jul 2005
Location: MA
Model: 9930
PIN: PM Me!
Carrier: VZW
Posts: 1,073
Post Thanks: 0
Thanked 4 Times in 3 Posts
Default

I highly recommend getting BerryStats or use Big Phil's Blackberry Reporter. Both make reporting for this type of information very quick and easy.
Offline  
Old 02-18-2009, 03:23 AM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

The other possibility would be to use QueryExpress. This will enable you to query the database from a windows app. It doesn't install anywhere, it's a standalone exe.

The query you want is:
Code:
select
Right(DisplayName, Len(DisplayName) - CharIndex(',',DisplayName)-1) + ' ' + Left(DisplayName, CharIndex(',',DisplayName)-1) AS UserName,
mailboxSMTPAddr
FROM vUserConfigStats
This will also turn the name into "Michael Mouse" not "Mouse, Michael"
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 02-18-2009, 09:08 AM   #6 (permalink)
Knows Where the Search Button Is
 
Join Date: May 2007
Location: Holiday, Florida
Model: Pearl
PIN: N/A
Carrier: Cingular
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Excellent - that worked perfect with QueryExpress - thank you so much!!
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.