Page History
Table of Contents | ||
---|---|---|
|
SharePoint On-Premise
Anchor | ||||
---|---|---|---|---|
|
In order to monitor an additional web application/site collection in your existing farm, please do the following:
- Confirm that the CardioLog service account has db_datareader SQL permissions for the SharePoint portal content database (required for SharePoint 2013 only).
- In the Administration pane, click System Configuration, and then select SharePoint Tree Adaptor.
- Click on your SharePoint farm.
- In the Web Sites section, select a web application zone and click the magnifying glass icon.
System Configuration - SharePoint Tree Adapter - Select Zone
- Select the web application/s you want to monitor and click Save.
System Configuration - SharePoint Tree Adapter - Select Web Sites
web applications - Select the site collection/s you want to monitor.
System Configuration - SharePoint Tree Adapter - Select site collections
- Restart the CardioLog Scheduling Service by selecting Administration in the navigation pane, and then selecting CardioLog Scheduling Service. Click Restart Service in the upper right hand corner.
- The tree structure will be refreshed the next day, after the Portal Tree Updates job is executed. The updated tree structure will be available in the Analysis Center and Object Explorer.
- If you are using the CardioLog Analytics tracking feature, or if you have configured the CardioLogAgent web application on your SharePoint WFEs, open the new web application in IIS Manager and verify that the CardioLogAgent folder under the "_layouts" directory is configured as a web application (if not, right click on it and select "Convert to Application").
- Verify data collection from the new web application.
...
- Add the db_datareader SQL permissions to the CardioLog service account for the SharePoint portal configuration and content databases, and grant read access to the SharePoint TEMPLATE folder (required for SharePoint 2013 only).
- In the Administration section of the navigation pane, click System Configuration, and then select SharePoint Tree Adaptor.
- Click Add Farm, and then select your SharePoint version.
- In the SharePoint Tree Adaptor dialog, fill out the following fields:
- Name - This is the title of the farm folder which will be displayed in the CardioLog tree structure in the Analysis Center. Ex: "SharePoint 20162013"
- Database Server - The SharePoint database instance name.
- SharePoint Configuration Database Name - The SharePoint configuration database name. Ex: "SharePoint_Config"
- SharePoint Profile Database Server, SharePoint Profile Database Name - Optional. Used when configuring user categories from SharePoint user profiles. Add the db_datareader SQL permissions to the CardioLog service account for the SharePoint profile database.
- Authentication - Database authentication type. Click Set to choose between Windows Integrated and SQL Server Authentication.
- SharePoint TEMPLATE Directory - This is the full path for the SharePoint 'TEMPLATE' directory. Ex: "\\<sharepoint WFE server name>\C$\Program Files\Common Files\Microsoft Shared\Web Server Extensions\XX\TEMPLATE\" (Where XX = 12 for MOSS 2007; 14 for SharePoint 2010; 15 for SharePoint 2013, 16 for SharePoint 2016).
- Advanced Settings - Select the additional import and transfer preferences you would like to include.
System Configuration - SharePoint Tree Adaptor - In the the Web Sites section, select a web application zone and click the magnifying glass icon.
System Configuration - SharePoint Tree Adapter : - Select Zone
Select all of - Select the web applications you would like application/s you want to monitor, then click Save.
SharePoint
System Configuration - SharePoint Tree Adapter : - Select Web Sites
web applications - Select the site collection/s you want to monitor.
System Configuration - SharePoint Tree Adapter - Select site collections - Restart the CardioLog Scheduling Service. The tree structure will be refreshed the next day, after the Portal Tree Updates job is executed. The updated tree structure will be available in Analysis Center and Object Explorer.
...
- Navigate to
https://<Admin Center>/_layouts/15/
AppInv.aspx
(e.g. https://intlock-admin.sharepoint.com/_layouts/15/AppInv.aspx). Paste client ID generated earlier into App Id field. Click Lookup. The existing values for Title, App Domain and Redirect URL should appear.
Enter the following XML into the App's Permission Request XML field to specify required permissions. Then click Create.
<
AppPermissionRequests
AllowAppOnlyPolicy
=
"true"
>
</
AppPermissionRequests
>
- You will be prompted to approve permissions for the app. Click Trust It.
- You can check the App registration details by navigating to:
https://<Admin Center>/_layouts/15/
AppPrincipals.aspx
You can test the App credentials by executing the following powershell PowerShell commands to retrieve the list of all available site collections.
$ Connect-PnPOnline https://<your-tenant>-admin.sharepoint.com -AppId <your-app-id> -AppSecret <your-app-secret>$ Get-PnPTenantSite
Anchor | ||||
---|---|---|---|---|
|
Execute the following PowerShell script with the SharePoint Online Global Administrator account in order to retrieve your App client ID. Edit the "CardioLogApp" name. You can check what is your App name by navigating to:
https://<Admin Center>/_layouts/15/
AppPrincipals.aspx
Code Block Connect-MsolService $applist = Get-MsolServicePrincipal -all |Where-Object -FilterScript { ($_.DisplayName -like "*CardioLogApp") } foreach ($appentry in $applist) { $principalId = $appentry.AppPrincipalId $principalName = $appentry.DisplayName Get-MsolServicePrincipalCredential -AppPrincipalId $principalId -ReturnKeyValues $false | ? { $_.Type -eq "Password" } | % { "$principalName;"+"`nClient ID: "+"$principalId;"+"`nClient Secret ID: " + $_.KeyId.ToString() +";" + $_.StartDate.ToString() + ";" + $_.EndDate.ToString() } | out-file -FilePath c:\appsec.txt -append }
- Open the C:\appsec.txt output file and copy the Client ID value:
Execute the following PowerShell script with the SharePoint Online Global Administrator account. Edit the "Client ID" and use the value copied from step 2.
Code Block Connect-MsolService $clientId = "Client ID" $keys = Get-MsolServicePrincipalCredential -AppPrincipalId $clientId $keys Remove-MsolServicePrincipalCredential -KeyIds $keys.KeyId -AppPrincipalId $clientId
Execute the following PowerShell script with the SharePoint Online Global Administrator account, in the same PowerShell window, in order to generate a new client secret ID.
Code Block $bytes = New-Object Byte[] 32 $rand = [System.Security.Cryptography.RandomNumberGenerator]::Create() $rand.GetBytes($bytes) $rand.Dispose() $newClientSecret = [System.Convert]::ToBase64String($bytes) $dtStart = [System.DateTime]::Now $dtEnd = $dtStart.AddYears(1) New-MsolServicePrincipalCredential -AppPrincipalId $clientId -Type Symmetric -Usage Sign -Value $newClientSecret -StartDate $dtStart -EndDate $dtEnd New-MsolServicePrincipalCredential -AppPrincipalId $clientId -Type Symmetric -Usage Verify -Value $newClientSecret -StartDate $dtStart -EndDate $dtEnd New-MsolServicePrincipalCredential -AppPrincipalId $clientId -Type Password -Usage Verify -Value $newClientSecret -StartDate $dtStart -EndDate $dtEnd $newClientSecret
Copy the client secret ID and update it in CardioLog configuration settings:
- In the Administration section of the Navigation pane, click System Configuration, and then select SharePoint Tree Adaptor.
- Click on your SharePoint Online tenant.
- Click Set next to the Authentication settings and select the OAuth option
- Enter the Client ID (copied from step 2) and renewed client secret ID (generated in step 4) and click Save.
Anchor | ||||
---|---|---|---|---|
|
...