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



Reply
LinkBack Thread Tools Display Modes
Looking for a script / shortcut ...
 
  #1 (permalink)  
Old 01-11-2009, 08:37 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default Looking for a script / shortcut ...

If you're looking for a script / shortcut, post what you're looking to do / help make easy ... you're probably not the only one out there wanting the same thing!

I'm certainly interested in knowing ... and if I can help I'd love to write a shortcut to make it happen!
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 10-30-2009, 05:57 AM
Ryne's Avatar
BES Activated
 
Join Date: Oct 2009
Location: Canada
Posts: 5
Default SQL Script - How To Check DB for BIS Users

-- Change the '%@BES_Domain.com%'to the current working BES domain to omit thoes from the results


SELECT count(dbo.UserConfig.Id), dbo.UserConfig.DisplayName
FROM dbo.UserConfig INNER JOIN
dbo.SyncDeviceMgmt ON dbo.UserConfig.Id = dbo.SyncDeviceMgmt.UserConfigId
WHERE dbo.SyncDeviceMgmt.data like '%@%' and syncdevicemgmt.id not in
(select id from syncdevicemgmt where dbo.SyncDeviceMgmt.Data LIKE '%@BES_Domain.com%')
Group by dbo.UserConfig.DisplayName
Attached Files
File Type: rar SQL How To Check DB for BIS Users.rar (381 Bytes, 123 views)
Reply With Quote
  #3 (permalink)  
Old 10-30-2009, 06:00 AM
Ryne's Avatar
BES Activated
 
Join Date: Oct 2009
Location: Canada
Posts: 5
Default SQL Script - How To Clear a users Autosignature

Update userconfig set AutoSignature = NULL where id = '428'
Attached Files
File Type: rar SQL How To Clear a users Autosignature.rar (169 Bytes, 97 views)
Reply With Quote
  #4 (permalink)  
Old 10-13-2010, 07:07 PM
BES Activated
 
Join Date: Oct 2010
Posts: 1
Default

I have a powershell script that queries the BES database and checks if the accounts are disabled in AD. What I'm looking for now is a way to delete the user from BES based on the information returned from the script. How can I delete a user via a script from the database?
Reply With Quote
  #5 (permalink)  
Old 04-25-2011, 04:10 PM
BES Activated
 
Join Date: Apr 2011
Posts: 4
Default

Quote:
Originally Posted by msfrod View Post
I have a powershell script that queries the BES database and checks if the accounts are disabled in AD. What I'm looking for now is a way to delete the user from BES based on the information returned from the script. How can I delete a user via a script from the database?
I can't help with the deletion part but would really like to take a look at what you have. It would help me a ton!

-sbaker
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
bes 5.04 script needed unreal1171 Scripts & Tools / Hints & Tricks 1 04-04-2015 12:20 PM
PS Script for BES Account Status Gawl Scripts & Tools / Hints & Tricks 3 03-18-2014 08:50 AM
RSA pushtoken script or app PacketRat Scripts & Tools / Hints & Tricks 1 07-13-2011 12:28 PM
Script to Zip Log Files Sith_Apprentice Scripts & Tools / Hints & Tricks 3 07-15-2009 04:06 PM


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


 

SEO by vBSEO 3.3.2 PL2