Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
New Contributor
gtjr92
Posts: 3
Registered: ‎07-18-2012
My Device: Blackberry bold 9700
My Carrier: Cincinnati Bell

BES 5 Query for Messages Received

I need a sql query that shows messaged sent, messages received, and availabilty percentage of blackberry service. I know where message sent is in the userstats table, not sure how or where to get messages received or blackberry availabilty. Help is greatly appreciated. I take it there is still no publically available data diagram or data dictionary for the BES database? Thanks Using BES 5
Please use plain text.
Guru III
knottyrope
Posts: 29,776
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 5 Query for Messages Received

some good scripts here

http://www.port3101.org/scripts-tools-hints-tricks/

 

also the BRK has some good tools as well.

https://swdownloads.blackberry.com/Downloads/entry.do?code=D736BB10D83A904AEFC1D6CE93DC54B8

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.
New Contributor
gtjr92
Posts: 3
Registered: ‎07-18-2012
My Device: Blackberry bold 9700
My Carrier: Cincinnati Bell

Re: BES 5 Query for Messages Received

Thanks, I have no access to Blackberry server only to the Sql Server so the resource kit won't help.

I'll check out those scripts, if anyone else knows off hand how I can retrieve that data I would appreciate it.

Thanks

Please use plain text.
Guru III
knottyrope
Posts: 29,776
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 5 Query for Messages Received

some of the BRK components only needs access to the SQL server

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.
New Contributor
gtjr92
Posts: 3
Registered: ‎07-18-2012
My Device: Blackberry bold 9700
My Carrier: Cincinnati Bell

Re: BES 5 Query for Messages Received

Yeah that may be true but I am not sure if that software is approved by the powers that be for use on a client pc.
We have very strict software requirement.

Hoping someone may know what tables may hold this info.

Please use plain text.
Guru III
knottyrope
Posts: 29,776
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 5 Query for Messages Received

good luck and hope you get a response for your query

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008


Please use plain text.