Microsoft Identity Manager, Exporting last modified date from metaverse

Question

I have a SQL Server database connected to my metaverse and would like to populate a column in that database with the date when an export runs against one of the records in that database. I can see MIM tracks the last modify date of each attribute of a metaverse object, but am stumped how to simply write to that DB column whenever I have an export for any joined object in that DB.

Anyone done this before in the Sync Service, or is this something I might have to achieve using the MIM Service?

Any other ideas?

Background Info:

• 1x MIM 2016 SP2 Synchronisation Service
• Connected SQL Database is SQL Server 2017 Enterprise
• Projections + Joins work with rows in the database fine

Thanks!
Stefano

Answer 1

Hi,

If you have a custom SQL Connector, you can modify the connector to always update the column to the current DateTime.

But perhaps easier - if you have control over the SQL Database, add a trigger that updates the column every time there is an update to the row.
Then you don't have to involve MIM (unless you want to).

Br,
Leo