Results 1 to 7 of 7

Hi, Is there any way to export users list as a spreadsheet. Thanks... Server Admins forum

  1. #1
    Deadlock's Avatar
    Deadlock no está en línea Stack level 1
    Join Date
    May 2007
    Posts
    2

    Exporting users list as a spreadsheet

    Advertisement



    Hi, Is there any way to export users list as a spreadsheet.


    Thanks

  2. #2
    Felixtc's Avatar
    Felixtc no está en línea Stack level 3
    Join Date
    Sep 2006
    Posts
    236

    Re: Exporting users list as a spreadsheet

    Welcome to Pinstack Deadlock,


    I am not a BES Admin but I try to read and understand what BES has to offer. As for your question about exporting to excel I came across the following:


    The procedures below describe how to export information to a .csv file to determine how many active Client Access Licenses (CAL) are associated with a BlackBerry Enterprise Server.


    For BlackBerry Enterprise Server for IBM Lotus Domino

    1. In BlackBerry Manager, click File > Export. The Save As dialog box appears.
    2. Name and save the file as a .csv file. The file contains information from the BlackBerry Manager, including BlackBerry device personal identification numbers (PINs).
    3. In Microsoft Excel, open the .csv file created in step 1 and create a report or use filters to display the PINs in the file. Use this report to determine how many BlackBerry devices are currently associated with the BlackBerry Enterprise Server.
    4. Repeat the procedure for each BlackBerry Enterprise Server in your environment.

    For BlackBerry Enterprise Server for Microsoft Exchange

    1. In BlackBerry Manager, select the BlackBerry Enterprise Server name in the left-hand pane.
    2. Click Action and select Export List from the menu. The Save As dialog box appears.
    3. Name and Save the file as a .csv file. The file contains information from the BlackBerry Server Manager, including device PINs.
    4. In Microsoft Excel, open the .csv file you created in step 1 and create a report or use filters to display the PINs in the file.
    5. Use this report to determine how many devices are associated with the BlackBerry Enterprise Server.
    6. Repeat the procedure for each BlackBerry Enterprise Server in your environment.
    __________________________________________________

    -Felix
    "Carpe Omnius"

  3. #3
    cp6169's Avatar
    cp6169 no está en línea Device Pro
    Join Date
    Mar 2006
    PIN/ID
    3056468b
    Posts
    14,661

    Re: Exporting users list as a spreadsheet

    Hi Deadlock, welcome aboard. Any other questions let usk now.

  4. #4
    Deadlock's Avatar
    Deadlock no está en línea Stack level 1
    Join Date
    May 2007
    Posts
    2

    Re: Exporting users list as a spreadsheet

    Thanks a lot you guys(and gals). That saved me lot of c/p

  5. #5
    sisluv's Avatar
    sisluv no está en línea Stack level 1
    Join Date
    Oct 2008
    Posts
    2
    With BES Ver 4.1.6 you can open Blackberry License Management and in the status box will tell you the license total, Used and free. There's no need to export to a file.

  6. #6
    solah's Avatar
    solah no está en línea Stack level 1
    Join Date
    Jan 2008
    Posts
    16
    If you need it in any other formats, the BlackBerry Monitoring Service reporting tab allow user list exports directly to PDF, HTML and CSV.

  7. #7
    ecnavt's Avatar
    ecnavt no está en línea Stack level 2
    Join Date
    Jan 2008
    PIN/ID
    32caaed1
    Posts
    62
    You can also open an ODBC connection to the SQL database to bring the data into a spreadsheet. I don't recall the exact table name but it was fairly intuitive.

    Trevor

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •