BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 04-02-2008, 03:35 PM   #1 (permalink)
BlackBerry Extraordinaire
 
Frank Castle's Avatar
 
Join Date: Jul 2005
Location: MA
Model: 9930
PIN: PM Me!
Carrier: VZW
Posts: 1,073
Post Thanks: 0
Thanked 4 Times in 3 Posts
Default Role activity tracking?

Please Login to Remove!

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!
Offline  
Old 04-03-2008, 11:15 AM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

select * from userconfig

find the user in question and check out the CreationTime
Offline  
Old 04-03-2008, 11:47 AM   #3 (permalink)
BlackBerry Extraordinaire
 
Frank Castle's Avatar
 
Join Date: Jul 2005
Location: MA
Model: 9930
PIN: PM Me!
Carrier: VZW
Posts: 1,073
Post Thanks: 0
Thanked 4 Times in 3 Posts
Default

Thanks Dawg .. will that also tell who added the user?
Offline  
Old 04-03-2008, 12:06 PM   #4 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,876
Post Thanks: 3
Thanked 75 Times in 56 Posts
Default

No, this table doesn't show who added the user (but I'm looking for that, too).
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 04-04-2008, 10:37 AM   #5 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2006
Model: 8100t
Carrier: tmobile
Posts: 45
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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)
Offline  
Old 04-04-2008, 11:53 AM   #6 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,876
Post Thanks: 3
Thanked 75 Times in 56 Posts
Default

Do you know what tables contain the role information? I'm comfortable writing sql scripts to get the info.
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 04-04-2008, 12:15 PM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Feb 2006
Model: 8100t
Carrier: tmobile
Posts: 45
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

Last edited by Sagz : 04-04-2008 at 12:21 PM.
Offline  
Old 04-04-2008, 12:34 PM   #8 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,876
Post Thanks: 3
Thanked 75 Times in 56 Posts
Default

Wirelessly posted (My blond BlackBerry)

Excellent, thanks
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  




Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.