I'm an Exchange System Admin and have been asked to find out which users on our exchange servers are blackberry users. There is no indication within Active Directory or the Exchange servers to tell me this so I've had to Get a List of all users from our BES and cross reference them. I can manually get the users via the BlackBerry Manager v.4.1 (And Snap-In) Export to list. This works however this will have to be done everyday for reporting purposes.
Is there any sort of command? that I can use to initiate this same thing? Because Every GUI is command driven there has to be one. All I need are the users Display Names. I've read a little about using SQL but I have NO Experience with these queries and honestly have no idea to do them. I am experienced with VBScript as I've written some WMI and LDAP queries. Is there a way to preform this via VBScript?
I've read from the Blackbery.com techsupport
Export user list and statistics from a BlackBerry Enterprise Server
For BlackBerry Enterprise Server version 4.1
You can use one of the following three methods to export the BlackBerry smartphone user list.
Method 1 - Export the user list using BlackBerry Manager
1. Open BlackBerry Manager.
2. Click BlackBerry Domain, and then click the All Users tab.
3. In the top right pane, select all users and click the Service Control & Customization link.
4. Click the Export Stats To File link.
5. Select a location, type a name for the text file, and click Save.
6. When Clear user stats after export appears, click Yes if you want statistics reset in the future; otherwise,
click No.
Method 2 - Export the user list using a SQL query list
1. Open a command prompt.
2. Type the following commands in the specified order:
Code:
osql -E
1> use besmgmt
2> go
1> SELECT DisplayName, PIN FROM UserConfig
2> go
3. Copy the information that appears and paste it to a text file.
Method 3 - Export the BlackBerry smartphone user list using the BCP command on the computer hosting
the BlackBerry Configuration Database
1. Open a command prompt.
2. Type the following
Code:
bcp besmgmt..userconfig out c:\filename.txt -c -T
I'm curious if its just as simple as a command line request? I can create this in a bat file and make it a scheduled task. Are Methods 2 and 3 what I'm looking for to Export to List all the Users on the BES? I'm figure its wise to ask first before just typing commands through the command prompt.
Thank You to anyone who is able to help.