Where is the "Prevent Active Directory synchronization for this user" stored in the Project 2010 DB tables? RRS feed

  • Question

  • I would like to create a report from the DB that gives me all users in Project/PWA 2010 where the "Prevent AD sync..." box has been checked in the user/resource configuration, but I cannot find where this is in the Project databases.  Our DB is SQL 2008 R2.


    Marty Hadden

    MS Project Administrator

    Monday, September 15, 2014 2:52 PM

All replies

  • Hi Marty,

    I might be wrong but the Prevent AD Sync details are not available in the Reporting db. Maybe you can check the published/draft databases (not supported) or you can configure a separate custom field and you can duplicate the information for each user into this field. The custom field can be used in the reports based on the reporting database.

    Hope this helps


    Monday, September 15, 2014 3:39 PM
  • Hello Marty

    Paul is correct.  The field is in the published database.  The field is called RES_PREVENT_ADSYNC in the published database.


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Monday, September 15, 2014 7:04 PM