CA MICS Tape Analyzer Option (TAP) Queries › StorageTek VSM Queries › STKCDA – STK VSM Daily VTV Mounts and Concurrent Drive Use › Query Defaults

Query Defaults

• SVTVMR DETAIL timespan file: Cycles 01-02
• SVTVDR DETAIL timespan file: Cycles 01-02
• User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ; (Both steps)
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  SEQ

  =1 for VMR file, =2 for VDR file

  VTDMNTM, VTDAVTM, VTDMXTM, SVTVTDCT, SVTMNVTD, SVTAVVTD, SVTMXVTD, SVTVTDTM, and SVTVTD

  Complex calculations in User Code step analyzing VMR and VDR records