# Auto mapping Auto Mapping is the feature of KONNEKT, that automatically maps all SharePoint Online sites & document libraries into the users Windows File Explorer (and other file dialogues). Only sites & libraries, the user has access to, are mapped. Administrators can control this feature on two levels: 1. Site level 2. Library level KONNEKT updates the mappings every 60 minutes. {% hint style="info" %} KONNEKT uses SharePoint Online Search's default 'Result Source.' Modifying this setting could alter the Site Collections and Document Libraries displayed. {% endhint %} ## Site scope {% hint style="info" %} This policy is applicable to version 2.0 and above {% endhint %} {% hint style="info" %} By default KONNEKT will map all team and communication sites and subsites the user has access to. Private channels of Teams are not in the default site scope. **If you are fine with that, you do not need to use this policy.** {% endhint %} ### **Policy** Definition * **Policy Name (ADMX):** `Sharepoint Sites Query` This policy enables you to define the query string used to find SharePoint sites. The site query needs to be expressed in KQL. You can find general KQL documentation here: A list of query properties for SharePoint can be found here: You can test your KQL site query at this SharePoint Online URL: ``` https://.sharepoint.com/_layouts/15/osssearchresults.aspx ``` In the following paragraphs, you can find some examples for KQL query strings. ### Default If you do not configure this policy, KONNEKT will use the following default KQL query: ``` (webtemplate:STS OR webtemplate:GROUP OR webtemplate:SITEPAGEPUBLISHING) AND (contentclass=STS_Site OR contentclass=STS_Web) ``` This will map all team and communication sites, the user has access to. Private channels of Teams are not in the default site scope ![](https://2727108687-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8zLVuKYctMIUr68_fs%2Fuploads%2F87HL5sVuHXRgZXFF8DXC%2Fsharepoint%20site%20query%20policy.png?alt=media\&token=171fb103-fc4f-4dd5-8c11-c5f4b74009dd) ### Examples #### Sites whitelisting
Filter on site name/title `Title=""` **Query String** to map only the sites "Give" and "Leadership" ``` (webtemplate:STS OR webtemplate:GROUP OR webtemplate:SITEPAGEPUBLISHING) AND (contentclass=STS_Site OR contentclass=STS_Web) AND (title="Give" OR title="Leadership") ``` **Note:** restarting KONNEKT is required to apply the policy
![](https://2727108687-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8zLVuKYctMIUr68_fs%2Fuploads%2F8eyPohzXscLFaMW94wd2%2FKONNEKTQueryPolicy.png?alt=media\&token=0c61557a-b104-4f0d-8d43-6f43a851561f) {% hint style="info" %} **Note:** To show all sites with \ in the name, use the operator **(:)** instead of **(=)** by title {% endhint %} #### Sites whitelisting using \* operator
Filter on site name/title using (*) operator Show all sites has a word starting with Con `title:<"Con*">` **Query string** ``` (webtemplate:STS OR webtemplate:GROUP OR webtemplate:SITEPAGEPUBLISHING) AND (contentclass=STS_Site OR contentclass=STS_Web) AND (title:"Con*") ```
{% hint style="info" %} **Note**: We do not recommend combining the **(=)** operator together with asterisk **(\*)** when you do exact matching. Instead, use the **(:)** operator with **(\*)** {% endhint %} #### Sites blacklisting
Exclude sites per site name/title Map all sites and libraries except specific sites (and their libraries) **Query string** to exclude `` and `` ``` (webtemplate:STS OR webtemplate:GROUP OR webtemplate:SITEPAGEPUBLISHING) AND (NOT (sitetitle:"Site01" OR sitetitle:"Site02")) ``` **Note:** restarting KONNEKT is required to apply the policy
#### Teams private and shared channels
Add Microsoft Teams private and shared channels Map all SP sites, Teams private channels and Teams shared channels By adding `webtemplate:TEAMCHANNEL` to the query **Query string** ``` (webtemplate:STS OR webtemplate:GROUP OR webtemplate:SITEPAGEPUBLISHING OR webtemplate:TEAMCHANNEL) AND (contentclass=STS_Site OR contentclass=STS_Web) ``` **Note:** restarting KONNEKT is required to apply the policy Since private and shared channels are dedicated sites on SharePoint, they appear as dedicated volumes in KONNEKT.
#### All Subsites for multiple SharePoint sites
Show all Subsites of one or more SharePoint sites To map all Subsites (and Libraries) of one or more SharePoint sites, you can use the following query **Query string** ``` (webtemplate:STS OR webtemplate:GROUP OR webtemplate:SITEPAGEPUBLISHING) AND (contentclass=STS_Site OR contentclass=STS_Web) AND (path:https://.sharepoint.com/sites/MySite1 OR path:https://.sharepoint.com/sites/MySite2) ``` **Note:** change MySite1 and MySite2 to your SharePoint site names. You map Subsites and libraries of only one SharePoint site or even add multiple URLs if needed
### **There are several ways to apply the policy:** * manually by adding the key in the registry under machine or user registry settings * via GPO, [check settings via GPO](https://docs.konnekt.io/configuration/management-options/settings-via-gpo) * pushing policies via Intune, see [settings for Intune Managed Devices](https://docs.konnekt.io/management-options/setting-for-intune-managed-devices-1/intune-mappings#sharepoint-site-query) #### **Manual setting in the registry** {% hint style="info" %} You do not need this if you use GPO or Intune management. {% endhint %} * **Registry Value name:** `SharepointSiteQuery` * **Registry Value type:** `REG_SZ` * **Registry Value data:** KQL string * **Registry Value storage location**: * `HKEY_CURRENT_USER\SOFTWARE\Policies\GlueckKanja\Konnekt`\ or * `HKEY_LOCAL_MACHINE\SOFTWARE\Policies\GlueckKanja\Konnekt` ## Library scope ### Map default document libraries If enabled the setting "Enable Sharepoint Sites" will display all default libraries from all Site Collections where a user has access to. A user can set this setting via the preferences menu: ![](https://2727108687-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8zLVuKYctMIUr68_fs%2Fuploads%2FX7YN84KblPNQSM4VHJYm%2F2022-08-02%2016_26_17-Window.png?alt=media\&token=ebf07224-f23a-43d4-a02e-129907602487) It can be configured via registry/GPO/MDM as well: **Policy Name (ADMX):** Sharepoint Sites Autodiscovery ![](https://2727108687-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8zLVuKYctMIUr68_fs%2Fuploads%2FyTfGHgChaP2bEG9Tmuyh%2F2022-08-16%2015_15_20-LabServer%20%E2%80%8E-%20Remotedesktop.png?alt=media\&token=e15267e4-61de-4220-bfeb-3b729daba659) #### Registry Key name: **O365SharepointUsage**\ Key type: REG\_DWORD Enable or disable access to SharePoint Online sites. | Function | Value | Behavior | | :------: | :----------------------: | --------------------------------------------------------------------------------------------------------------------------------- | | Disable | 0 | KONNEKT maps the OneDrive for Business library, only. | | Enable |

1

(default)

| KONNEKT maps the OneDrive for Business and all default document libraries of the SharePoint Online sites, the user has access to. | The default value is 1 (enable). We recommend using our [ADMX template](https://docs.konnekt.io/management-options/settings-via-gpo#admx-file) to configure this setting. ### Map all document libraries You can find this setting in the preferences menu: ![](https://2727108687-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8zLVuKYctMIUr68_fs%2Fuploads%2FUMH3ejq8y8ZdGIsx6UEI%2F2022-08-02%2016_26_54-Window.png?alt=media\&token=33ab3a77-1da2-421f-a92e-4da1e0cdf65c) {% hint style="info" %} Please make sure to reboot **KONNEKT** after changing this setting. {% endhint %} You can also configure this setting via registry/GPO/MDM: **Policy Name (ADMX):** Add all sharepoint libraries ![](https://2727108687-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M8zLVuKYctMIUr68_fs%2Fuploads%2F3OmlRnygk6ReRf3KWmyJ%2F2022-08-16%2015_22_33-LabServer%20%E2%80%8E-%20Remotedesktop.png?alt=media\&token=4cc7e8a8-8164-4a76-8b57-e1f362add006) #### Registry Key name: **AddAllSharepointLibraries**\ Type: REG\_DWORD | Function | Value | Behavior | | :------: | :----------------------: | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | Disable |

0

(default)

|

KONNEKT will map the default document library of the SharePoint Online sites, only.

Format of the UNC addressing is:
\OneDrive-\\<site-name>...

| | Enable | 1 |

KONNEKT will map all document libraries of the SharePoint Online site.

Format of the UNC addressing is:
\OneDrive-\\<site-name>\<library-name>...

| The default value is 0 (disable) {% hint style="danger" %} If users in your company are using different values of this setting, their UNC paths will not be compatible with each other (e.g. when they exchange UNC links). To prevent this, ensure that this setting is set for all users correctly. {% endhint %} We recommend using our [ADMX template](https://docs.konnekt.io/management-options/settings-via-gpo#admx-file) to configure this setting. ## **There are several ways to apply the policy:** * manually by adding the key in the registry under machine or user registry settings * via GPO, see [settings via GPO](https://docs.konnekt.io/configuration/management-options/settings-via-gpo) * pushing policies via Intune, see [settings for Intune Managed Devices](https://docs.konnekt.io/management-options/setting-for-intune-managed-devices-1/intune-mappings#add-sharepoint-libraries)