?
Solved

MS Lync 2010 enabled user count.

Posted on 2011-09-19
12
Medium Priority
?
489 Views
Last Modified: 2012-12-22
Hi Team,

How can i generate a report of the lync enabled users in a excel ot .txt format.
In GUI it bjust shows upto 200 users.

Thanks -
Sujitraj Sancheti
0
Comment
Question by:YogeshSLK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 3
12 Comments
 
LVL 4

Expert Comment

by:wvanschaik71
ID: 36567486
Hi YogeshSLK,

I would use the Csvde tool (available on all windows 2008 domain controllers or on member servers after installing the AD DS and AD LDS Tools feature under Remote Server Administration Tools).

The exact cmd would be > csvde -f c:\users.csv -r (msRTCSIP-UserEnabled=TRUE) -l "displayName,sn,givenname,mail,telephoneNumber,mobile,homephone"

Obviously you can work on the output to include other ad fields you're interested in.
0
 
LVL 8

Expert Comment

by:djjackfrwmml
ID: 36567659
Not that I have found.  The resource table int eh RTC database int he backend has a list of users but I cannot find where the login time, date, active vs inactive info is.  I will dig in as well and try to find out more.
0
 

Author Comment

by:YogeshSLK
ID: 36567883
You guys have mis understood my question. I want to generate the list of users whom we have given the access to use Microsoft Lync 2010 application.

In GUI it just shows up to 200 users .
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 8

Expert Comment

by:djjackfrwmml
ID: 36567919
I understood, unfortunately an easy way does not exist.  Even in the monitoring reports it does not show up.  the only way I know how to get it is through AD or the backend database.  Neither way is easy or necessarily accurate.  It has been somehting I have been investigating for a little while with no real luck.

CSVDE is basically an AD directory export tool that dumps everything into a CSV file and if you know the fields you are looking for that would work, unfortunately I do not know what fields say "I have been enabled for Lync"  That is the part I am looking into for our users.
0
 
LVL 4

Expert Comment

by:wvanschaik71
ID: 36569338
Please be more specific. Is it the last log in time you're interested in? I have added an image of our sysadmin shell we have developed for our boxed Lync solution that shows this info, which is obtained from the backend database indeed. With regards to the AD attributes, the attribute msRTCSIP-UserEnabled=TRUE tells if a user is enabled for Lync. Other fields, starting with msRTCSIP are also Lync related, Active Communications Lync appliance ACS sysadmin shell
0
 
LVL 8

Expert Comment

by:djjackfrwmml
ID: 36569378
NICE wvanschaik71!!!  That is great.  How did you create that and what fileds on the back end did you use?
0
 
LVL 4

Expert Comment

by:wvanschaik71
ID: 36571837
Hi djjackfrwmml, This answer becomes off topic, but the shell is part of the Lync appliance that we sell through an independent reseller channel. Our company aims to get the complexity out of Lync and sell the Lync appliance (named ACS by us) as a pbx though our Telecoms and IT partners. The shell originates back to OCS2007 when we started to bring a stand alone boxed UC solution to our partners. Though i'm willing to advise on some topics, the shell is part of where our company makes money with and the data parts where the information is coming from has been done by our developers using Lync API's, making it hard for me to pinpoint a specific datasource. However if you're interested in selling and deploying Lync appliances, feel free to contact us for partner opportunities at www.activecommunications.eu.
0
 
LVL 8

Expert Comment

by:djjackfrwmml
ID: 36572130
gotcha, I am just impressed that you did it.  I have been looking at that darn backend SQL DB and it is a rat's nest of data.  Congrats on a great solution
0
 

Author Comment

by:YogeshSLK
ID: 36572862
That is not what i am looking for... I need list of users who has permission to use microsoft lync 2010 application.
0
 
LVL 8

Expert Comment

by:djjackfrwmml
ID: 36573057
it sounds like using AD may be the way to go here as wvan pointed out:

With regards to the AD attributes, the attribute msRTCSIP-UserEnabled=TRUE tells if a user is enabled for Lync

Use a tool like CSVDE or LDIFDE to ge the info using the parameters he gave above.

Here is a site that tells how to use CSVDE:

http://www.gfi.com/blog/csvde-means-simplify-active-directory-administration-part-2/
0
 

Accepted Solution

by:
YogeshSLK earned 0 total points
ID: 37337770
i am closing this question as their was no update on this from a very long time.
0
 

Author Closing Comment

by:YogeshSLK
ID: 38715343
Their was no update on my querry hence closing this request.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question