We want to run ARSDOC Query against the System Load table to obtain daily counts for some of our cmod application loads. However when we supply the date range we are looking for, using the ODDAT_LOAD_TIME, the results do not match what we see in the CMOD Client. How can we make this work and get proper counts for the proper dates?
OSHELL /u/arssp/product/bin/arsdoc query -
-h ARSSP -
-G 'System Load' -
-d /u/arsss/tmp1 -
-o LOADCNTS.GIAUTOF.out -
-e , -
-i "WHERE -
ODDAT_LOAD_TIME >= '2021-11-04 00:00:00.000000' -
AND ODDAT_LOAD_TIME < '2021-11-05 00:00:00.000000' -
AND APPL_NAME LIKE 'GIAUTOF%'" -
-v
VIEW FROM CMOD CLIENT
2021-11-05 21:08:42.328850 FEDEXPDF16002 GIAUTOF-V01
2021-11-04 21:08:25.774097 FEDEXPDF16002 GIAUTOF-V01
2021-11-03 21:05:20.620995 FEDEXPDF16002 GIAUTOF-V01
2021-11-02 21:07:43.251008 FEDEXPDF16002 GIAUTOF-V01
ARSDOC QUERY RESULTS:
Output:
11/03/21 21:05:20,FEDEXPDF16002,GIAUTOF-V01