Creating a Web Part to Display Search Data for SharePoint Portal Server

Creating a Web Part to Display Search Data for SharePoint Portal Server

Creating a Web Part to Display Search Data from SharePoint Portal Server 2003
Rohit Puri
Rahul Sakdeo
Michael Talley
Christopher Hall
Gabe Bratton
Microsoft Corporation

August 2004

Applies to:
Microsoft Office SharePoint Portal Server 2003

Summary: Learn how to collect search-related data from a computer running SharePoint Portal Server and to create a Web Part to view and filter the collected data as data within a date range, as data for a day, and as data for a user. Understand how to load Internet Information Service (IIS) log items log file items into a SQL Server database using a SQL DTS package and stored procedures, and how to create a Web Part to display the data in a SharePoint Portal Server page. (21 printed pages)

Contents
Introduction
Store the Data: Create the Database, Related Stored Procedures, and the DTS Package
Create a Web Part to Present Search Data
A Note About Dates
Conclusion

EROL MVP SPS
www.mysps.info