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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics