SPDocKit
Try it for FreeContact UsProduct Site
  • SPDocKit by Syskit
  • Release Notes
    • SPDocKit 12
    • SPDocKit 11.1.0
    • SPDocKit 11
    • SPDocKit 10
    • SPDocKit 9.1.0
    • SPDocKit 9
    • SPDocKit 8.0.3
    • SPDocKit 8
  • Requirements
    • SharePoint On-Premises User Permissions Requirements
    • Supported SharePoint Editions
    • System Requirements
    • Server Load Permission Requirements
    • Service Application Permission Requirements
  • Installation
    • Install SPDocKit
    • Upgrade to the Latest Version
    • Uninstall SPDocKit
  • Activation
    • Activate SPDocKit
    • Manage License
    • Activation Privacy Statement
  • Configuration
    • Configure SPDocKit
    • Configure SPDocKit Database
    • Import and Export SPDocKit Settings
  • Create SharePoint Farm Snapshots
    • Snapshots Screen
    • Manual Snapshots
    • Automatic Snapshots
  • Explore Reports & Create Documentation
    • Farm Explorer
      • Farm Explorer Screen
      • Farm Dashboard
      • Farm Explorer Reports
      • Farm Documentation
      • Passwords and Product keys
      • Generate an AutoSPInstaller XML Configuration File
      • Change the Limit on Site Topology Report
    • Site Explorer
      • Site Explorer Screen
    • Permission Reports
      • Permissions Reports screen
    • Analytics and Usage Reports
      • Analytics and Usage Reports Screen
      • Analytics Dashboard
      • Site Collection Analytics
      • Document Extensions Reports
    • Audit Reports
      • Audit Reports Screen
      • Audit Dashboard
      • Audit Log Details
      • Administrative Actions
      • Audit Settings
    • Best Practices
      • Best Practices Screen
      • Best Practices Reports
    • Subscriptions and Alerts
      • Subscriptions and Alerts
      • Create New Subscription
      • Create New Alert
    • Customizing Reports
      • Customize View
      • Add Comments
  • Compare SharePoint Configurations
    • Compare Wizard
    • Compare SharePoint Farms
    • Compare Servers
    • Compare Web Applications
    • Compare Site Collections
    • Compare SharePoint Permissions
    • Compare Web.Config Files
  • Manage SharePoint Permissions
    • Permissions Explorer Screen
    • Manage Permissions Ribbon Actions
    • Users and Groups Actions
      • Manage Groups Wizard
      • Group Memberships Wizard
      • Copy Permissions Wizard
      • Move Permissions Wizard
      • Manage Permissions Wizard
      • Remove Permissions Wizard
    • Securable Objects Actions
      • Break/Restore Permission Inheritance Wizard
      • Restore Permissions
      • Copy Object Permissions Wizard
    • Site Collection Actions
      • Site Collection Administrators Wizard
      • Permission Levels Wizard
      • Clean Site Collections Wizard
    • Add Tags
    • SPDocKit Permission Management Event Log
  • Configure & Extend SPDocKit
    • Backstage Screen
    • Options Wizard
    • License Management
    • Role Based Security
    • Extend SPDocKit
      • Install SPDocKit Extensions
      • Download SPDocKit Extensions
      • Activate SPCAF Extension
  • Query & Change SharePoint Settings
    • Queries and Rules Screen
    • Create SharePoint Governance Policy Rule
    • Create SPDocKit Query
    • Change SPDocKit Query Results Limit
    • Create Audit Queries and Rules
  • FAQ
    • Requirements
    • Installation
    • Activation
    • Configuration
    • Features
    • Security
    • Miscellaneous
    • SPDocKit Insights Removed
    • SPDocKit Insights Migration
  • Known Issues
    • CREATE TABLE permissions denied
    • Custom features missing in reports
    • Data retention not working properly
    • Distributed Cache loading issue
    • Load crashes with NullReference exception
    • Available Windows updates
    • Permissions Wizard issue
    • PowerPivot FileNotFoundException issue
    • SQL Clusters support
    • Storage Metrics report subscription
    • Unaccounted differences in the UPA settings
    • Custom Query issue with URL export
    • Recursive groups issue with export
  • Troubleshooting
    • SharePoint
      • Could not access content database
      • The service application ‘UPA Name’ does not have any proxies that are default in a proxy group
    • Server Load & User Permissions
      • RPC Server is Unavailable
      • Error occurred while loading Web Application
      • Error occurred while trying to load 'Problems and Solutions' and 'Rule Definitions'
      • Error while loading IIS Settings Information
      • Errors while trying to load the SharePoint farm
      • Errors while loading server information
      • Failed at retrieving SQL Accounts from the following servers
      • My permissions loading status is reported as ”Failed”
      • Service was unable to read Active Directory properties
      • SQL Server is unavailable
      • Error adding service account to "spdockit_service_role" database role
    • SQL Server Connection
      • SPDocKit won’t connect to a provided server and database
      • Configure SQL server to listen on a specific port
      • Is SQL Server configured to use a named instance
      • Inbound traffic on TCP Port 1433 needs to be allowed on the SQL
      • Service user does not have rights to connect to the SQL server
      • TCP/IP network traffic not enabled on the SQL Server
Powered by GitBook
On this page
  • Available Reports
  • Visit our best practices library
  • Available best practices checks
  • Create Custom Reports
  • Personalize Reports
  • Create a new best practices report
  • Adjust the best practices dashboard view
  • Customize the built-in best practices values

Was this helpful?

  1. Explore Reports & Create Documentation
  2. Best Practices

Best Practices Reports

This article describes which best practices reports are available in SPDocKit and can help you keep your SharePoint farm healthy.

PreviousBest Practices ScreenNextSubscriptions and Alerts

Last updated 2 years ago

Was this helpful?

Available Reports

We have prepared a detailed overview of all available reports in SPDocKit with descriptions and instructions in our .

Visit our best practices library

The built-in reports contain information from various sources: most of them come from official articles by TechNet, MSDN, or other reliable sources, and some pieces of information come from personal experience. The purpose of these articles is to help you validate your farm configuration and optimize it according to the latest SharePoint best practices.

Available best practices checks

With each new release, Best Practices are extended with new reports. Our tool covers the following areas:

  • Configuration

  • Databases

  • Hardware Requirements

  • Maintenance

  • Monitoring and Logging

  • Service Applications

  • SharePoint Software Boundaries and Limits

  • Site Collection Health

  • Updates

  • Web Applications

Create Custom Reports

This section describes how SharePoint administrators can use SPDocKit to create Best Practice reports for a SharePoint Farm. In this guide, we will show you how you can build a report that counts the number of content databases per Web application.

  1. After taking a manual snapshot or loading an older snapshot, go to the Best Practices tab in your navigation bar. To create a custom report, click New.

  2. The Best Practice wizard will open. Type in the Name and the Description of your new report. Select a Location and then click Next to continue.

  3. Choose the Data Source from the list. For the purposes of this report, select Farm > Application Management > Databases > Content Databases, and then click Next to continue.

  4. Select the fields you want to include in your report. The fields offered depend on your Data Source selection from the previous step. For this report, choose Database Name and Web Application. Click Next to continue.

  5. Once you have selected your fields, choose how your data will be grouped. For this report,group data by the Web Application name field. Click Next to continue.

  6. Choose the Aggregation Type Count. Click Next to continue.

  7. You can choose the sorting order and specify the order of your fields. In this case, we are going to choose Ascending. Click Next to continue.

  8. Select the fields where you want to apply the formatting. You can edit the conditional formatting rules by clicking the underlined value specific. For this report, select the field COUNT (Database Name). Click Next to continue.

  9. Enter the preferred values and formatting rules. Click OK. In this case, we will adjust the values so that when the number of databases per Web application is over 300, the report will show an error. If the value is between 250 and 300, the report will show a warning, and if the value is less than 250 the report will give a positive result.

  10. You can add conditions to filter data. Click the underlined value specific to edit the conditions. For example, when the condition Does Not Contain is selected, the report will not show Web applications that contain an entered value in their names. For this case, enter "Central Administration" to filter out that Web application from the report.

  11. Click Next, then click Finish to close the wizard. Wait a few seconds and your SharePoint Best Practice report will be created!

Download this report:

Personalize Reports

Create a new best practices report

The first option is to create a completely new Best Practices report using the Best Practices wizard.

The second option is to save the built-in Best Practices report as a new one and then modify some of the settings so that this report better matches your SharePoint settings. Use the Save As button to save the desired report under a different name and then the Edit button to configure new settings.

Adjust the best practices dashboard view

Click Customize Best Practices on the Best Practices Home ribbon. Deselect the check boxes for the reports you don’t want to monitor. Click Save to finish adjusting your dashboard view.

Customize the built-in best practices values

Best Practices reports checking some numerical values, like the amount of RAM per server, can be customized as well. Select the Best Practices report you would like to modify, click Customize Best Practices and edit the numerical values on the right to fit your requirements.

Please note! If you edit these values, the Best Practice report will display a warning that the default values have been changed.

We will regularly update all articles delivered with this product, but please note that the guidance information might change frequently, so we encourage you to check the official resources for changes. Below every article you will find all relevant and official articles listed in the Additional information section.

Best Practices Library
in the library
778B
number-of-content-databases-per-web-application.zip
archive