LaserFiche: Determine Document Page Distribution

LaserFiche: Determine Document Page Distribution

The following SQL query can be run against the LaserFiche database to determine the number of documents with each page count.
When you run the query, you will see results like this:



The example above indicates that there are 2 documents that have between 28,300 and 28,400 pages.

You should size the computer you are using for the migration appropriately to ensure it can handle all documents of the specified sizes.


  2. DECLARE @RANGE INT = 100

  4. SELECT
  5. Pages_From = (CEILING(PageCount / @RANGE) * @RANGE),
  6. Pages_Till = (CEILING(PageCount / @RANGE) * @RANGE) + @RANGE,
  7. Docs = COUNT(*)
  8. FROM
  9. (
  10. SELECT TOP 999999999
  11. TocId,
  12. PageCount = pagecount
  13. FROM
  14. toc
  15. WHERE 1=1
  16. AND edoc_storeid is null
  17. AND etype = -2
  18. ORDER BY
  19. PageCount DESC

  21. ) PageCounts
  22. GROUP BY
  23. (CEILING(PageCount / @RANGE) * @RANGE)
  24. ORDER BY
  25. Pages_From DESC

    • Related Articles

    • Primafact: Determine Document Page Distribution

      The following SQL query can be run against the Primafact database to determine the number of documents with each page count. When you run the query, you will see results like this: The example above indicates that there are 2 documents that have ...

    • Primafact: Document Synthesis

      How Primafact is Designed to be Used Primafact is not a document management system. While Primafact does store documents, Primafact is a Litigation Document Management System, not a standard document management system. It is designed to ingest large ...

    • Lead Docket: Determine Api Key

      To determine your Lead Docket API Key do the following: 1. Log into Lead Docket as an Administrator 2. Click on your initials and select "My Account: 3. On the left, select Manage > Settings: 4. At the bottom, copy the Api Key:

    • NetDocuments: Copy Documents to Clio Document storage from Clio integration linked folders

      Clio has an integration with NetDocuments that creates folders in NetDocuments linked to Matters in Clio. If a client making use of this integration wants to move their documents from NetDocuments to being stored in Clio you can use this procedure. ...

    • Extracting Document Metadata from ndToolkit

      NdToolkit is a tool from NetDocuments used by consultants, to extract data from repositories/cabinets. It can be used to extract the Metadata from the Cabinet for Workspaces, Folders and Documnets. To accomplish this, do the following: Open ndToolkit ...