Question

Calculate folder and Documents in Laserfiche

Laserfiche

Updated February 7

asked on July 13, 2020

I have laserfiche system with TB's of data and I want to calculate the folder and documents in the system.
Is there any easier method to do this?

While I use the calculate size option in Laserfiche client, It is taking long time and get disconnected after long time.

Please suggest a solution.

Regards

Mujeeb Ur Rahman

0 0

Replies

replied on July 13, 2020 • Show version history

You can run a SQL query to aggregate the size columns in the toc and doc table. Depending on how you want to view the data, you'll have to make sure that you break it down by volume, or folder.

1 0

View 1 previous reply

replied on July 13, 2020

At it's most basic, you're going to do something like this:

SELECT SUM(tocsum.docsum) AS[value]
FROM(
	SELECT(
		SELECT SUM(CONVERT(BigInt,doc.img_size)) AS tsum
		FROM doc
		WHERE doc.tocid = toc.tocid
		) AS docsum
	FROM toc
	) AS tocsum

Of course, there are other size columns in doc, and you need to take into account the edoc_size column on the toc table.

What questions are you trying to answer?

5 0

replied on July 13, 2020

Thanks.

0 0

replied on February 7 • Show version history

So when I calculate size within the Laserfiche Client on a repository and when I use the above SQL, they aren't quite the same, I'm not sure which one is right. I'd prefer to use the SQL, because I can write it so that it will give me the values on all of my repositories at one time and I don't have to run the calculate size every quarter for my boss, but I want to be accurate.

0 0

replied on July 14, 2020

You can also look at the Statistics tab for the repository's logical volume in the Administration Console.

1 0

replied on July 17, 2020

This is a good option if your repo is small. On ours, it got to the point where it would take 10s of minutes to run for each volume.

1 0

replied on July 18, 2020

I think this is the easiest method

0 0

You are not allowed to follow up in this post.

Question

Question

Calculate folder and Documents in Laserfiche

Replies

Sign in to reply to this post.