Thank you so much! I actually ended up downloading the BRK Admin tool and was able to got it that way, but I greatly appreciate this as another option.
Doreen Moller Global Mobility Services 908-473-3627 mobility.merck.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Charles A Ransom Sent: Thursday, June 24, 2010 11:32 AM To: etc. A list for BES Admin's to discuss issues Subject: Re: [Bes-admins] Reporting Tool for BES 4.1.6 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" <[email protected]> 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 [email protected] 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 Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station, New Jersey, USA 08889), and/or its affiliates Direct contact information for affiliates is available at http://www.merck.com/contact/contacts.html) that may be confidential, proprietary copyrighted and/or legally privileged. It is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please notify us immediately by reply e-mail and then delete it from your system. _______________________________________________ Bes-Admins mailing list [email protected] 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
