Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
SQL script to find users' device free memory
 
  #1 (permalink)  
Old 12-02-2008, 05:02 PM
Joolie's Avatar
Super Moderator
 
Join Date: Dec 2008
Location: West Michigan
Posts: 763
Default SQL script to find users' device free memory

One script I run every now and then is one to check device free space - and if I'm in a really good mood I might even warn users with low space that their device could crash at any moment.

Remember only use 'select' in this statement so as not to potentially cause harm to your BESMgmt database.

Code:
select  
 b.DisplayName,
 convert(int, substring(a.data, patindex('%3>%',a.Data)+2, patindex('%</t3>%',a.data) - patindex('%3>%',a.Data) - 2))
from [dbo].syncdevicemgmt a, [dbo].UserConfig b
where a.tableid ='5' and a.userconfigid = b.id
order by 2
__________________
You may know me as Juwaack68
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-02-2008, 07:50 PM
John Clark's Avatar
BES Guru
 
Join Date: Dec 2008
Posts: 589
Default

What a nice Admin you are...
Reply With Quote
  #3 (permalink)  
Old 12-02-2008, 08:26 PM
Joolie's Avatar
Super Moderator
 
Join Date: Dec 2008
Location: West Michigan
Posts: 763
Default

Don't tell.
__________________
You may know me as Juwaack68
Reply With Quote
  #4 (permalink)  
Old 12-02-2008, 09:46 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default

Great one!
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
  #5 (permalink)  
Old 01-31-2009, 09:44 AM
BES Activated
 
Join Date: Jan 2009
Location: New York City
Posts: 2
Default

Probably a good idea to mention that a "read only" sql account should be created for reporting, to minimize any chance of unintentionally modifying the DB Better yet, use a backup of the DB

Just trying to keep the new admins out of trouble
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Script - Check users with TimeZone records on their devices noname Scripts & Tools / Hints & Tricks 0 11-17-2010 05:01 AM
KB15768 - Free memory is used up when an application is pushed to the BlackBerry HH hdawg Featured BlackBerry KB Articles 0 09-12-2009 12:33 PM
NEEDED: SQL script bes users per exchange server RadHaz75 Scripts & Tools / Hints & Tricks 10 08-01-2009 08:48 AM
Encryption of external memory device Marcus Port 3101: The BES Admin Bar & Grill 5 05-28-2009 05:20 PM
KB15674 - Free and Busy lookups do not work for users in an Exchange 2003/2007 mix .. hdawg Featured BlackBerry KB Articles 0 05-26-2009 01:21 PM


All times are GMT -4. The time now is 04:56 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2