CA MICS WEB Analyzer Option (WEB) Queries › WEBDRA– Daily Web Server Request Analysis › Query Defaults

Query Defaults

• HARCPU DAYS timespan file: Cycle 01
• WEBWRA DAYS timespan file: Cycles 01 and 02
• A User Code task selects data from yesterday only
• Derivations:

  DATE

  DATEPART(ENDTS)

  CPCUID

  TRIM(CPUMOD)||'-'||TRIM(CPCMODID)||'-Serial: '||SUBSTR(CPCSEQNB,12,5)