SharePoint Online: How to acces the Change Log in a Site Collection (I)!

As in SharePoint OnPremises, in SharePoint Online you can access the Changes Log at different levels: Site Collection, Site and List / Library since we have available a number of objects and methods in the Client Side Object Model that help us to read the Changes Log such as:

In this post we will see how easily we can access the Changes Log for a SharePoint Online Site Collection using a Console Application Program:

  • In Visual Studio 2013, create a Console Application project and add references to Microsoft.SharePoint.Client, Microsoft.SharePoint.Client.Runtime, System.Configuration and Sistem.Web.
  • In Program.cs, add the following using directives:
using SPCSOM = Microsoft.SharePoint.Client;

using System.Net;

using System.Configuration;

using System.Security;

  • In the App.Config file, add the parameters (SharePoint Online credentials) required to connect to the SharePoint Online Site Collection:

<appSettings>

  <add key="SPOUser" value="SPOUser"/>

  <add key="SPOPassword" value="SPOPassword"/>

</appSettings>

  • Next add a static method to Program.cs in which you the objects and methods of CSOM that allow you to access the Change Log for a SharePoint Online Site Collection: the ChangeQuery class (allows us to see the Changes Log), ChangeCollection class (it provides a collection of changes), the GetChanges () method of the Site object and finally Change class:

static void QuerySPOSiteCChangeLog()

{

    try

    {

        string sSiteUrl = 

            "https://nuberosnet.sharepoint.com/sites/SPSaturdayCol/";

        using (SPCSOM.ClientContext spoCtx = new SPCSOM.ClientContext(sSiteUrl))

        {

            //

            //SharePoint Online Credentials

            //

            string sSPOUser =

                ConfigurationManager.AppSettings["SPOUser"];

            string sPassword =

                ConfigurationManager.AppSettings["SPOPassword"];

            SecureString ssPassword = new SecureString();

            foreach (char c in sPassword.ToCharArray())

                ssPassword.AppendChar(c);

            spoCtx.Credentials =

                new SPCSOM.SharePointOnlineCredentials(

                    sSPOUser, ssPassword);

 

            spoCtx.Load(spoCtx.Web, web => web.Title);

            spoCtx.Load(spoCtx.Web, web => web.Url);

            spoCtx.ExecuteQuery();

 

            Console.WriteLine("Accessing to the audit log for {0} - {1}", 

                spoCtx.Web.Title, spoCtx.Web.Url);

            SPCSOM.ChangeQuery cqChangeQuery = 

                new SPCSOM.ChangeQuery(true,true);

 

            SPCSOM.ChangeCollection ccChangeCollection = 

                spoCtx.Site.GetChanges(cqChangeQuery);

            spoCtx.Load(ccChangeCollection);

            spoCtx.ExecuteQuery();

 

            Console.WriteLine("# of Changes found in the first batch {0}", 

                ccChangeCollection.Count);

 

                foreach (SPCSOM.Change cChange in ccChangeCollection)

                {

                    Console.WriteLine("Change Type: {0} - Object Type: {1} - Change Time: {2}",

                        cChange.ChangeType, cChange.TypedObject, cChange.Time);

                }

        }

    }

    catch (Exception ex)

    {

        Console.WriteLine("Error: {0}", ex.Message);

    }

}

  • As a result of executing the Console Application, you will get a series of changes from the Change Log. For each change you will get information such as the change type, the affected object and the change time.

image

Other references:

3 pensamientos en “SharePoint Online: How to acces the Change Log in a Site Collection (I)!

  1. Pingback: SharePoint Online: How to acces the Change Log in a Site Collection (II)! | Pasión por la tecnología...

  2. Pingback: SharePoint 2013 & Office 365: Resumen de posts (LXV)! | Pasión por la tecnología...

  3. Pingback: SharePoint 2013 & Office 365: Resumen de posts (LXV)! - Blog de Juan Carlos González en Geeks.MS

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s