BlackBerry Forums Support Community

BlackBerry Forums Support Community (http://www.blackberryforums.com/)
-   BES Admin Corner (http://www.blackberryforums.com/bes-admin-corner/)
-   -   Role activity tracking? (http://www.blackberryforums.com/bes-admin-corner/123433-role-activity-tracking.html)

Frank Castle 04-02-2008 03:35 PM

Role activity tracking?
 
I don't think this is possible but wanted to ask:

Is there a log that would tell when / who a user was added to the BES? I only keep 2 months of logs and this event occured in December so unsure anything can be extracted from the SQL DB?

Thanks all!

hdawg 04-03-2008 11:15 AM

select * from userconfig

find the user in question and check out the CreationTime

Frank Castle 04-03-2008 11:47 AM

Thanks Dawg .. will that also tell who added the user?

juwaack68 04-03-2008 12:06 PM

No, this table doesn't show who added the user (but I'm looking for that, too).

Sagz 04-04-2008 10:37 AM

You can create a query from the tables or if you dont feel comfortable writing your own stuff download this:
BlackBerry Domain Administration History Tool Audits configuration changes to the BlackBerry Enterprise Server environment and outputs to a .csv file

BlackBerry - BlackBerry | Wireless Handheld Devices, Software & Services from Research In Motion (RIM)

juwaack68 04-04-2008 11:53 AM

Do you know what tables contain the role information? I'm comfortable writing sql scripts to get the info.

Sagz 04-04-2008 12:15 PM

SERVERCONFIGHISTORY is the table you will want to use. You will want to do a join with USERCONFIG. I cant remember what the call is for adding to a server but will reply when I find it again.

juwaack68 04-04-2008 12:34 PM

Wirelessly posted (My blond BlackBerry)

Excellent, thanks


All times are GMT -5. The time now is 01:51 AM.

Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.