[ADSM-L] TSM v6 How to SELECT output sequence of actlog (summary) in tru

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 
postmaster AT sbsplanet DOT com.
[ADSM-L] TSM v6 How to SELECT output sequence of actlog (summary) in true date time sequence?
