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

(Lot of 30 chips) 256K x 1, DRAM Memory (Hynix Intel Samsung) 16 Pin DIP PC MAC
$20.0
(Lot of 30 chips) 256K x 1, DRAM Memory (Hynix Intel Samsung) 16 Pin DIP PC MAC pictureNEW Gidding & Lewis 502-03174-00 Memory Complier New in Box NIB
$39.0
NEW Gidding & Lewis 502-03174-00 Memory Complier New in Box NIB pictureNew DIY DS3231 Precision RTC Clock Module Memory Module for Arduino WT88 01
$2.9
New DIY DS3231 Precision RTC Clock Module Memory Module for Arduino WT88 01 picture(Lot of 54 chips) 256K x 1, DRAM Memory ( NMBS AAA2801P ) 16 Pin DIP 60ns PC MAC
$45.0
(Lot of 54 chips) 256K x 1, DRAM Memory ( NMBS AAA2801P ) 16 Pin DIP 60ns PC MAC pictureRCA SK9832 - 16K Dynamic Random Access Memory (RAM) IC, NOS
$14.5
RCA SK9832 - 16K Dynamic Random Access Memory (RAM) IC, NOS picture






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