Accessing Raw Data for Web Log

Preparing Web Log Data for SAS IT Resource Management

SAS IT Resource Management can process the following types of Web Log files:
  • Common Log Format (CLF) that can be produced by Microsoft and Apache Web Servers
  • Extended Log Format (ELF)
  • Microsoft IIS original format
  • Oracle WebLogic
SAS IT Resource Management examines the file to determine which type it is, without the type having to be specified. However, some Web logs are produced with different delimiters than the expected default. For example, Oracle WebLogic uses a format very similar to Extended Log Format. However, it uses a tab character instead of a space. This delimiter must be specified in the staging transformation properties or supplied as part of the Adapter Setup wizard prompts.
In addition, some Web logs do not provide information about the machine that they were running on or what Web site they were associated with. For this reason, you can also specify the machine and sitename as parameters to the staging transformation or Adapter Setup wizard prompts. Web log files can be concatenated to form one input stream, but they must all have the same Web log format.