Where are the user-specific settings stored? Reference KBA-35268

Has this changed or where can we find out now where the user specific settings are stored?

We no longer see this file or the location.

https://docuwarekb.microsoftcrmportals.com/en-us/knowledgebase/article/K...

If you read the article carefully it states that the system can store them in the database or the local macine.

The installaion default to the database when I installed it so I imagine that all installations 6.7 and greater would do the same. 

I should look something like the follwing:

 [system].[dbo].[DWUserSettings]

There are 7 fields

The settings are stored in the settings column and look like this 

<UserApplicationPreferences guid="30qq3c9a-a660-4c52-8ebf-6e88f3ff2b90" Name="Default" uid="5"><Preferences>&lt;?xml version="1.0" encoding="utf-16"?&gt;
&lt;ApplicationPreferencesHolder xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://dev.docuware.com/schema/public/services/platform"&gt;
  &lt;AppPrefs xsi:type="WebClientPreferences"&gt;
    &lt;WorkAreas&gt;
      &lt;ContentAreas xsi:type="BasketAreaPreferences" AreaType="Basket" SelectedInstanceIndex="-1" /&gt;
      &lt;ContentAreas AreaType="Search" SelectedInstanceIndex="-1"&gt;
        &lt;Instances ID="dfc29c1b-4b1d-4da4-bd54-3dd49f22ac32" /&gt;
      &lt;/ContentAreas&gt;
      &lt;ContentAreas AreaType="Workflow" SelectedInstanceIndex="-1" /&gt;
    &lt;/WorkAreas&gt;
    &lt;GeneralSettings /&gt;
    &lt;RegionalSettings /&gt;
    &lt;WebClientLayout Mode="AllInOne" /&gt;
    &lt;Favorites&gt;
      &lt;Baskets /&gt;
      &lt;StoreDialogs /&gt;
      &lt;SearchDialogs /&gt;
      &lt;TaskLists /&gt;
      &lt;MultiFCSearches /&gt;
    &lt;/Favorites&gt;
    &lt;Viewer LeftToolbarState="Collapsed" RightToolbarState="Expanded" ExpandStatusbar="false"&gt;
      &lt;Annotations /&gt;
      &lt;Toolbars&gt;
        &lt;Toolbar Type="Navigation" Position="Left" Visibility="NotVisible"&gt;
          &lt;Controls&gt;
            &lt;ToolbarControl Type="Nav_DocumentNumber" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_FirstDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_PreviousDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_NextDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_LastDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_FileNumber" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_FirstFile" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_PreviousFile" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_NextFile" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_LastFile" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_PageNumber" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_FirstPage" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_PreviousPage" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_NextPage" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Nav_LastPage" Checked="true" State="None" /&gt;
          &lt;/Controls&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="Tools" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls&gt;
            &lt;ToolbarControl Type="Tools_Save" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_Edit" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_PrintDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_SendDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_ShowDocumentInformation" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_ShowDocumentOverview" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_FulltextSearch" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_FulltextSearchContinue" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_TextAnnotation" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_Checksum" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_Download" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_PointAndShoot" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_ShootToClipboard" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Tools_WorkflowHistory" Checked="true" State="None" /&gt;
          &lt;/Controls&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="Display" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls&gt;
            &lt;ToolbarControl Type="Display_FitToWidth" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_FitToWidthNoMargins" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_FullDocument" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ZoomIn" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ZoomOut" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ZoomNumber" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_MagnifyingGlass" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_DisplayEnhancement" Checked="true" State="Toggled" /&gt;
            &lt;ToolbarControl Type="Display_Invert" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_RotateLeft" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_RotateRight" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_SaveRotation" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ImageEnhancement" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_MergeLayers" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay1" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay2" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay3" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay4" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Display_ShowOverlay5" Checked="false" State="None" /&gt;
          &lt;/Controls&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="Stamps" Position="Left" Visibility="NotVisible"&gt;
          &lt;Controls /&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="Annotations" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls&gt;
            &lt;ToolbarControl Type="Annotations_Select" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Delete" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Text" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Marker" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Line" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_FreehandLine" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Arrow" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Rectangle" Checked="true" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_Ellipse" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_FilledEllipse" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_FilledRectangle" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_TransparentEllipse" Checked="false" State="None" /&gt;
            &lt;ToolbarControl Type="Annotations_TransparentRectangle" Checked="false" State="None" /&gt;
          &lt;/Controls&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="DocOverview" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls /&gt;
        &lt;/Toolbar&gt;
        &lt;Toolbar Type="DocLinks" Position="Left" Visibility="Expanded"&gt;
          &lt;Controls /&gt;
        &lt;/Toolbar&gt;
      &lt;/Toolbars&gt;
    &lt;/Viewer&gt;
    &lt;MultiFCSearches /&gt;
  &lt;/AppPrefs&gt;
&lt;/ApplicationPreferencesHolder&gt;</Preferences></UserApplicationPreferences>

querey the data as follows:

SELECT [USetID]
      ,[uid]
      ,[admin]
      ,[type]
      ,[settings]
      ,[guid]
      ,[checksum]
  FROM [system].[dbo].[DWUserSettings]

The user data needs to be linked  with [dbo].[DWUser] and [dbo].[DWUserIdentity] to get all the data in one place.

Maybe I should have referenced the original article but the corresponding links are bad and not working. 
https://docuwarekb.microsoftcrmportals.com/en-us/knowledgebase/article/K...

I am just trying to understand the easiest way to determine if the settings are stored in the local storage of the browser or in the database as the kb indicates and it states that you should be abe to determine this by reviewing the "C:\Program Files (x86)\DocuWare\Web\Platform\Web.config"

But that file location does not exist. So does that mean it is being stored in the database?

If the user settings are stored in the database:

1. Create a backup of your DWSystem database
2. Go to table DWSystem.DWUser and find the UID of the affected user. 
3. Go to table DWSystem.DWUsersettings and delete all Rows with the UID of the affected user. 

I have a feeling that you will find them there...you will want to compare the 3 databases to see which GUID you need to remove.