+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Reports on CMS usage

Reports on CMS usage

8 posts, 1 answered
  1. Ray
    Ray avatar
    5 posts
    Registered:
    05 Apr 2013
    08 Oct 2013
    Link to this post
    Hi,

    I have looked through the list of reports in Sitefinity Analytics and they all seem to be dealing with the usage of the website.  Are the any reporting capabilities on the CMS usage, showing things like who logged in when, etc?

    Thanks,
    Ray
  2. Jonathan
    Jonathan avatar
    119 posts
    Registered:
    19 Dec 2012
    08 Oct 2013 in reply to Ray
    Link to this post
    Running the below SQL Query will give you some information about usage.

    SELECT TOP 1000 [user_name]
          ,[salt]
          ,[password_question]
          ,[password_format]
          ,[password_answer]
          ,[passwd]
          ,[manager_info]
          ,[last_password_changed_date]
          ,[last_name]
          ,[last_modified]
          ,[last_login_ip]
          ,[last_login_date]
          ,[last_lockout_date]
          ,[last_activity_date]
          ,[is_logged_in]
          ,[is_locked_out]
          ,[is_backend_user]
          ,[is_approved]
          ,[id]
          ,[first_name]
          ,[fld_psswrd_ttempt_window_start]
          ,[failed_password_attempt_count]
          ,[fld_psswrd_nswr_ttmpt_wndw_str]
          ,[fld_psswrd_nswer_attempt_count]
          ,[email]
          ,[creation_date]
          ,[commnt]
          ,[app_name]
      FROM [YOURDBNAME].[dbo].[sf_users]

    Additionally you can use the API.  See this documentation 

    Good luck!
    Answered
  3. Ray
    Ray avatar
    5 posts
    Registered:
    05 Apr 2013
    08 Oct 2013 in reply to Jonathan
    Link to this post
    Thanks much Jonathan!  That is helpful...
  4. Ray
    Ray avatar
    5 posts
    Registered:
    05 Apr 2013
    17 Oct 2013 in reply to Ray
    Link to this post
    hope to update this post soon with more info...
  5. Ivan A. Petrov
    Ivan A. Petrov avatar
    8 posts
    Registered:
    09 Sep 2013
    22 Oct 2013
    Link to this post
    Hi Ray,

     Google Analytics doesn't provide this kind of information, but you can create your own custom code that keeps track of the login history. It's up to you how would you save that kind of information, but on every successful login in Sitefinity there is an event raised: ILoginCompletedEvent and you can subscribe to it like this:

     First you should do this in the Application_Start() method in the Global.asax class.

    protected void Application_Start(object sender, EventArgs e)
    {
        Bootstrapper.Initialized += Bootstrapper_Initialized;
    }
     
    void Bootstrapper_Initialized(object sender, Telerik.Sitefinity.Data.ExecutedEventArgs e)
    {
       //...
    }

    And than in the Bootstrapper_Initialized() you can subscripe to the event when someone logs in, which looks like that:

    void Bootstrapper_Initialized(object sender, Telerik.Sitefinity.Data.ExecutedEventArgs e)
    {
        EventHub.Subscribe<ILoginCompletedEvent>(OnLoginCompletedEventHandler);
    }
     
    public void OnLoginCompletedEventHandler(ILoginCompletedEvent e)
    {
        // Custom Logic Here;
    }

    And in the handler you can save the information you get from the event which is who is that user and you can get the current time with DateTime.Now(). You can get some more information on Sitefinity Event System in the official documentation here and here.


    Regards,
    Ivan A. Petrov
    Telerik
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. Ray
    Ray avatar
    5 posts
    Registered:
    05 Apr 2013
    06 Feb 2014
    Link to this post
    Hi,

    I have a similar question; how would we obtain logged information concerning what CMS users made edits to what pages?  Like, this person edited the landing page yesterday at 3:10 p.m., that person edited it 3 days ago at 2:45 p.m., etc. 

    As I searched the web I noticed that if you set up a site map (http://www.enterprisefinity.com/products/sitemap-generator for example) this will provide info on the last person who edited pages.  Is there a way to have something more comprehensive set up? 

    Thank you,
    Ray
  7. Vasya Stankova
    Vasya Stankova  avatar
    12 posts
    Registered:
    03 Nov 2014
    07 Feb 2014
    Link to this post
    Hello Ray,

    Unfortunately Sitefinity Analytics module does not support such functionality. It is not implemented in order to track backend changes. We could add a feature request for you in order to have this functionality in the future.

    For each page you could see its Revision History, which is accessible from the Actions menu. There you could see each change which was made for the corresponding page.

    Regards,
    Vasya Stankova
    Telerik
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
  8. Ray
    Ray avatar
    5 posts
    Registered:
    05 Apr 2013
    12 Feb 2014 in reply to Vasya Stankova
    Link to this post
    Hi Vasya,

    Thank you so much for responding.  I know that Sitefinity Analytics is only dealing with traffic from the outside and not with CMS stats.  I was wondering where I can obtain information concerning creating a custom solution for gathering stats of page usage, or of purchasing a custom solution. 

    Anyone have any thoughts concerning this?

    Have a wonderful day,
    Ray
8 posts, 1 answered