|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?
|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).
|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.
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)
|All times are GMT -5. The time now is 01:09 AM. || |
Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.