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  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Progressive Electronics 200EP Inductive Amplifier
$29.99
Progressive Electronics 200EP Inductive Amplifier pictureFederal 832 Gaging Amplifier EAS02807
$199.99
Federal 832 Gaging Amplifier EAS02807 pictureREXROTH VT-VRPA2-2-10a/V0/T5 / VRPA2-2 / VT-3002-2X/48F AMPLIFIER CARD & HOLDER
$999.97
REXROTH VT-VRPA2-2-10a/V0/T5 / VRPA2-2 / VT-3002-2X/48F AMPLIFIER CARD & HOLDER pictureKollmorgen S31061-NA Digital Servo Amplifier SERVOSTAR 310 AMAT Quantum X
$475.0
Kollmorgen S31061-NA Digital Servo Amplifier SERVOSTAR 310 AMAT Quantum X  pictureHEWLETT PACKARD 1801A DUAL CHANNEL VERTICAL AMPLIFIER w/ OSCILLOSCOPE
$99.99
HEWLETT PACKARD 1801A DUAL CHANNEL VERTICAL AMPLIFIER w/ OSCILLOSCOPE  picture






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