How to find count of public folders in an exchange environment from SystemCentreReporting DB?

[Daniel]

Hi,

I need to write a SQL query to find the count/list of public folders
in an exchange environment form SystemCentreReporting (MOM 2005). Like
wise sql queries to find count/list of servers in an exchange
environment. Can you please help me where/how to find these data from
SystemCentreReporting database.

Thanks,
Daniel Felix.

[Anders Bengtsson [MVP]]

Hi Daniel,

Have you looked at the default rules and see if there is anyone that you
can use as a foundation? Also look at the mailserver to see if there is a
performance counter showing number of public folders, then you can use a
simple performance report.

--
Anders Bengtsson
Microsoft MVP - Operations Manager
Microsoft Certified Trainer (MCT)
http://www.contoso.se

[Hakim@discussions.microsoft.com Abdul Hakim]

Hi Andres,

Can you please elaborate what you mentioned?

Because, I have the same requirement as Daniel requested. I need to get
report of existing Public folder and if new public folder created in ORG.

Thanks in advance,
Abdul Hakim T

[Anders Bengtsson [MVP]]

Hi Abdul,

Is it exchange 2007? Then you can get it with power shell, and export the
result to Excel for example. If you want to audit when new public folders
are created I thjink you have raise the log level of your exchange machine
and then pickup the events generate by exchange when creating new public
folders. You can then create a report that list all these events.

[Abdul Hakim]

Hello Andres,

Great your are right It's Exchange 2007 ORG only.

I want to get the details using MOM 2005 Exchange 2007 Mgmt pack and
generate report as follows:
1. No. of Exchange servers (HUB, CAS, UM)
2. No. of Public folders
3. No. of Mailbox server (CCR, LCR, SCR)
4. No. of Mailbox
5. No. of DL
6. No. of users
7. No. of OWA (Users session - hourly basis)
8. No. of ISA servers
9. No. of ISA server Users hit for OWA, outlook anyhwhere hourly basis

Thanks in advance !

[Anders Bengtsson [MVP]]

Hi Abdul,

All that you can get from power shell in Exchange 2007, I dont know the exact
command, sorry, but I guess you can find it in a power shell group or if
you google it.

[Abdul Hakim]

Hi Andres,

Thanks for your prompt response :)

Abdul Hakim