SPDocKit Consultant
Try it for FreeContact UsProduct Site
  • SPDocKit Consultant by Syskit
  • Product Updates
    • SPDocKit Consultant 12
    • SPDocKit Consultant 11.1.0
    • SPDocKit Consultant 11
    • SPDocKit Consultant 10
    • SPDocKit Consultant 9.1.0
    • SPDocKit Consultant 9
    • SPDocKit Consultant 8.0.3
    • SPDocKit Consultant 8
  • Requirements
    • SharePoint On-Premises User Permissions Requirements
    • Supported SharePoint Editions
    • System Requirements
    • Server Load Permission Requirements
    • Service Application Permission Requirements
  • Installation
    • Installation Guide
    • Upgrade to the Latest Version
    • Uninstallation Guide
    • PowerShell Guide
  • Activation
    • Activation Privacy Statement
    • Online Activation
    • Offline Activation
    • Manage License
    • Activation FAQ
    • Consultant License FAQ
  • Get To Know SPDocKit Consultant
    • Backstage Screen
      • Options Wizard
      • Compare Wizard
    • Farm Explorer Screen
      • Farm Dashboard
      • Farm Explorer Reports
      • Passwords and Product keys
    • Best Practices Screen
    • Snapshots Screen
    • PowerShell Commands
  • How To
    • Create Snapshot
    • Farm Documentation
      • Create Farm Documentation
      • Customize Documentation Template
    • Compare Wizard
      • Compare Farms
      • Compare Servers
      • Compare Web Applications
      • Compare Site Collections
      • Compare Web.Config Files
    • Best Practices
      • Available Best Practices Reports
      • Create Custom Best Practices Reports
      • Personalize Best Practices Reports
    • Generate an AutoSPInstaller XML Configuration File
  • FAQ
    • Miscellaneous
    • Security
    • Troubleshooting
      • RPC Server is Unavailable
      • Could not access content database
      • 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
      • The service application 'UPA Name' does not have any proxies that are default in a proxy group
      • SQL Server is unavailable
  • Known Issues
    • CREATE TABLE permissions denied
    • Distributed Cache loading issue
    • Load crashes with NullReference exception
    • Available Windows updates
    • PowerPivot FileNotFoundException issue
    • Unaccounted differences in the UPA settings
Powered by GitBook
On this page

Was this helpful?

  1. How To
  2. Best Practices

Create Custom Best Practices Reports

This describes how SharePoint administrators and consultants can use SPDocKit Consultant to create Best Practices reports for a SharePoint Farm.

PreviousAvailable Best Practices ReportsNextPersonalize Best Practices Reports

Last updated 2 years ago

Was this helpful?

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 loading/importing a 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:

778B
number-of-content-databases-per-web-application.zip
archive