none
Getting SCOM Diagnostic Tasks Result

    Question

  • Hi Experts,

    How to get SCOM diagnostic task output/results configured in custom monitor as for historical data?

    Diagnostic task: Top 10 Processes consuming CPU

    Any help would be greatly appreciated!





    • Edited by Shianx Thursday, February 7, 2019 2:26 PM
    Thursday, February 7, 2019 2:16 PM

All replies

  • Hi

    I'm not sure I understand the question. You want to feed the output of your diagnostics task to a monitor for historic data? What does that mean?

    Cheers


    Sam (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" wherever applicable. Thanks!) Blog:AnalyticOps Insights Twitter:Sameer Mhaisekar

    Thursday, February 7, 2019 3:25 PM
  • Hello,

    Apologies for the confusion.. The scenario is, there's a created custom monitor for CPU utilization and manually added/configured the diagnostic task (The Top processes consuming CPU). When the alert triggered, this diagnostic task output of display in health explorer. Are these results/output stored in DW? if so how can we extract or pull out these information and the history.

    Thank you,


    shanx

    • Edited by Shianx Thursday, February 7, 2019 4:21 PM
    Thursday, February 7, 2019 4:20 PM
  • Hi,

    We may try the following to see if it works.

    SELECT d.[Name], d.[DisplayName],
           b.[StateChangeEventId],
           b.[TargetObjectId],
           b.[SubmittedBy],
           b.[Status],[Output],[ErrorCode],[ErrorMessage],[TimeScheduled],[TimeStarted],[TimeFinished],
           b.[LastModified],
           b.[LastModifiedTimestamp]
    FROM [OperationsManager].[dbo].[DiagnosticJobStatusView] b , [OperationsManager].[dbo].[DiagnosticView] d
    WHERE b.[DiagnosticId] = d.Id

    This apply to DataWarehouse either.

    Hope the above information helps.

    Regards,

    Alex Zhu
    -----------------------------------------------
    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
    Friday, February 8, 2019 9:05 AM
  • Thank you Alex for the response. I haven't tried it yet. Can this also fetch the diagnostic data in custom monitor which configured as putting PS script in diagnostic task?

    Thank you in advance. :-)

    Shanx

    • Edited by Shianx Sunday, February 10, 2019 9:55 AM
    Sunday, February 10, 2019 9:55 AM
  • Hi,

    As far as I know, it can. Thanks.

    Regards,

    Alex Zhu
    -----------------------------------------------
    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
    Monday, February 11, 2019 7:39 AM
  • Hi,

    May we know the current status of the problem? Is there any other assistance we can provide?

    Regards,

    Alex Zhu
    -----------------------------------------------
    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
    Thursday, February 14, 2019 7:12 AM