Would like to do a SQL Query against connector spaces.

Kilgore, Bill (US) 0 Reputation points
2025-04-21T15:36:43.0166667+00:00

We are switching to a new datasource that will create several thousand updates to the metaverse and to outbound connector spaces - one being active directory. Is there any way we can query the AD connector space so get a full view of the pending changes, prior to running an export?

Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
839 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Leo Erlandsson 1,661 Reputation points
    2025-04-25T06:39:43.67+00:00

    Sure, but don't do it using a SQL query.

    There are several ways:

    • Search the Connector Space in the MIM Sync Client and select "Pending Export" to view the pending changes
    • Do an Export with a "Drop File", and check the file
    • Use LithNet MIIS PowerShell to view the changes:

    Br,

    Leo

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.