"Set for Self-enrollment at Next Sign-In option" in SQL Unity Connection 12.5

[Juan Gerardo Hernandez]

Hi everyone,

I am working in a Unity SQL query to see which users have the option "Set for Self-enrollment at Next Sign-In" but I dont see flag boolean in any table.

I know there are reports in where you can get those users automatically, but I am working on a SQL script solution.

Could you please let me know in which table is that boolean?

Pseudocode, this is what I am trying to achieve.

run sql select * from tbl_user where self-enroll = 1 ??

Thank you very much.!

Juan.

[Martin Sloan]

Super late to answer this but came across it while looking for the same and thought I'd drop this here for posterity.  This field is available in vw_subscriber.isvmenrolled.  JOIN as needed!