Quote:
Originally Posted by DavidAdams
It's not mine either.
This assumes you have access to the SQL server remotely.
Setup an Excel spread sheet so that it queries your BES SQL, i look in vUserConfigStats.
In Excel go to Import Data and create a new SQL query connection, connect to your BES SQL, select the BESMgmt database and then the relevant table/view. This will pull all the columns into the spread sheet. All i did then was reorder them and hide those i don't want to see.
|
THANKS! I'll show this to by SQL DBA tomorrow.
In other news on this topic, our RIM support contract is renewed (YEAH!) I called them today and got the low down on the BB Resource Tool Kit. In a nutshell, I find it lame.
We installed the necessary tools on my local PC. Then you copy the log files OFF of the BES server and someone on your local PC then run the command...
for example:
Quote:
MessageFlow.exe -p e -u -l c:\beslogs
|
Where "-p e" means I use exchange, vs domino, etc.
"-u xxxxx" is the person's email address who's states you want to get
"-l c:\beslogs" is the folder i copied the log file that this particular tool needs to read.
Do not rename the log files when you copy them, and each resource kit tool command line needs a seperate log file. by default it then creates a .csv in the folder the command line app runs from.
And RIM said there is no util that gives you just the "total # of sent emails" since activation like the web gui does for each user. i feel i should have stayed with 4.1
*sigh.