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/

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.

-- 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

SQL How To Check DB for BIS Users.rar (381 Bytes, 25 views)

Update userconfig set AutoSignature = NULL where id = '428'

Attached Files

SQL How To Clear a users Autosignature.rar (169 Bytes, 13 views)