BlackBerry Forums Support Community

Closed Thread
LinkBack Thread Tools
Old 09-29-2010, 05:58 AM   #1 (permalink)
Thumbs Must Hurt
Brendan42's Avatar
Join Date: Mar 2006
Location: London
Model: 8900
Carrier: If I had a choice, a man-bag like Jack on Day-6.
Posts: 165
Post Thanks: 0
Thanked 0 Times in 0 Posts
Lightbulb BES - Finding old unused accounts

Please Login to Remove!

I'm being asked to find old,unused accounts on our BES 5.0.1 environment (on Exchange) in order to ensure licenses are used efficiently. Assuming I don't always get told when someone leaves the company, how can I find this information. I'm hoping for a vbscript or SQL query that will give me a list of "highly-likely they've left" users. I can then confirm on Active Directory. We have over 1200 users, some of whom are on maternity leave etc...

Any help or advice would be greatly appreciated
Better to light a candle than to curse the darkness.
Old 09-29-2010, 07:12 AM   #2 (permalink)
Talking BlackBerry Encyclopedia
cyclmpc's Avatar
Join Date: Nov 2008
Location: DC
Model: 9800
Carrier: ATT
Posts: 217
Post Thanks: 2
Thanked 2 Times in 2 Posts

In your Advanced search for users, you can perform a search on Email Criteria for "Last Contact Date".
I'm actually lost...
Old 10-01-2010, 01:47 PM   #3 (permalink)
CrackBerry Addict
KOR's Avatar
Join Date: Sep 2005
Model: None
Carrier: Typhoid Mary
Posts: 612
Post Thanks: 7
Thanked 2 Times in 2 Posts

Keep in mind that last contact date may also be showing people who have issues with their handhelds and can't connect to BES. We have a small user group so it's easy to keep track of who's left, but it helps me identify problems.
Old 10-01-2010, 03:36 PM   #4 (permalink)
Talking BlackBerry Encyclopedia
RadHaz75's Avatar
Join Date: Feb 2006
Location: Philadelphia
Model: 9650
Carrier: Verizon Wireless
Posts: 456
Post Thanks: 2
Thanked 4 Times in 4 Posts

i do monthly cleanups, anyone who hasnt contacted our server in 30 days gets booted. if they just had their device off i dont see it as that big of a deal to readd and activate them again. plus they r wasting a cal not using the device
Two months ago, I saw a provocative movie on cable TV. It was called The Net, with that girl from the bus.
Old 10-04-2010, 10:47 AM   #5 (permalink)
BlackBerry Elite
knottyrope's Avatar
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,244
Post Thanks: 374
Thanked 383 Times in 353 Posts

After 30 days they get booted here as well.
unlock your phone here

Still rocking my DTEK60
Old 10-04-2010, 11:10 AM   #6 (permalink)
Knows Where the Search Button Is
Join Date: Apr 2010
Model: 9700
Carrier: AT&T
Posts: 30
Post Thanks: 0
Thanked 0 Times in 0 Posts

We were doing that here (removing after 45 days of no contact actually), but stopped as this is now a service deliverable that internal customers pay for. So they stay on until they are termed (we go by an HR report AND a weekly check of accounts) or the customer requests them removed. We provide them a mothly detailed reportt of what is on the BES for their users. Since they are charged per device on the BES, we see requests for removal pretty quickly when a device isn't being used. Usually much more frequently than our old 45 days policy.
Old 10-04-2010, 12:03 PM   #7 (permalink)
Thumbs Must Hurt
Join Date: Sep 2009
Location: Ft. Bragg
Model: 9000
Carrier: ATT
Posts: 67
Post Thanks: 0
Thanked 0 Times in 0 Posts

We do that too, but sit at a 90 day. Technically we aren't supposed to, but as admin, I feel if they haven't talked to the server in 45+ days..... then do they really even want thier BB that bad. We even had a few users that were "forced" to get a device, the minute they got it, put it in a drawer and never used it.... to me that's a waste of time and money. No sence working on someone that doesn't need to be worked on.
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

Samsung CLT-C609S Toner Cartridge CLTC609S
Samsung CLT-C609S Toner Cartridge CLTC609S pictureSamsung MLT-D103S Toner Cartridge MLTD103S
Samsung MLT-D103S Toner Cartridge MLTD103S pictureSamsung CLT-C404S Original Toner Cartridge - Cyan CLTC404S
Samsung CLT-C404S Original Toner Cartridge - Cyan CLTC404S pictureSamsung Sequenom MassARRAY Nanodispenser Used
Samsung Sequenom MassARRAY Nanodispenser Used pictureSamsung iDCS Falcon 28D Black Display Phone
Samsung iDCS Falcon 28D Black Display Phone picture

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