BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-20-2008, 11:38 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2006
Model: 8100
Carrier: T-Mobile, Sprint and Verizon
Posts: 95
Post Thanks: 1
Thanked 0 Times in 0 Posts
Question See when activation codes will expire

Please Login to Remove!

Is it possible to see when users activation passwords will expire and whether they have tried to use them. We have a large number of users who just got new phones and I want to make sure they have activated them, so I thought I could look to see if they have an outstanding code.
Offline  
Old 08-21-2008, 12:07 AM   #2 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Try to set it again. If it hasn't been activated, it will show a password (first field only) and how many hours are left. If it has been activated or has expired, it will display as if you were setting a new one (48 hours and blank fields).
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 08-21-2008, 12:52 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2006
Model: 8100
Carrier: T-Mobile, Sprint and Verizon
Posts: 95
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default

Wirelessly posted

Any other options if you have a bunch of users and don't want to open each one. I was hoping for a view.
__________________
Sprint 8530
Offline  
Old 08-22-2008, 11:05 PM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Jun 2005
Location: Philly
Model: Z10
OS: BES 10.1
Carrier: AT&T
Posts: 150
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default

You can get this from the configuration database. You'd have to write a query to pull the data directly from SQL. If want a sample send me a private message and I'll give you a sample query.
Offline  
Old 08-23-2008, 07:00 PM   #5 (permalink)
CrackBerry Addict
 
qc_metal's Avatar
 
Join Date: Mar 2005
Location: Rockford, IL
Model: 9530
OS: 4.7.x
Carrier: Verizon
Posts: 590
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Code:
SELECT dbo.UserConfig.DisplayName, dbo.UserConfig.UserName, dbo.UserConfig.PIN, dbo.UserConfig.KeyGenExpiryTime, dbo.UserConfig.KeyGenMaxAttempts, dbo.UserConfig.KeyGenPassword, dbo.UserConfig.KeyGenNumAttempts, dbo.UserConfig.KeyGenState FROM dbo.UserConfig WHERE keygenexpirytime > GETDATE()
Great (and useful) query!
__________________
Provision, maintain, and report on users via web: the NEW BerryStats | FAQ

Last edited by qc_metal : 08-23-2008 at 10:25 PM.
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





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