How can I get a count of all documents in all site collections?

Question

And if I need to make the same count but with some field filters?

Is the best approach populate a list using SPSiteDataQuery and then make the report from that same list?

spregards

Do you have to do it once or many times? if it's once, a simple recursive powershell script can do the job.
I want to have it always displayed and reported. I try via Report Builder but that way comes up to be restrictive in terms of filtering by content types fields. Now I'm inclined to populate a list using SPSiteDataQuery and then make the report from that list.

Stuart Pegg · Accepted Answer · 2012-06-22 10:09:34Z

up vote 3 down vote accepted

If you're talking about using the Object Model, then I'd recommend SPSiteDataQuery.

It has many options for filtering the results, including by list template (e.g. document library).

answered Jun 22 '12 at 10:09

Stuart Pegg
2,56521456

1 Answer