Extract "Row Errors" in FIM using SQL query. RRS feed

  • Question

  • Hi, Good afternoon,

    Referring to Sync Service Manager console, how can i extract/copy all the errors shown in "Row Errors" (after a failed MA run) using SQL? (SQL is used in FIM backend for db).
    There were a few tables inside the database such as the "dbo.mms_Connectorspace", "dbo.mms_Management_Agent" etc, but i could not identify which one would contain the "Row Errors" info that i need.

    Thanks in advance!



    Saturday, September 24, 2016 7:43 AM

All replies

  • r0m3II

    If you are referring to the import or export errors during MA runs, you can get this by right clicking on the MA and changing dropdown to either export errors or import errors, you can both sort this field and multi select it to export to notepad, Excel, etc..............

    if you are referring to sync errors during either delta or full synchronization run profile, you can get them from SQL, I believe you can get tihs from the column statistics_type in the table


    Monday, September 26, 2016 5:05 AM