MAP toolkit software usage tracker
-
Wednesday, December 12, 2012 2:11 PMHow to configure usage tracker in MAP 8.0 so that it only identifies share Point and the clients that are using it.
vicky ramphal
All Replies
-
Thursday, December 13, 2012 7:17 PMModerator
For the SharePoint scenario detail page to show any information all three of the "Steps to Complete" must be completed. It doesn't need to actually parse any logs, but that those steps ran. You can generate the report without going through the "Steps to Complete" to see what SharePoint servers have been discovered so far.
To get the CAL info, you have to get the IIS logs and make sure that the logs are correctly configured. This is described in the Getting Started Guide. Although we say 90 days of logs, the real value is going to depend on your environment and the amount of time that will cover typical usage which could be a month, maybe more, maybe less, you would know better.
This Wiki article describes how to import multiple logs into the log parser.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.
- Proposed As Answer by Michael Switzer [MSFT CSG]Moderator Thursday, December 13, 2012 7:23 PM
-
Thursday, December 13, 2012 8:30 PMIIS logging is enabled and we followed the steps laid out in the guide. However, the issue is that the tool is not showing us how many users are accessing the SharePoint server. The servers were discovered but devices and users on the SharePoint Server Usage Summary page are showing up as zero.
vicky ramphal
-
Thursday, December 13, 2012 8:42 PMModeratorIs the date range set to cover the dates that are in the logs?
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.
-
Monday, December 17, 2012 2:02 PMYes the date range are set to cover the dates in the log and we still are unable to see the users who are accessing the sharepoint server. what else we could try?
vicky ramphal
-
Monday, December 17, 2012 11:58 PMModerator
Run this SQL query against the database and post the results:
SELECT TOP 10 * FROM [UT_Core].[UsageRecords]
If you are not using your own installed MAPS instance of SQL Server, then you are using what MAP installed which is SQL Server LocalDB. To connect to local DB you need SQL Server Management Studio 2012 and the server name is:
(localdb)\maptoolkit
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.
-
Thursday, December 27, 2012 12:43 PM
I ran the query and the results returned nothing (0 rows affected).
Do you have anymore suggestions? Anything else that I can try?
vicky ramphal
-
Thursday, December 27, 2012 6:28 PMModerator If that query returned 0 results, that means that MAP did not parse any log files. You need to import the IIS logs and then have MAP parse them in order to see any user and device access information.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.
- Proposed As Answer by Michael Switzer [MSFT CSG]Moderator Thursday, December 27, 2012 6:28 PM
-
Monday, December 31, 2012 12:17 PMWe recollected the logs, parsed them and we are still seeing the same result for the SharePoint Server Usage Tracking: 0 devices and 0 users. However, the results are displaying 8 SharePoint Servers and 2404 IIS log files that were parsed. Also, the only sections that show any figures for devices and users are "Combined Products", "Active Devices and Users" and "Exchange Server".
Do you think we're missing any step in the process?vicky ramphal
-
Thursday, January 03, 2013 5:42 PMModerator
Did you configure IIS logging in the W3C log file format (called “W3C Extended” on some operating systems) with the following fields included:
- date
- time
- s-sitename
- s-computername
- s-ip
- s-port
- cs-uri-stem
- cs-uri-query
- cs-username
- c-ip
- sc-status
SharePoint or IIS administrators might use W3C logging for other reasons. If these administrators require additional fields to be logged, they can add those fields to the configuration. However, administrators should not remove any of the fields that the Software Usage Tracker requires.
The supported versions of SharePoint are:
- Microsoft Office SharePoint Portal Server 2003
- Microsoft Office SharePoint Server 2007
- Microsoft Office SharePoint Server 2010
For information about enabling W3C logging in IIS, see:
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.
- Marked As Answer by vikiy Thursday, January 03, 2013 6:58 PM
-
Thursday, January 03, 2013 6:57 PM
Thank you very much, we were successful. We were able to change the IIS log file format to W3C and collect the information for the fields you listed and we were able to get results for users and devices on the SharePoint usage tracking.
vicky ramphal
.png)
