BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 08-11-2009, 08:53 AM   #1
noeffectx
CrackBerry Addict
 
noeffectx's Avatar
 
Join Date: Apr 2006
Location: nyc & pt. pleasant beach, nj
Model: 8320
PIN: 123456
Carrier: T-mobile
Posts: 565
Default BES User Creation/added Report

Please Login to Remove!

Hello guys,


Can someone help me on my little issue. My boss wants me to submit a report of userlist on BES and when they got added on BES.

I'm trying to modify the view columns on BES but cant find it. Is there a log where I can find this list?


Thanks
__________________
Exchange 2007
BES 4.1.6.9

http://www.flickr.com/groups/blackberry/
Offline  
Old 08-11-2009, 10:37 AM   #2
usererror
Thumbs Must Hurt
 
Join Date: Jul 2007
Location: Petoskey, MI
Model: 8530
OS: Win 7
PIN: N/A
Carrier: Verizon Droid
Posts: 95
Default

This is on version 4.x? I know there is a way to do it, just don't remember. have you tried right clicking on the column headings? I had added/removed some of the columns on my view, but now I'm up on BES 5.0
Offline  
Old 08-11-2009, 11:49 AM   #3
juwaack68
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,878
Default

What kind of database are you using? Remote SQL or local MSDE? I use a tool called Query Express. It's free and a 1 file application (which is wonderful). I have it installed on my own PC to access the BES that has the remote SQL database, and locally on the 3 BES servers I have using MSDE.

I then run this query to find device information, including when the user's account was created on the BES:

Code:
select 
 a.DisplayName,
 c.ModelName,
 c.PhoneNumber,
 c.PIN,
 c.HomeNetwork,
 convert(varchar(10),a.CreationTime, 101)CreationDate,
 convert(varchar(10),a.ActivationTime, 101)ActivationDate, 
 b.MsgsForwarded,
 b.MsgsSent,
 convert(varchar(10),b.LastFwdTime, 101)LastFwdDate,
 convert(varchar(10),b.LastSentTime, 101)LastSentDate
 from userconfig a, userstats b, vHandheldSummaryInfo c
 where a.id = b.userconfigid and a.displayname = c.displayname
 order by a.displayname
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 08-14-2009, 09:02 AM   #4
KOR
CrackBerry Addict
 
KOR's Avatar
 
Join Date: Sep 2005
Model: None
Carrier: Typhoid Mary
Posts: 612
Default

I'm curious - what is he/she going to do with the information? I can understand a user list, usage stats, etc., but when they were added to BES?
Offline  
Old 08-14-2009, 09:14 AM   #5
DavidAdams
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Default

I would guess audit purposes, of the show me the when they joined and the associated approval for same.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 08-17-2009, 08:23 AM   #6
noeffectx
CrackBerry Addict
 
noeffectx's Avatar
 
Join Date: Apr 2006
Location: nyc & pt. pleasant beach, nj
Model: 8320
PIN: 123456
Carrier: T-mobile
Posts: 565
Default

Quote:
Originally Posted by KOR View Post
I'm curious - what is he/she going to do with the information? I can understand a user list, usage stats, etc., but when they were added to BES?
My company pay's the employee $50 a month if their on the BES. Problem is a lot of users are saying their on bes for several months now and didn't got paid the right amount.
__________________
Exchange 2007
BES 4.1.6.9

http://www.flickr.com/groups/blackberry/
Offline  
Old 08-17-2009, 08:25 AM   #7
noeffectx
CrackBerry Addict
 
noeffectx's Avatar
 
Join Date: Apr 2006
Location: nyc & pt. pleasant beach, nj
Model: 8320
PIN: 123456
Carrier: T-mobile
Posts: 565
Default

Quote:
Originally Posted by juwaack68 View Post
What kind of database are you using? Remote SQL or local MSDE? I use a tool called Query Express. It's free and a 1 file application (which is wonderful). I have it installed on my own PC to access the BES that has the remote SQL database, and locally on the 3 BES servers I have using MSDE.

I then run this query to find device information, including when the user's account was created on the BES:

Code:
select 
 a.DisplayName,
 c.ModelName,
 c.PhoneNumber,
 c.PIN,
 c.HomeNetwork,
 convert(varchar(10),a.CreationTime, 101)CreationDate,
 convert(varchar(10),a.ActivationTime, 101)ActivationDate, 
 b.MsgsForwarded,
 b.MsgsSent,
 convert(varchar(10),b.LastFwdTime, 101)LastFwdDate,
 convert(varchar(10),b.LastSentTime, 101)LastSentDate
 from userconfig a, userstats b, vHandheldSummaryInfo c
 where a.id = b.userconfigid and a.displayname = c.displayname
 order by a.displayname

Remote MSSQL - Going to try QUERY Express later. Will give you an update. Thanks
__________________
Exchange 2007
BES 4.1.6.9

http://www.flickr.com/groups/blackberry/
Offline  
Old 08-17-2009, 08:38 AM   #8
juwaack68
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,878
Default

Quote:
Originally Posted by noeffectx View Post
My company pay's the employee $50 a month if their on the BES. Problem is a lot of users are saying their on bes for several months now and didn't got paid the right amount.
Just keep in mind that if a user is removed/re-added on the BES (for troubleshooting purposes, perhaps), then the creation date changes to date they were re-added.

Do you have another way to track when someone gets added - like via a Helpdesk ticket/request?
__________________
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


4 Count Case GE ProLine 2 Bulb 120V T12 Electronic Fluorescent Light Ballasts picture

4 Count Case GE ProLine 2 Bulb 120V T12 Electronic Fluorescent Light Ballasts

$49.99



Sylvania Quicktronic Pro Series Ballast QHE 2X59T8/UNV ISN-SC picture

Sylvania Quicktronic Pro Series Ballast QHE 2X59T8/UNV ISN-SC

$10.00



Philips ADVANCE AmbiStar RELB-2S40-N Replacement Ballast 40-Watt 2-Lamp T12 picture

Philips ADVANCE AmbiStar RELB-2S40-N Replacement Ballast 40-Watt 2-Lamp T12

$18.79



EnergyPro 2 Lamp T8 Rapid Start Electronic Ballast Model SLE-232-120-LPF picture

EnergyPro 2 Lamp T8 Rapid Start Electronic Ballast Model SLE-232-120-LPF

$8.39



Fulham Pony Solid State electronic ballast picture

Fulham Pony Solid State electronic ballast

$15.00



3 or 4 Lamp Electronic Ballast For Fluorescent Lamps - PHILIPS-ICN4P32N-10 picture

3 or 4 Lamp Electronic Ballast For Fluorescent Lamps - PHILIPS-ICN4P32N-10

$132.67







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