Can Powershell insert mailbox size query results into SQL?
Posted on 2011-10-27
I have a little status webpage that I use to display a couple of different things. Sort of like a system monitoring webpage. I'd like to display the number of items in my journalling mailbox on that webpage. It would be great if the server-side code (.net) could ask the Exchange 2007 for that info directly, but it sounds very complicated.
The alternative thought was to have a scheduled task run a powershell script that pulls the data and inserts it into a database for my page to read.
What do you think? If it's the latter idea, how do I do it?
Thanks for the help!