Need to generate a report of all docs in sharepoint with metadata
Mathew,
I think what you are trying to do would need some custom code. You can write an application where you can use the SPSiteDataQuery Class: http://msdn.microsoft.com/en-us/library/ms409088(v=office.12).aspx
By using this class you can create CAML queries against a site collection and view the results. So, I think that the idea would be to loop through every Web Application and every Site Collection (maybe only the Top Leve Site Collections (??) - since there
is property I think which can be used to search recursively) programmatically, and store this information to a DB, XML or any other output format.
In order to construct your CAML query you can make use of a free CAML Builder tool by U2U: http://www.u2u.net/res/Tools/CamlQueryBuilder.aspxDimitris Porikos, MCTS
March 13th, 2011 11:43am
hi Dimitris,
i have only one webapp, do you have an example how "SPSiteDataQuery wil help you determine which docs in aSsite Collection
of Content Type XX have specific metadata filled or not." ?aju
Free Windows Admin Tool Kit Click here and download it now
March 13th, 2011 11:55am
Hello,
In my SharePoint farm(MOSS 2007) all the documents uploaded are content type tagged. All content types has fields ABC, PQR and XYZ but users sometimes doesnt enter values in this fields while they upload documents. Now i have to generate a report showing
how many documents are there in farm, how many of them have value in the fields ABC, PQR and XYZ. Which site this document belongs to, URL of the document library etc. Note that we have around 24 content databases and 12000+ site collections. Can someone help
me in how to proceed with this requirement? is there a way to query content database directly to get these information? Appreciate any quick help.
Thanks in advance
Mathewaju
March 13th, 2011 12:05pm
Hello Dimitris,
Thank you for your reply. I was also thinking of using SPSiteDataQuery but we have around 13000 site collections and i have to loop through every single document in each site collection and get the meta data field of each document which will take days to
complete and will affect the performance badly. And each time the management need a report this has to be repeated. :(
Any other ideas?
Thanks,
Mathewaju
Free Windows Admin Tool Kit Click here and download it now
March 13th, 2011 12:48pm
Hello again,
You don't have to loop and check metadata for every single document!
SPSiteDataQuery wil help you determine which docs in aSsite Collection of Content Type XX have specific metadata filled or not.
I also think (have not tested it) that by using recursive attribute in your CAML query will reduce the number of the Site Collections
that your query has to be executed against.
Another possible solution would be to focus on a Content Query Web Part...
But in this case you should Log On as a user with read access Everywhere in your intranet.
How many web apps does your intranet contain ??Dimitris Porikos, MCTS
March 13th, 2011 1:03pm