SCOM - Exchange 2013 Stored Procedure

Pauciloquent 71 Reputation points
2020-08-17T13:57:16.257+00:00

Hi,

I have taken over SCOM environment where Exchange 2010 was being monitored via SCOM 2007. I have already upgraded SCOM to 2019 and Exchange to 2016. Also installed the Exchange 2k3 MP.

Now, in their old environment there was a script running that would export Exchange 2010 transport daily statistics to an Excel file. I have looked at the script; it's using the stored procedure called "[Exchange2010].[Transport-Platform-ServerHourly-Report]". Now, how can I convert the script for Exchange 2016? I have checked the DW DB, there is no Exchange 2013 stored procedures there.

I am not a Powershell guru but do understand what's happening in the script; therefore, figured out, if I can replace a Exch 2010 stored procedure with Exch 2013, I may use the old script.

Can anyone please help me in this regard?

@Leon Laude

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,413 questions
0 comments
Accepted answer
  1. Leon Laude 85,651 Reputation points
    2020-08-18T06:48:09.02+00:00

    Hi @Pauciloquent ,

    The script you mentioned can be located over here Microsoft.Exchange.2010.Reports.Script (DataWarehouseScript).

    Now I believe since the SCOM 2007 and Exchange 2010 are quite old, there have been quite a lot of changes in both the Exchange management pack and the SCOM databases (DB & DW), which makes me pretty confident that this script won't work "as is" and will have to be rewritten.

    The script is quite long and would require some expertise in SQL and Exchange to rewrite, this is not something we can do in these forums unfortunately.
    If you have any DBA/Exchange specialists in your company, you should check with them.

    You could also always ask the subject matter experts in the Exchange and SQL Server forums over here:

    SQL Server forum
    https://learn.microsoft.com/en-us/answers/topics/sql-server-transact-sql.html

    Exchange forum
    https://learn.microsoft.com/en-us/answers/topics/office-exchange-server-administration.html

    ----------

    (If the reply was helpful please don't forget to accept as answer, thank you)

    Best regards,
    Leon

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. SChalakov 10,261 Reputation points MVP
    2020-08-17T14:35:20.347+00:00

    Hi,
    Exchange 2016 is monitored with the Exchange 2013 Management Pack. Here is the link to the management pack itself:

    Microsoft Exchange Server 2013 Management Pack

    Here is also the Microsoft article, which explains why there is no Exchange 2016 MP:

    Monitoring Exchange Server 2016 with System Center Operations Manager

    This being said, you can install, import and configure the Exchange 2013 Management Pack and check what kind of SQL Stored Procedures it leverages. You might also want to check on the following two addendum MPs, which will extend the scope of the MSX 2013 MP and will add some nice features (one of them is the transport queue health):

    SCOM Exchange 2013+ Addendum for Transport Queue Health
    and this also

    Exchange Server 2013 and 2016 Discovery Addendum Management Pack

    =========================================================
    Please don't forget to "Accept Answer" and upvote if the response helped you.
    Stoyan

    1 person found this answer helpful.