Anyway to pull data from the BES server?

[richard371]

We need a list of all users, their model, phone #, FW version, wireless carrier etc we can put into an Excel spreadsheet.

When I do the export user stats I just get the name, Pin, messages pending, sent etc.

[juwaack68]

What version BES are you using?

[d_fisher]

You can write a query to pull the information you need directly from the SQL database. Might also want to look at BerryStats (http://www.thegrims.com/berrystats/).

[richard371]

4.1.0.38

[Notch Johnson]

We're running BES 4.0 SP4 HF#3 and we get that information from the Handheld Configuration Tool. Select all your handhelds, then under Tasks, select Export Asset Summary Data.

[jibi]

Which messaging system? If Exchange, you can open Handheld Configuration Tool and export them from there. It will only export what is available, so if the user has completed an enterprise activation, it will have that information (barring any sort of hiccups).

[EDDYBLUELEX]

Yup open up configuration tool hit handhelds. Than did a select all by highlightening all the accounts and hit tasks, export to ansi file. Use excel inport wizard. Than open txt file with excel to open delimted commas and tab.

[Sagz]

You can make a query in excel using the import external data option under (Data). This is as long as you have reader access to the sql db.

You select the server you are pulling from and then click on the fields.

Or here is a simple sql query for what you are looking

SELECT vHandheldSummaryInfo.DisplayName, vHandheldSummaryInfo.ModelName, vHandheldSummaryInfo.AppsVer, vHandheldSummaryInfo.PhoneNumber, vHandheldSummaryInfo.HomeNetwork, vHandheldSummaryInfo.PIN
FROM BESMgmt.dbo.vHandheldSummaryInfo vHandheldSummaryInfo

[onelikeseabass]

I'm running BES 4.1 but I have yet to see this Handheld Configuration Tool you all speak of. Is it an optional install?

[|||||||]

I'm running BES 4.1 but I have yet to see this Handheld Configuration Tool you all speak of. Is it an optional install?

In 4.1 it gets included into BlackBerry manager, go under the user list and select all users, go to Device Managment and Export Asset Summary.

I found it by accident one day.

[qc_metal]

Here's the thread for BerryStats ---> http://www.blackberryforums.com/bes-admin-corner/10003-berrystats-nonadmins.html?highlight=berrystats

We've updated it quite a bit from Brent's original code.

Rob