How to see when people log into OCS RRS feed

  • Question

  • 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!
    Thursday, April 9, 2009 1:28 PM


All replies

    • Marked as answer by AcroyearUSMC Thursday, April 9, 2009 6:25 PM
    Thursday, April 9, 2009 5:46 PM
  • 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!
    Thursday, April 9, 2009 6:26 PM
  • 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