CA MICS WEB Analyzer Option (WEB) Queries › WEBMRA - 30 Day Web Server Request Activity › Query Defaults

Query Defaults

• HARCPU DAYS timespan file: Cycle 01
• WEBWRA DAYS timespan file: Cycles 01 – 30
• Derivations:

  DATE

  DATEPART(ENDTS)

  YYYYMMDD

  PUT(DATE,YEAR4.) || '-' || PUT(MONTH,Z2.) || '-' || PUT(DAY,Z2.)

  CPCUID

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