Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to see when people log into OCS RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hey folks, does anyone have a query to see when was the last time people have logged into OCS... by OU, if possible.  Thank you!
    AcroyearUSMC
    Thursday, April 9, 2009 1:28 PM

Answers

All replies

  • Question
    Sign in to vote
    2
    Sign in to vote
    Check Mike Stacy's Blog http://www.evangelyze.net/cs/blogs/mike/archive/2008/11/05/ocs-sql-query-show-last-ocs-logon.aspx
    • Marked as answer by AcroyearUSMC Thursday, April 9, 2009 6:25 PM
    Thursday, April 9, 2009 5:46 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    That's perfect... thank you very much!  For some reason I was trying to get that information from our CDR database to no avail :-) .  We're going to break it out by OU and we'll be set.  Thanks again!
    AcroyearUSMC
    Thursday, April 9, 2009 6:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Just for the record, I had to change part of the query to make this work in OCS 2007 R2.

    The rtcdyn.dbo.HomedUserDynamic should be changed to rtcdyn.dbo.HomedResourceDynamic.

    This is a really straightforward fix, but I thought I'd throw it out here so people wouldn't have to look for it.
    Monday, September 21, 2009 7:46 PM