SharePoint Log Viewer

SharePoing Log Viewer is a Windows application for reading and filtering Microsoft SharePoint ULS Logs.

Key Features:

Key Features:

• View multiple SharePoint log files at once
• Search by any field
• Filter the log by any field
• File drag & drop support
• Live monitoring for entire farm
• Export filtered log entries
• Bookmark log entries
• Get popup notification of SharePoint log events from system tray
• Receive email notifications on errors
• Redirect log entries to event log

for more info please info please visit http://www.sharepointreferences.wordpress.com

Integrating AD with SharePoint

How to configure SharePoint 2010 to use several different Active Directories for authentication?

In central administration you go to "Application Management" then "Manage service applications" , "User Profile Service Application" , "Configure Synchronization Connections" and there you can create a new connection. After that you can start a sync and it should pull in the accounts from both or more connections.

for more info please info please visit http://www.sharepointreferences.wordpress.com

Integrating SharPoint 2010 and Sql Reporting Services 2008

Integrating SharPoint 2010 and Sql Reporting Services 2008

We can configure reporting services with few easy steps:
1. Configuring Web Service URL
2. Create a Report Database
3. Creating a Report Manager URL
4. Report Service Integration
5. Adding a Report Server to the Integration
6. Verifying the server
Simply go to SQL Server 2008 à Configuration Tools–>Reporting Services Configuration Manager and choose Web Service URL and fill the information.

Next we need to create a database i.e. Report Database

Connect to the database where you want your Report Data to be stored:

Check the connection by clicking on the Test Connection once that is done click next

Mention the database name and Report Server Mode depending on the level, I mentioned Sharepoint Integrated Mode.
Specify the credentials that the report server will use to connect to the database.

Review configuration.

click next

Step3: Creating a Report Manager
What this does is that it configures the IIS for you depending on what Virtual Directory names you had declared.

Step4:
Reporting Service Integration
go to central admin– general application setting — reporting service integration

enter the fields that are required

check for the activation message

Step5:
Adding a Report Server to the Integration

Step6:
Checking the server by uploading a report
go to site setting–> in site collection administrator –> site collection feature and activate report server integration

try to use the SQL Server Reporting Services Webpart:


try to upload a report by using document library

for more info please info please visit http://www.sharepointreferences.wordpress.com

Web Analytic Reports:

Basically we have 3 categories of SharePoint Web Analytic  Reports:

1. Traffic
2. Search
3. Inventory

Reports are aggregated for various SharePoint entities. i.e. we can take consideration of sites, site collection, and web application for each farm. We can also aggregate the reports per search service application. By default the reports show the data for a period of 30 days. We can change this and we can even view data up to 25months by using analyze tab.

Here we have 2types of reports

1. Trend Reports
2. Rank Reports

Trend Reports show how a particular metric is doing over a period of time, while Rank Report show the top results for a particular metric. We can even apply filters and check the reports as per the need i.e. filters like string match in the URL, user name, queries, browser and others.

Below figure is example of trend reports

Example of Rank Reports

In the above fig we can see the top pages sorted on the Number of page views for a default of 30 days.

Let us see Trend Reports in detail:

Trend Reports:

1. Number of Page Views i.e. total number of pages views every day.
2. Number of daily unique visitors i.e. total number of unique visitors each day. SharePoint authenticated users and anonymous users i.e. using IP ADDRESS are counted as visitors.
3. Number of Referrers i.e. total number of unique URL’s external to the current entity from where the users navigated to the current entity.

Rank Reports:

1. Top Pages: Most viewed pages in the current entity.
2. Top Visitors: Most frequent visitors of the current entity.
3. Top Referrers: Top URL’s external to the current entity from where users navigated to the current entity.
4. Top Destinations: Similar to Referrers, these are the top external URL’s that the user visited from the current entity.
5. Top Browsers: Top browsers being used to visit the current entity.                                                      Search Reports
   The search reports capture the user behavior information related to the queries on the site.
   Trend Reports
   1.     Number of Queries: Total number of queries each day.
   Rank Reports
   1.    Top Queries: Most issued queries per day.
   2.    Failed Queries: Most issued queries for which either there were no results or the user did not click on any results.
   3.    No Result Queries: Most issued queries for which no results were returned.
   Other Reports
   1.    Best Bet Suggestion Report: Recommends URLs as most likely results for particular search queries based on analysis of usage patterns. The site administrators can accept or reject these suggestions. If they accept, the corresponding query-URL pair is added to the search keywords list.
   2.    Best Bet Usage: Shows how Best Bet suggestions are doing over time. For every Best Bet query issued, the report shows the percentage of clicks on the Best Bet URL compared to other URLs.
   3.    Best Bet Action History Report: Tracks the actions performed by the site administrator on the ‘Best Bet Suggestion’ Report.

for more info please info please visit http://www.sharepointreferences.wordpress.com