1 Reply Latest reply on Jan 24, 2017 11:53 AM by ctlswadmin

    NCM Event Report

    bharris

      I was wondering if anyone knew how to write a report that includes the data on the NCM Config Summary page?

      I tried to search for an NCM event field in the Report Writer (Web and Thick Client) and I was unable to find anything.  I want to create a report that filters and only shows entries with a FAILED status.

        • Re: NCM Event Report
          ctlswadmin

          Try the query below, adjust the date parameter to filter the data.

           

          Select DateTime, UserName,Type AS Status, Action,Details

          From NCM_Audit

          Where DateTime < DATEADD(DAY,-14, GETDATE())

          1 of 1 people found this helpful