How do I...

• create a Log Info source
• customize an existing report
• schedule a report to run
• setup distribution for a scheduled report
• export the results of a report
• email a report
• resolve usernames in a report
• limit the report lines in a report
• run a report on a specific user
• create a new report
• adjust the bandwidth cost factor
• adjust the view time factor
• know which category a URL is in
• Export my settings
• Import my settings
• Upgrade the bt-LogAnalyzer software
• know what the required fields are for bt-LogAnalyzer to read my log file
• Get data from my SQL Server
• Know what the difference between viewing time and download time
• Setup the bt-LogAnalyzer client and ISA

Q: How do I create a Log Info source?

1. Open up the bt-LogAnalyzer console
2. Right click on Log Info Sources, select New > Log Info Source
3. Select the option used communicate to your log files (Browse the log file folders, ODBC DSN value, or Local MSDE database)
4. Click on the Test button
5. Click the Ok button

TOP

Q: How do I customize an existing report?

1. Open up the bt-LogAnalyzer console
2. Right click on the report you want to customize, and select Properties
3. There are 5 tabs listed: Common Options, Customize, Schedule, Distribution, and Security
4. Select the appropriate tab for your customizations, and click the Ok button

TOP

Q: How do I schedule a report to run?

1. Open up the bt-LogAnalyzer console
2. Right click on the report you want to set a schedule for, and select Properties
3. Click on the Schedule tab
4. Set the schedule options for when the report should run, and click the Apply button
5. Click the Ok button

TOP

Q: How do I setup distribution for a scheduled report?

1. Open up the bt-LogAnalyzer console
2. Right click on the report you want to setup distribution for, and select Properties
3. Click on the Distribution tab
4. There are two options, you can setup the reports to email them, or you can save them to the local system, or a network drive
5. Click the Apply button
6. Click the Ok button

TOP

Q: How do I export the results of a report?

1. Open up the bt-LogAnalyzer console
2. Click the "+" next to Reports
3. Click on the report you wish to export
4. Right click on the Results on the Report, or under the Report
5. Select Export To:
6. There are two options listed there: HTML, or XML
7. Select the files format you wish to export the results
8. Save the report to your local system, or a network share

TOP

Q: How do I email a report?

1. Open up the bt-LogAnalyzer console
2. Click the "+" next to Reports
3. Click on the report you wish to export
4. Right click on the Results on the Report, or under the Report
5. Select Send To:
6. Select mail recipient
7. Type in the email address in select the the email format (HTML, or HTML attachment)

TOP

Q: How do I resolve usernames in a report?

1. Open up the bt-LogAnalyzer console
2. Click the "+" next to Reports
3. Right click on the report you want to resolve the usernames, and click on Properties
4. On the Common Options tab, click on the Advanced button
5. Check the box next to "Resolve User Names"
6. Click the Ok button
7. Click the Ok button

TOP

Q: How do I limit the report lines in a report?

1. Open up the bt-LogAnalyzer console
2. Click the "+" sign next to Reports
3. Right click on the report you want to limit the number of lines for, and select Properties
4. On the Common Options tab, check the box next to Maximum Report Lines, and type in the actual number of lines you want to see in the report

TOP

Q: How do I run a report on a specific user?

1. Open up the bt-LogAnalyzer console
2. Click on the "+" sign next to Reports
3. Right click on the User Audit Details report, and select Properties
4. Click on the Customize tab
5. Click on the Edit button in the Users section
6. Click on the radio button next to Individual users and Groups
7. Click the Add button
8. Select the user from AD, or type in the username
9. Click the Ok button
10. Click the Ok button
11. Right click on the User Audit Details report, and select Generate

TOP

Q: How do I create a new report?

1. Open up the bt-LogAnalyzer console
2. Right click on the Reports
3. Select New > Report
4. Name and customize your report, and click the Ok button

TOP

Q: How do I adjust the bandwidth cost factor?

1. Open up the bt-LogAnalyzer console
2. Right click on Bandwidth Cost Factor, and select Edit
3. Adjust the values, and click the Ok button

TOP

Q: How do I adjust the view time factor?

1. Open up the bt-LogAnalyzer console
2. Right click on Viewing Time Factor and select Edit
3. Adjust the values, and click the Ok button

TOP

Q: how do I know which category a URL is in?

1. Open up the bt-LogAnalyzer console
2. Right click on Category Lookup
3. Type in the URL, or File Ext.
4. Click the Find button

TOP

Q: How do I Export my settings?

1. Open up the bt-LogAnalyzer console
2. Right click on the bt-LogAnalyzer Server
3. Select All Tasks > Settings Export
4. The Export Wizard dialog box will walk you through exporting your settings

TOP

Q: How do I import my settings?

1. Open up the bt-LogAnalyzer console
2. Right click on the bt-LogAnalyzer Server
3. Select All Tasks > Settings Import
4. The Import Wizard dialog box will walk you through importing your settings

TOP

Q: Upgrade to a newest version of bt-LogAnalyzer?

1. Download the latest version of bt-LogAnalyzer and unzip the file to your desktop
2. Open up the bt-LogAnalyzer Console
3. Right click on the bt-LogAnalyzer Server
4. Select All Tasks > Settings Export
5. The Export Wizard dialog box will walk you through exporting your settings
6. Execute the new bt-LogAnalyzer install that you downloaded in step 1
7. Reboot the server

TOP

Q: How do I know what the required fields are for bt-LogAnalyzer to read my log file?

1. Client IP (c-ip)
2. Client User Name (cs-username)
3. Date (date)
4. Time (time)
5. Processing Time (time-taken)
6. Bytes Sent (cs-bytes)
7. Bytes Received (sc-bytes)
8. Protocol (cs-protocol)
9. Operation (s-operation)
10. Object Name (cs-url)
11. Object MIME (cs-mime-type)
12. Result Code (sc-status)

TOP

How do I Get data from my SQL Server?

1. Configure ISA Server to log to SQL Server
   
   
   • Start SQL Server Enterprise Manager
   • Expand Microsoft SQL Server
   • Connect to the SQL Server that you want to host the database files
   • On the Tools menu, click SQL Query Analyzer
   • On the File menu, click Open
   • Open the W3proxy.sql file (On the ISA 2004 CD “ISA\FPC\Program Files\Microsoft ISA Server”)
   • Type the following lines at the top of the script:
     

     Create database weblog  
     Go
     Use weblog  
     Go

   • On the Query menu, click Execute
   • Quit Query Analyzer
   • Press F5 to Update
     
     
2. How to set up SQL Server to accept the Open Database Connectivity (ODBC) from the ISA Server 2004
   
   
   • Start SQL Server Enterprise Manager
   • Expand Microsoft SQL Servers
   • Connect to the SQL Server that you want to host the database files
   • Expand your SQL Server
   • Expand Security, and then right-click Logins
   • Click New Login
   • Use SQL Server Authentication
   • Type a name btLogAnalyzer to identify the logon method in the Name box
   • Click the Database Access tab
   • Click to select the weblog database that you created
   • Under Database roles for <Weblog>, click to select the db_datareader and the db_datawriter check boxes
   • Click OK
   • Quit SQL Server Enterprise Manager
   • Click Start, point to Programs, point to Administrative Tools, and then click Services
   • Right-click the MSSQLSERVER service, and then click Restart
     
     
3. How to set up the ODBC data source
   
   
   • Click Start, point to Programs, point to Administrative Tools, and then click Data Sources (ODBC)
   • Click the System DSN tab, then click Add
   • Under Select a driver for which you want to set up a data source, click SQL Server
   • Click Finish
   • Type the data source in the Name (webconn) box
   • Type a description in the Description box
   • Click the SQL Server that you want to connect to in the Server list
   • Click Next
   • Click With SQL Server authentication using a login ID (btLogAnalyzer) and password entered by the user to use an SQL account for authentication
   • Click to select the Change the default database to check box, and then type the DSN (webconn) that the ISA Server will connect to
   • Click Next, then click Finish
     
     
4. How to configure ISA Server 2004 to log information to an SQL Server database
   
   
   • Start the ISA Microsoft Management Console (MMC)
   • Expand your ISA Server, and click Monitoring
   • Click the Logging Tab
   • On the Task pane, click the Tasks tab, and then select the appropriate task
   • Click Configure Web Proxy Logging to configure the location of the Web Proxy log
   • Click the Log tab, and then click SQL Database
   • Type the DSN in the ODBC data source (webconn) box
   • Type the name of the table in the Table name (WebProxyLog) box
   • Type the account (btLogAnalyzer) that will be used to log on to the SQL Server in the Use this account box
   • Click OK
   • In the ISA MMC, click Apply to save the changes made to the ISA Server 2004
   • Restart the ISA Server 2004-based computer (The system policy rule Allow remote Logging using NetBIOS transport to trusted servers must be turned on to log to an SQL database)
     
     
5. Create a log info source in bt-LogAnalyzer software
   
   
   • Open up the bt-LogAnalyzer console
   • Right click on Log Info Sources, and select new > log info source
   • Click on the radio button next to ODBC DSN
   • Type in the DSN value (webconn), Table (WebProxyLog), Username (btLogAnalyzer), and Password
   • Click the Test button, then the OK button
     
     
6. Configure the bt-LogAnalyzer service
   
   
   • Go to Start > All Programs > Administrative Tools > Services
   • Right click on the bt-LogAnalyzer service, select Properties,  and click on the Login tab
   • Select the radio button next to this account and click on the browse button
   • Select your domain in the Location field, and click the OK button
   • Type in an account name that has administrative rights to the domain
   • Type in the password twice, and click the OK button
   • Stop and re-start the bt-LogAnalyzer service
     
     
7. Run a report in the bt-LogAnalyzer software

TOP

Q: How do I know the difference between viewing time and download time?

1. All of the information in the LogAnalyzer reports either comes straight from, or is based off of, your proxy log files.  In the case of Download Time, proxy logs record how long it takes for a web site to completely download onto a requesting computer.  Viewing Time, on the other hand, is a calculated value.  It takes the number of successfully connected “clicks” a user makes in their browser (recorded as http or https requests in the log file) and multiplies it by the Viewing Time Factor to give you an estimate of how much time a user has spent online.  In LogAnalyzer you have the option to set your Viewing Time Factor.  The default value is 10 seconds.  What this means is that for every individual URL a user accesses, 10 seconds will be counted.  The log files only show when a request is made and how many are made, not how much time a user spends on a page.  As a result, if a user visits www.msnbc.com and leaves their browser on the page for 3 hours, by default only 10 seconds will get recorded.  As I mentioned before, Viewing Time is an estimate, and is usually used more for comparison of users than anything else since there is no way of knowing exactly how long a web page was actually open on a user’s computer.

TOP