locked
How do I query the "User State Recovery Key" in SCCM 2012 RRS feed

  • Question

  • The same issue was solved in SCCM 2007 by referencing

    http://social.technet.microsoft.com/Forums/systemcenter/en-US/ac1fc092-ee92-441f-b56f-56d05a146b72/how-can-i-view-the-usmt-recovery-key-in-sql-report?forum=configmgrreporting

    But for SCCM 2012, "StateEncryptDecryptKey" key is too long and does not match the "User State Recovery Key".

    So how do I pull the "User State Recovery Key" without using the SCCM Console?

    Thank you,


    Friday, May 2, 2014 8:30 PM

All replies

  • You can view the key directly from the console :

    Open Assets and Compliance - User State Migration
    Right Click on a Machine
    Click "View Recovery Information"

    You will see the recovery key at the bottom of the window.


    Benoit Lecours | Blog: System Center Dudes

    Tuesday, May 20, 2014 7:27 PM
  • You can view the key directly from the console :

    Open Assets and Compliance - User State Migration
    Right Click on a Machine
    Click "View Recovery Information"

    You will see the recovery key at the bottom of the window.


    Benoit Lecours | Blog: System Center Dudes

    Unfortunately this does not answer my question: So how do I pull the "User State Recovery Key" without using the SCCM Console?

    I am starting to think that this is not possible.

    Thank you.

    Wednesday, May 21, 2014 12:05 PM
  • I've check the following views and there's no sign of the "User State Recovery Key".

    v_StateMigration
    v_UserStateMigration
    dbo.StateMigration

    The StateEncryptDecryptKey is available from dbo.StateMigration but not the "User State Recovery Key". This key is probably encrypted for security reason.

    Sorry for not answering your question but I don't think that you can directly query this information from the DB.


    Benoit Lecours | Blog: System Center Dudes

    Wednesday, May 21, 2014 12:41 PM