I don't see an exposed unique key on actlog/summary/events. I would like to get it in the same order TSM v3,4,5 did by default- in the sequence the rows were posted. In particular, I would like to see the start session at the top and the end session at the bottom. I realize the "events" can be posted in slightly different sequence, due to multi-threading/multi-tasking. Maybe a unique key column, or use that .000000 at the end of the date_time to actually mean something. Or maybe I am missing something in the manuals.
Thanks for any pointers. Select w/o order by: dsmadmc -id=rcowen -pa=pxxxxxx -comma select * from actlog where DATE_TIME between '05/05/2009 07:00:00' and '05/06/2009 07:00:00' > f:\actlog.csv F:\>find "2650" actlog.csv ---------- ACTLOG.CSV 2009-05-05 13:48:33.000000,4958,I,ANE4958I Total number of objects updated: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4960,I,ANE4960I Total number of objects rebound: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4957,I,ANE4957I Total number of objects deleted: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4970,I,ANE4970I Total number of objects expired: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,403,I,ANR0403I Session 2650 ended for node LAB-1750-151 (WinNT). (SESSION: 2650),SERVER,,,,,,,2650, 2009-05-05 13:48:33.000000,4953,I,ANE4953I Total number of objects archived: 81 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:29.000000,406,I,ANR0406I Session 2650 started for node LAB-1750-151 (WinNT) (Tcp/Ip LAB-1750-151(4007)). (SESSION: 2650),SERVER,,,,,,,2650, 2009-05-05 13:48:33.000000,4952,I,ANE4952I Total number of objects inspected: 81 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4959,I,ANE4959I Total number of objects failed: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4961,I,ANE4961I Total number of bytes transferred: 17.50 MB (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4963,I,ANE4963I Data transfer time: 0.92 sec (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4966,I,"ANE4966I Network data transfer rate: 19,419.35 KB/sec (SESSION: 2650)",CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,26 50, 2009-05-05 13:48:33.000000,4967,I,"ANE4967I Aggregate data transfer rate: 5,911.63 KB/sec (SESSION: 2650)",CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,26 50, 2009-05-05 13:48:33.000000,4968,I,ANE4968I Objects compressed by: 0% (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4964,I,ANE4964I Elapsed processing time: 00:00:03 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,2507,I,ANR2507I Schedule ARCHIVE_HOURLY for domain STANDARD started at 05/05/2009 13:48:18 for node LAB-1750-151 completed successfully at 05/05/2009 13:48:33. (SESSION: 2650),SERVER,,,,,,,2650, Select with order by: dsmadmc -id=rcowen -pa=xxxxxx -comma select * from actlog where DATE_TIME between '05/05/2009 07:00:00' and '05/06/2009 07:00:00' order by date_time > f:\actlog.csv F:\>find "2650" actlog.csv ---------- ACTLOG.CSV 2009-05-05 13:48:29.000000,406,I,ANR0406I Session 2650 started for node LAB-1750-151 (WinNT) (Tcp/Ip LAB-1750-151(4007)). (SESSION: 2650),SERVER,,,,,,,2650, 2009-05-05 13:48:33.000000,4958,I,ANE4958I Total number of objects updated: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4960,I,ANE4960I Total number of objects rebound: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4957,I,ANE4957I Total number of objects deleted: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4970,I,ANE4970I Total number of objects expired: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,403,I,ANR0403I Session 2650 ended for node LAB-1750-151 (WinNT). (SESSION: 2650),SERVER,,,,,,,2650, 2009-05-05 13:48:33.000000,4953,I,ANE4953I Total number of objects archived: 81 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4952,I,ANE4952I Total number of objects inspected: 81 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4959,I,ANE4959I Total number of objects failed: 0 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4961,I,ANE4961I Total number of bytes transferred: 17.50 MB (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4963,I,ANE4963I Data transfer time: 0.92 sec (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4966,I,"ANE4966I Network data transfer rate: 19,419.35 KB/sec (SESSION: 2650)",CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,26 50, 2009-05-05 13:48:33.000000,4967,I,"ANE4967I Aggregate data transfer rate: 5,911.63 KB/sec (SESSION: 2650)",CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,26 50, 2009-05-05 13:48:33.000000,4968,I,ANE4968I Objects compressed by: 0% (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,4964,I,ANE4964I Elapsed processing time: 00:00:03 (SESSION: 2650),CLIENT,LAB-1750-151,,ARCHIVE_HOURLY,STANDARD,2650,LAB-1750-151,265 0, 2009-05-05 13:48:33.000000,2507,I,ANR2507I Schedule ARCHIVE_HOURLY for domain STANDARD started at 05/05/2009 13:48:18 for node LAB-1750-151 completed successfully at 05/05/2009 13:48:33. (SESSION: 2650),SERVER,,,,,,,2650, The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. To reply to our email administrator directly, please send an email to postmas...@sbsplanet.com.
