Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Create a site usage Report In Excel

  Asked By: Hector    Date: Nov 12    Category: Sharepoint    Views: 8479

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.



3 Answers Found

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

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

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

Oh yeah, I almost forgot - SQL Server Reporting Services is a nice add-on for
creating reports. It's freely downloadable from Microsoft:

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.