Skip to Content
Jul 26, 2012 at 07:51 PM

Pivot Identity Data?


I'm wondering anyone knows a SQL based method of pivoting the information in the Identity Store (as held in say, idmv_value_ext_active) to a more usable format.

I've looked at the SQL Server pivot command but it does not seem to apply.

The only other way I can think of to do this is to virtualize the Identity Store via VDS and then read the data in a From LDAP pass, but I'd prefer to do this without the extra moving parts...

Thanks for your help!