Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Create a site usage Report In Excel

Asked By: Hector Burns Date: Nov 12, 2003 Category: Sharepoint Views: 560

I am trying to create a site usage report as excel pivot table

Has anybody done this before.

If yes please share the process with me.

As far as my idea goes we have to decrypt the log files into a seperate file and load it into a database and connect an exccel pivot table to that data source.

I am having issues with decrypting the files.

Tagged:create site usage report in excel

3 Answers Found

Answer #1 Answered By: Francisco Simpson Answered On: Nov 12, 2003

this is interesting, if the STS or IIS logs are accessable via a XML Web Service then yes you shoudl be able to write some VBA code to manipulate them.. does anyone know the answer to that?

Answer #2 Answered By: Saul Cobb Answered On: Nov 12, 2003

Configure IIS to log via ODBC to a database (standard feature). Then, access the
database via XML for SQL, which is supported in SQL Server 2000.

Answer #3 Answered By: Karl Reid Answered On: Nov 12, 2003

Oh yeah, I almost forgot - SQL Server Reporting Services is a nice add-on for
creating reports. It's freely downloadable from Microsoft:
http://www.microsoft.com/sql/reporting/default.asp

Didn't find what you were looking for? Find more on Create a site usage Report In Excel Or get search suggestion and latest updates.