# Report One Note

Reports on OneNote notebooks found in SharePoint document libraries by processing rows from an Excel file. Outputs a result file listing all discovered notebooks with their metadata.

Filename pattern: filename must contain ReportOneNote or OneNoteReport (case-insensitive).
Example: 20240115 ReportOneNote audit.xlsx

# Columns

Name Required Description
ClientCode No Client code used together with MatterCode to identify the matter.
MatterCode Conditional Matter code used to resolve document libraries from the matter list. Required when Url is not provided. Scans all matter document libraries and the SiteAssets library of the matter site.
Url Conditional Server-relative URL of a specific document library to scan. Required when MatterCode is not provided.

Either Url or MatterCode must be provided.

# Behavior

The handler scans each matched library for folders identified as OneNote notebooks. Results are written to {filename}_Result.xlsx in the same directory as the input file.

When MatterCode is used: all document libraries for the matter are scanned, plus the SiteAssets library of the matter site.

Each row in the result file contains:

Column Description
SiteUrl URL of the site containing the notebook
DoclibUrl Server-relative URL of the document library
NotebookUrl Server-relative URL of the OneNote notebook folder
IsEmpty true if the notebook contains no items
Modified Last modified date
ModifiedBy User who last modified the notebook
Created Creation date
CreatedBy User who created the notebook
Error Error message if the library could not be scanned
Last Updated: 4/20/2026, 12:54:05 PM