Přihlásit
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
How to see when people log into OCS

Bloqueado How to see when people log into OCS

  • 9. dubna 2009 13:28
     
     
    Přihlásit se a hlasovat
    0
    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
       

    Všechny reakce

    • 9. dubna 2009 17:46
       
       Odpovědět
      Přihlásit se a hlasovat
      2
      Check Mike Stacy's Blog http://www.evangelyze.net/cs/blogs/mike/archive/2008/11/05/ocs-sql-query-show-last-ocs-logon.aspx
      • Označen jako odpověď AcroyearUSMC 9. dubna 2009 18:25
      •  
         
      • 9. dubna 2009 18:26
         
         
        Přihlásit se a hlasovat
        0
        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
           
        • 21. září 2009 19:46
           
           
          Přihlásit se a hlasovat
          0
          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.