I am looking for a script to parse the BESMgmt DB and give me a list of how many Blackberry Users per Exchange server there are. I have limited SQL experience and can get SELECT ServerDN from UserConfig but I'm sure there is a better way to collect and group the results using COUNT or something but it is beyond me (especially on my last day at work for a week and a half).

any help would be appreciated. thanks.

ps script needs to be SQL 2000 and 4.1.6 compatible.

__________________
Two months ago, I saw a provocative movie on cable TV. It was called The Net, with that girl from the bus.

DECLARE @ZZZtemp TABLE (
UserName VARCHAR( 256 ),
ServerName VARCHAR( 256 ))

INSERT INTO @ZZZtemp (UserName, ServerName)
SELECT DisplayName, ServerDN
FROM UserConfig

SELECT ServerName, (COUNT (*)) AS NumUsers FROM @ZZZTemp Z GROUP BY Z.ServerName

__________________
http://blog.port3101.org/hdawg/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.

Nice. I like this one.

__________________
You may know me as Juwaack68

ahh thanks howie. i've forgotten more sql than u'll ever know! actually strike that, reverse it.

__________________
Two months ago, I saw a provocative movie on cable TV. It was called The Net, with that girl from the bus.

There is also a free app called BERRYSTATS. BerryStats and Useful tools for BlackBerry Administrators it is very useful for this type of thing as well as other data / reporting requirements.

using your script i get...

Server: Msg 260, Level 16, State 1, Line 5
Disallowed implicit conversion from data type ntext to data type varchar, table 'tempdb.dbo.#31654011', column 'ServerName'. Use the CONVERT function to run this query.

I have tried using CONVERT and CAST every way google will show me but i still can't get it to work. help?

__________________
Two months ago, I saw a provocative movie on cable TV. It was called The Net, with that girl from the bus.

Here's a much more simple version ... does this work?

SELECT CAST(ServerDN AS VARCHAR(256)) , COUNT (*)
FROM UserConfig
GROUP BY CAST(ServerDN AS VARCHAR(256))

__________________
http://blog.port3101.org/hdawg/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.

holy crap awesome.

__________________
Two months ago, I saw a provocative movie on cable TV. It was called The Net, with that girl from the bus.

Translation ... Yes?

__________________
http://blog.port3101.org/hdawg/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.

will that script work against SQL 2005?

__________________
AUTIGER92
Exchange\Blackberry Admin
4 - BES Servers (4.1.6), 3 Exchange Organizations,
~1800 BB Users, and a headache.
War Eagle!!

Yes, very much so.

__________________
http://blog.port3101.org/hdawg/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.