This might work - it should give you the User's name, their PIN, the e-mail address, and some stats.
<SNIP> USE BESMgmt SELECT UserConfig.DisplayName, UserConfig.PIN, UserConfig.MailboxSMTPAddr, UserStats.LastFwdTime, UserStats.LastSentTime, UserConfig.CreationTime FROM [BESMgmt].[dbo].[UserConfig], [BESMgmt].[dbo].[UserStats] WHERE UserConfig.Id=UserStats.UserConfigID Order by LastFwdTime; <SNIP> >>> "Moller, Doreen" <doreen.mol...@merck.com> 6/23/2010 1:14 PM >>> Right now I am not familiar with using Sql OR BRK and need to export username and email address by today. Trying to figure out how to do it? _______________________________________________ Bes-Admins mailing list Bes-Admins@dataoutages.com http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins --------------------------------- Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com