Inactive Users?

ตอบทั้งหมด

• 10 ตุลาคม 2551 17:57

  ผู้ดูแล

   

   
  

  0

  Presence is stored in a binary blob in the database but can be read using the appropriate OCS API call.  Availability of Online but Idle is returned in the range of 4500 to 5999 and availability of Busy but Idle is returned in the range of 7500 to 8999.

   
• 10 ตุลาคม 2551 18:00

   

   
  

  0

   

  thanks for your response. But im searching for something else.

   

  Im trying to determine users who have NEVER logged into OCS but are enabled for it. and/or users who have not logged into it in say 6months.

   

  is that possible?

   

   
• 10 ตุลาคม 2551 19:07

  ผู้ดูแล

   

   
  

  0

  Gotcha.  "Inactive" has a different meaning from a Communicator perspective.  In any case, just grab the output of the UpdateTime column from the ResourceDirectory table and cross reference the ids with the Resource table to identify the users.

   
• 10 ตุลาคม 2551 19:25

   

   
  

  0

   

  they are all showing up with an UpdateTime that is in the past. Would this be acurate? As I am in OCS currently as is many other users.

   

  Im looking at ResourceDirectory / UpdateTime

   
• 10 ตุลาคม 2551 20:44

  ผู้ดูแล

   

   
  

  0

  I'm sorry, I was clicking through too fast trying to multitask.  That is the last time that the user object was updated.  You may need an API call to read the last presence update.  I'll tinker around with this a little later to see what I can find.

   
• 11 ตุลาคม 2551 20:25

  ผู้ดูแล

   

   
  

  0

  Sorry for the delay...crazy week.  Run this query in SQL to return the last logon time.

   

  Code Snippet

  select hud.LastNewRegisterTime as "Last Logon",res.UserAtHost as "SIP Address" from rtcdyn.dbo.HomedUserDynamic hud join

  (Select ResourceId, UserAtHost from rtc.dbo.Resource

  group by ResourceId, UserAtHost)

  res

  on hud.OwnerId=res.ResourceId

  order by "Last Logon"

   

   

  This will return a list of users ordered from earliest logon time (starting with NULL) to latest.

   

   
• 11 ตุลาคม 2551 21:11

   

   
  

  0

   

  Worked perfectly! Thanks alot!
   
• 11 ตุลาคม 2551 21:42

  ผู้ดูแล

   

   
  

  0

  Great!  When you get a chance please mark the question as answered so that it helps others who may search for this later.

   
• 11 พฤศจิกายน 2552 21:29

   

   
  

  0

  Sorry for the delay...crazy week.  Run this query in SQL to return the last logon time.

  select hud.LastNewRegisterTime as "Last Logon",res.UserAtHost as "SIP Address" from rtcdyn.dbo.HomedUserDynamic hud join

  (

   

   

  Select ResourceId, UserAtHost from rtc.dbo.Resource group by ResourceId, UserAtHost)

  res

  order

   

   

  by "Last Logon"on hud.OwnerId=res.ResourceId

  This will return a list of users ordered from earliest logon time (starting with NULL) to latest.

   

   For OCS 2007 R2 this did not work for me. I had to use the change rtcdyn.dbo.HomedUserDynamic to rtcdyn.dbo.HomedResourceDynamic.
  Then it gave the info I needed.