Windows Server

Kevin · Guest

Are there any utilities (resource kit, etc.) available for parsing the
LCS 2005 SIP flat file logs into something that surfaces some useful
statistics? What I'm mostly interested in seeing is the number of
unique users each day, the version of client they are using, and
perhaps even how many messages were sent/received by each.

Alternatively, if there is a way to extract some of this information
from the LCS database, that would be good to. At least information on
current users should be available there.

The LCS 2005 console is woefully lacking in displaying this type of
information, as compared to say Exchange which reports users last
login/logout/client version, etc.

We do have MOM 2005 and have the just released LCS 2005 management
pack installed, but it doesn't really give me the kind of usage info I
need .. more on performance stats.

Dhigha D Sekara · Guest

you got it... a utility to parse FFL logs will be shipped as part of the
reskit of LCS2005( due very soon... may be another week or so)

another tool dbanalyze will be shipping as part of the reskit as well which
will help to report information from the database..

thanks,
Dhigha

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup

Kevin · Guest

OK .. I've got the reskit installed, but I'm not finding a utility to
give me the information I was looking for (report of users, when they
were last actually active, and what client version they are using).

I see dbanalyze that shows me some of this one user at a time.

I see a utility to set flat file log settings, but not anything to
parse it.

Could you point me to which part of the reskit you had in mind?

Dhigha D Sekara · Guest

dbreport ( this is part of the server installation itself) should give you
details on the activity of a user. It doesnt report the client version
though.

sipview is the utility used to parse FFL logs...

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup

Kevin · Guest

Thanks for the response, but that only shows me a count.

The intent here is to find out who is and isn't using LCS, so we can
enable (and license) only those who use it for their work, not the
ones that demanded it to play with it once several months ago.

Dhigha D Sekara · Guest

dbanalyzer per user reportings shows the last register time of a user..

e.g
User : dhighas500@dhighasdc.nttest.microsoft.com
------------------------------------------------
.....
Last Register Time : 1/18/2005 5:46:00 PM
<--->

Would this work for you..?

Report for all the users can be generated using a script on top of
dbanalyze...
I will check if any of our tools does this out-of-box...

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup

Jeff · Joined: 24 Jan 2006 Posts: 1

I'm not very good with SQL, but I used the SQL query analyzer with the following command

select rtc.dbo.Resource.ResourceId, rtc.dbo.Resource.UserAtHost, rtc.dbo.HomedResourceRegisterTime.LastRegisterTime from Resource, HomedResourceRegisterTime where rtc.dbo.Resource.ResourceId = rtc.dbo.HomedResourceRegisterTime.ResourceId

This produced a list of users' email addresses and the last time they logged in. You can then export this data to Excel and sort accordingly. I used it to ask my users if they were going to use the service and if they are not I will disable them.

	Windows Server Forum Index -> Live Communications Server	All times are GMT
Page 1 of 1