Entrar
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
How to see when people log into OCS

Locked How to see when people log into OCS

  • quinta-feira, 9 de abril de 2009 13:28
     
     
    Entrar para Votar
    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
       

    Todas as Respostas

    • quinta-feira, 9 de abril de 2009 17:46
       
       Respondido
      Entrar para Votar
      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
      • Marcado como Resposta AcroyearUSMC quinta-feira, 9 de abril de 2009 18:25
      •  
         
      • quinta-feira, 9 de abril de 2009 18:26
         
         
        Entrar para Votar
        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
           
        • segunda-feira, 21 de setembro de 2009 19:46
           
           
          Entrar para Votar
          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.