BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 03-23-2010, 09:31 AM   #1
Mikey_AGBoston
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
Default PIN Lookups with DOMINO

Please Login to Remove!

Anyone familiar of a method within a Domino environment to lookup PIN numbers?
__________________
BES: 5.0.2, SQL 2005 (remote)/ WIN2K8,R2 / EXCHANGE 2010, RTM+RU4
Offline  
Old 03-23-2010, 09:54 AM   #2
noname
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Default

I think this is built-in already for those BlackBerry users within the BlackBerry Domain.

For examples:-

(1) If you lookup a user that also has a BlackBerry account in the BlackBerry Domain (aka BESMgmt DB) that you belongs, then PIN number is populated in the record returned.

(2) If you lookup a user that does not has a BlackBerry account in the BlackBerry Domain that you belongs, then no PIN number is returned.

Above are from my observations. Others may have more information.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.

Last edited by noname; 03-23-2010 at 09:56 AM..
Offline  
Old 03-23-2010, 09:59 AM   #3
Mikey_AGBoston
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
Default

We're not getting PINs returned.
I called Blackberry support, many times.. spoke to different engineers.
Each told me: This can't be done.
Please... any idea how you're doing this?
__________________
BES: 5.0.2, SQL 2005 (remote)/ WIN2K8,R2 / EXCHANGE 2010, RTM+RU4
Offline  
Old 03-23-2010, 10:08 AM   #4
noname
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Default

Above are from my observations. Others may have more information.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 03-23-2010, 12:30 PM   #5
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Default

Quote:
Originally Posted by noname View Post
Above are from my observations. Others may have more information.
Your statement is correct. I think the PIN is coming from SQL.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 03-23-2010, 12:42 PM   #6
Mikey_AGBoston
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
Default

Yes, I understand I can get the PINs out of the SQL database, by:

use BESMgmt
go

select
DisplayName,
UserName,
PIN
from UserConfig
go

BUT, I do not understand why I can not Look up PINs
Is it a BES version issue, Domino version issue...
Handheld OS issue? Or simply because the PIN field isn't within the BES/Domino servers NAB?
__________________
BES: 5.0.2, SQL 2005 (remote)/ WIN2K8,R2 / EXCHANGE 2010, RTM+RU4
Offline  
Old 03-23-2010, 01:34 PM   #7
BB1877
Thumbs Must Hurt
 
BB1877's Avatar
 
Join Date: Feb 2005
Location: oHIo
Model: 9930
Carrier: Verizon
Posts: 163
Default

@Mikey_AGBoston...What's your Domino version? PINs appear on our Lookups as well, with Windows 2003 R2 SP2, remote SQL 2005, BES 4.1.6.55 on Domino 6.5.4 FP2.

Range of handheld OS (4.0 and higher, doesn't matter). I guess during the Chile earthquake our users down there were using BlackBerry PIN for communication when not much else worked.
__________________
BES 2.2.3.11 5/19/04 until 8/31/10 RETIRED
BES 4.1.6.55/Domino 6.5.4 FP2 580 users RETIRED
BES 5.0.1/Domino 8.5.1 223 users RETIRED
Offline  
Old 03-24-2010, 05:08 AM   #8
erpam
Knows Where the Search Button Is
 
Join Date: Jan 2007
Location: Rome - ITALY
Model: 8900
Carrier: Vodafone
Posts: 28
Default

Like others havesaid, the Lookup function automatically returns the PIN along with the other contact data. There is nothing to configure.

It works both when you perform a Lookup in the Contacts app and also when you choose Compose PIN from the email app, type the name of the person and choose Lookup.
Offline  
Old 03-24-2010, 08:52 AM   #9
noname
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Default

Unless you are saying you are looking up PIN like this:-

In the Contacts, click "Lookup", enter a <PIN#> and expects a return of result. If so, 100% cannot. Why? Lookup = NotesAPI call to Domino Directory. PIN number is a SQL record in the userconfig table and not part of the Domino data. If you are looking up a contact that is also a BlackBerry user in the BlackBerry Domain, then the BES messaging agent returns the Domino data from the NAMES.NSF and merge the PIN number value from the SQL configuration database.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 03-24-2010, 09:19 AM   #10
Mikey_AGBoston
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
Default

OK - there's my answer. Thank you Sir Topham Hatt.
__________________
BES: 5.0.2, SQL 2005 (remote)/ WIN2K8,R2 / EXCHANGE 2010, RTM+RU4
Offline  
Old 03-24-2010, 09:24 AM   #11
noname
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Default

Np, Mikey_AGBoston. Trying hard to live it up as Thomas has recently been a really useful engine
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Closed Thread



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


1Pcs USED A500 7.5KW 380V FR-A540-7.5K-CH frequency converter picture

1Pcs USED A500 7.5KW 380V FR-A540-7.5K-CH frequency converter

$401.02



1PC USED A54MA55B BC186A413G52 Mitsubishi A500/F540 Series 55KW Drive Board #CZ picture

1PC USED A54MA55B BC186A413G52 Mitsubishi A500/F540 Series 55KW Drive Board #CZ

$317.00



1PC USED A54MA30B Mitsubishi F500/A500/A540 Series 30-37KW Mainboard #CZ picture

1PC USED A54MA30B Mitsubishi F500/A500/A540 Series 30-37KW Mainboard #CZ

$228.00



MITSUBISHI FR-A820 1.5K TFA INVERTER A500 240 V #L-220 picture

MITSUBISHI FR-A820 1.5K TFA INVERTER A500 240 V #L-220

$684.00



Mitsubishi FR-A540-0.75K-NA AC DRIVE INVERTER 1 HP 380-480 VAC 50/60 HZ 4.1 AMP  picture

Mitsubishi FR-A540-0.75K-NA AC DRIVE INVERTER 1 HP 380-480 VAC 50/60 HZ 4.1 AMP

$649.99



1PCS USED A500 7.5KW 380V FR-A540-7.5K-CH picture

1PCS USED A500 7.5KW 380V FR-A540-7.5K-CH

$347.76







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