.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Efficient Way to find how many documents were modified in a site in the lastmonth-CAML Queries

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
Which is the Best way to find how many documents were modified in a Site in the last month,(not at document level) Using Caml query which is the best method (using U2U builder or some thing else)   Please share your thoughts. Thank you    

View Complete Post

More Related Resource Links

How to find number of documents uploaded to each sharepoint site?


How can I determine how many documents are uploaded to each sharepoint site?

Find It: Integrate Search Into Your Site With ASP.NET


We implement search providers for both Live.com and SharePoint so you can take advantage of either in your own applications.

Marco Bellinaso

MSDN Magazine September 2007

How to stop unauthorized users from sending documents to a Records Center site?


I can't find a way to stop unauthorized users from sending documents to a Records Center site. Can someone please help me? Do i need to configure anything to restrict it to the members of the web submitters group?

I'm still using MOSS2007


The impossibility of doing things depends on your will to do it.

Search does not find text in Word document stored in document library on a Report Center site within



We have a document library on a site created off of the Report Center site template. We uploaded a Word 2007 document with the word zebra in the text. Using the search bar at the top of the page we selected This list: Our document library and searched for zebra. We received no results.

We tested the same thing on another site (site template Team site) within the same site collection and search worked fine.

Does the Report Center search function differently then the search functionality on the Team site?

Tamara Bredemus SharePoint Minion...working up to Maven

Would you use clustering to find documents similar to this one?

Hi, I am taking a BI Developer course and enrolled at a school where the teacher knows nothing about data mining. So I designed a project for myself and am trying to surmount the curve without the benefit of a mentor. Please have patience with me. I have a database full of documents where the entire text resides in a single field (nvarchar(max)) I want to find documents that are similar to the one I pick. I am not sure what approach I should take to get there..         1) create clusters for the entire database and then see what cluster my document is in OR                 2) some-how train a model on the single document and then let the DM engine go find the matches.   I have tried approach 1, but the similarity between the documents is not very high (at least in the few of thousands I looked at) I do not see how to do approach 2, unless I cluster with a test set size of 1, and that doesnt seem right.   Is clustering even the way to go?   Thanks, struggling in Austin

How to find if users are visting my site using IIS?

Hello,I want to find out if users have visited my site in the last couple of days. i did not put Google analytics so I was wondering if there are any logs of IIS which log if a user has visited or not?Is this possible?Could you please provide some useful links?Thanks

count of documents modified

Hi, I have a document libraray, which has more than 700 documents. How to get the count of documents, which have been modidfied in last 30 days using c# ? Thank you

caml query builder for wss 3 site

hi, is there a caml query builder that can be use for WSS 3.0 sites?

How to find newly added item in the share point site?

How to find the recently added item in the share point page If the any user added the items in the custom list, library, list,Announcement, Picture library,etc......... i need to show all item that added last 2 days. Is that any object model available to find all item in the share point site???Instead of searching every list.

CAML query to access List data across multiple site collection.

Hi   Is there any way to get the Task List data across multiple site collection using CAML query. Currently, I have the code which will retrieve the data from a single site collection. Below is the code.                           /***************************************************I am using Moss2007.Thanks!Ravi             SPSiteDataQuery q = new SPSiteDataQuery();             q.ViewFields = "<FieldRef Name=\"Title\" />" "<FieldRef Name=\"Status\" Nullable=\"TRUE\"/>";             q.Lists = "<Lists ServerTemplate=\"107\"/>";             q.Webs = "<Webs Scope=\"SiteCollection\"/>";             q.Query = "<Where>" +                                "<Eq>" +                                     "<FieldRef Name=\"Status\" />" + "<Value Type=\"Choice\">Not  Started</Value>" +                                     "</Eq>" +                         "</Where>";             DataTable dt=null;             using (SPSite s = new SPSite("http://banglabguest1:31000/"))             {                 SPWeb w = s.OpenWeb();                 dt = w.GetSiteData(q);                 w = null;             }                              *************************

Using a List View web part to display documents from multiple document libraries from different site

Hi there, I am trying to have one web part display documents (or list items) from different document libraries (or different lists) from different site collections. I have achieved this under a single site collection using Data View Web Part (using SPD). I have also achieved displaying a single document library (or a list) from a different site collection by using List View Web Part. but I am not sure how to get my head around displaying documents or list items from different document libraries or lists across site collections. I have thought of using SPSiteDataQuery or ListViewByQuery, but they all seem to focus one site collection at a time. If any of you have done this before, please share your best practice on this one with me. Much appreciated. Clark

Alerts - How can a site owner find out who has been included on an alert ?

alerts have been set on a discussion board to notify a set of users when a new item is added. how can I ( as site owner ) find out who these users are. is there a way for a site owner to administer the alert once it has been set up ? thanks and regards, Counie

I want to add a button of my documents to site

Hi,   I am tring to add abutton in site to go to my documents, but it has space in it and it is not working by using the below code <input type="button" id="btnMyDocuments" value="Go to My Documents" alt="Go to My Documents" onclick="OpenMyDocuments()" />   <Script Language="VBScript"> Sub OpenMyDocuments() Set oShell = CreateObject("Wscript.Shell") Set oSFolders = oShell.SpecialFolders sDesktop = oSFolders("my documents") oShell.Run  smy documents Set oShell = Nothing End Sub </Script>   But if try to use desktop it works(because it doesnt have space in it) by using the following code   <input type="button" id="btnMyDocuments" value="Go to My Desktop" alt="Go to My Desktop" onclick="OpenMyDocuments()" />   <Script Language="VBScript"> Sub OpenMyDocuments() Set oShell = CreateObject("Wscript.Shell") Set oSFolders = oShell.SpecialFolders sDesktop = oSFolders("Desktop") oShell.Run  sDesktop Set oShell = Nothing End Sub </Script>    Can any one help me, weather i am doing any mistake   Thank You      

How to find a page count across a site collection

Is there a way through the standard MOSS user interface to find all of the pages in all pages lists across an entire site collection?

CAML query to pick docs where modified is older than today.


Hi I am looking for a CAML query which will return all documents throughout the site collection
for docs which have a Modified that have past today.
I cant seem to do this.

I have a query so far as this and it comes up with an error 'The property Query contains invalid value'

SPSiteDataQuery q = new SPSiteDataQuery();
q.ViewFields = "<FieldRef Name=\"Modified\"/>";
q.Lists = "<Lists ServerTemplate=\"101\"/>";
q.Webs = "<Webs Scope=\"SiteCollection\"/>";
q.Query = "<where><Geq><FieldRef Name='Modified' /><Value Type='DateTime'><Today OffsetDays='-1' /></Value></Geq></where>";

How do you do this ??

Word 2007 documents won't open from Sharepoint Services site

I have a Sharepoint Services 3.0 site that contains shared documents, Word, Excel, PDF, etc.  I cannot open Word documents directly from the shared documents portal.  Other file types like Excel adn PDF open fine.  It's only Word that has the issue.  I'm using Word 2007 and it doesn't matter if it is a .docx or a .doc, both act the same.  Word tries tro open, then just sits there....no error message or anything.  Any help would be greatly appreciated!

How to find out how many users logged onto a sharepoint hosted site?


We have a sharepoint hosted site that is accessible to users externally. 

Sometimes whenever we need to  release some updates, we would like to do it when there is no user browsing the site.

Are there are any tools available? If not, can we write any scripts or code?

Please suggest.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend