Table of Contents

TMSS10LogStatsPrintDB

TMSS10LogStatsPrintDB [-R date range] [-h database home file]

Description

TMSS10LogStatsPrintDB prints the contents of the Journal database.

Options

Technical Support

The TapeTrack Software is commercially supported by a full time help desk staff. If you are experiencing problems or want some advice on how to configure or use the product please see the Accessing Technical Support page.

Example

Command line syntax

TMSS10LogStatsPrintDB -R M-1:m-1  -h "%TMSS10DB%"

Output

             System: TapeTrack
 Report Description: TapeTrack Journal Print
    Production Time: Friday, July 19, 2019 - 10:06:52 (AUS Eastern Standard Time)
       Report Width: 133 bytes

 Date       Time     Type       Data
 ---------- -------- ---------- ----------------------------------------------------------------------------------------------------
 2019-04-30 09:14:28 LOGIN      Session=221.15,UserID=doco,Client=TapeTrack TapeMaster,IP=127.0.0.1
 2019-04-30 09:17:51 SNAP       Customer=0004,Media=LTO,Repository=INIT,Total=7,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=0005,Media=LTO,Repository=LIBR,Total=3,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=0005,Media=LTO,Repository=OFFS,Total=46,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=2081,Media=LTO,Repository=LIBR,Total=1816,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=A621,Media=LTO,Repository=LIBR,Total=1219,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=A621,Media=LTO,Repository=OFFS,Total=1,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=DBS,Media=3490,Repository=LIBR,Total=166,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=SFTP,Media=AL,Repository=LIBR,Total=97,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=SFTP,Media=RC,Repository=VMS,Total=4,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=SL01,Media=LTO,Repository=OFFS,Total=40,Max Slot=20
 2019-04-30 09:17:51 SNAP       Customer=US01,Media=CONT,Repository=LIBR,Total=21,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US01,Media=CONT,Repository=OFFS,Total=1,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US01,Media=LTO,Repository=LIBR,Total=17,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US01,Media=LTO,Repository=OFFS,Total=17,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US02,Media=LTO,Repository=LIBR,Total=13,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US02,Media=LTO,Repository=OFFS,Total=9,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US02,Media=LTO,Repository=RACK,Total=1,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US03,Media=CONT,Repository=LIBR,Total=20,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US03,Media=CONT,Repository=OFFS,Total=2,Max Slot=0
 2019-04-30 09:17:51 SNAP       Customer=US03,Media=LTO,Repository=LIBR,Total=12,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US03,Media=LTO,Repository=OFFS,Total=22,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US04,Media=CONT,Repository=LIBR,Total=11,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US04,Media=CONT,Repository=OFFS,Total=2,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US04,Media=LTO,Repository=LIBR,Total=27,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US04,Media=LTO,Repository=TEMP,Total=18,Max Slot=40
 2019-04-30 09:17:52 SNAP       Customer=US05,Media=LTO,Repository=LIBR,Total=1300,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US06,Media=BINS,Repository=LIBR,Total=4,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US06,Media=BINS,Repository=OFFS,Total=1,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US06,Media=LTO,Repository=LIBR,Total=479,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US07,Media=LTO,Repository=LIBR,Total=1,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US07,Media=LTO,Repository=OFFS,Total=11,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US08,Media=LTO,Repository=LIBR,Total=6,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US08,Media=LTO,Repository=OFFS,Total=1,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US08,Media=PERO,Repository=PERO,Total=7,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US09,Media=LTO,Repository=LIBR,Total=22,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US09,Media=LTO,Repository=OFFS,Total=36,Max Slot=83
 2019-04-30 09:17:52 SNAP       Customer=US09,Media=LTO6,Repository=LIBR,Total=310,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US09,Media=LTO6,Repository=OFFS,Total=1,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US09,Media=LTO7,Repository=LIBR,Total=13,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US09,Media=LTO7,Repository=OFFS,Total=2,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US10,Media=LTO,Repository=LIBR,Total=3,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US10,Media=LTO,Repository=QQ,Total=1,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US11,Media=LTO,Repository=LIBR,Total=12,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US11,Media=LTO,Repository=OFFS,Total=2,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US12,Media=LTO,Repository=DEST,Total=1,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US12,Media=LTO,Repository=OFFS,Total=2204,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US13,Media=LTO2,Repository=DEST,Total=270,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US13,Media=LTO2,Repository=OFFS,Total=1935,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US14,Media=LTO,Repository=LIBR,Total=29497,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US15,Media=LTO,Repository=LIBR,Total=1000,Max Slot=0
 2019-04-30 09:17:52 SNAP       Customer=US15,Media=OTHR,Repository=OFFS,Total=3,Max Slot=0
 2019-04-30 09:28:15 LOGOUT     Session=221.15.287,Queries=287,Received=17092,Sent=44116
 2019-04-30 09:30:46 LOGIN      Session=221.16,UserID=doco,Client=TapeTrack Lite,IP=127.0.0.1
 2019-04-30 09:31:28 VOLADD     Session=221:16:18,Volume=US04.LTO.FFFF,From=LIBR.0
 2019-04-30 09:32:13 VOLADD     Session=221:16:45,Volume=US04.LTO.FFF1,From=LIBR.0
 2019-04-30 09:32:25 VOLMOVE    Session=221:16:50,Type=Official,Volume=US04.LTO.FFF1,From=LIBR.0,To=OFFS.0
 2019-04-30 09:32:59 VOLADD     Session=221:16:62,Volume=US04.LTO.FFF2,From=LIBR.0
 2019-04-30 09:33:01 VOLMOVE    Session=221:16:66,Type=Official,Volume=US04.LTO.FFF2,From=LIBR.0,To=DES.0
 2019-04-30 09:33:11 LOGOUT     Session=221.16.69,Queries=69,Received=4172,Sent=8892
 2019-04-30 09:33:13 LOGIN      Session=221.17,UserID=doco,Client=TapeTrack TapeMaster,IP=127.0.0.1
 2019-04-30 09:33:35 LOGIN      Session=221.18,UserID=doco,Client=TapeTrack Lite,IP=127.0.0.1
 2019-04-30 09:33:55 VOLADD     Session=221:18:20,Volume=US04.LTO.FFF3,From=LIBR.0
 2019-04-30 09:33:58 VOLMOVE    Session=221:18:25,Type=Official,Volume=US04.LTO.FFF3,From=LIBR.0,To=OFFS.0
 2019-04-30 09:34:04 LOGOUT     Session=221.18.28,Queries=28,Received=1648,Sent=4496
 2019-04-30 09:34:16 LOGIN      Session=221.19,UserID=doco,Client=TapeTrack Lite,IP=127.0.0.1
 2019-04-30 09:48:20 LOGOUT     Session=221.19.48,Queries=48,Received=2720,Sent=10912
 2019-04-30 09:48:20 LOGOUT     Session=221.17.26,Queries=26,Received=1656,Sent=15800
 2019-04-30 10:18:29 SNAP       Customer=0004,Media=LTO,Repository=INIT,Total=7,Max Slot=0
 2019-04-30 10:18:29 SNAP       Customer=0005,Media=LTO,Repository=LIBR,Total=3,Max Slot=0
 2019-04-30 10:18:29 SNAP       Customer=0005,Media=LTO,Repository=OFFS,Total=46,Max Slot=0
 2019-04-30 10:18:29 SNAP       Customer=2081,Media=LTO,Repository=LIBR,Total=1816,Max Slot=0
 2019-04-30 10:18:29 SNAP       Customer=A621,Media=LTO,Repository=LIBR,Total=1219,Max Slot=0
 2019-04-30 10:18:30 SNAP       Customer=A621,Media=LTO,Repository=OFFS,Total=1,Max Slot=0
 2019-04-30 13:06:25 LOGIN      Session=4.21,UserID=tapemaster,Client=TapeTrack TapeMaster,IP=127.0.0.1
 2019-04-30 13:06:36 PWRESET    Session=4.21,UserID=doco,Client=TapeTrack TapeMaster,IP=127.0.0.1
 2019-04-30 13:09:41 LOGOUT     Session=221.17.26,Queries=26,Received=1656,Sent=15800
Changelog
2021-05-02Added support for password reset
2018-08-12Added support for listing Volume Rename
2016-12-21Enhanced argument parser to allow arguments in format *FI:filename that allows loading of arguments from a file
2015-08-24Changed hascontents to contentcount and change contentcount to a filter rather than bool
2015-08-24Added iscontainer and hascontents to the config file filter logic
2015-05-16Added environmental varialbe TMSSCANFILEUNQUALIFIED which will load and check volumes without Customer-ID and Media-ID qualifiers
2015-05-16Added environmental varialbe TMSSSCANFILENOPARSE which will presume scanfile items are only Volumes and not parse them, saving time
2015-05-16When loading scanfile from import definition, added CUSTOMER and MEDIA keywords to set defaults
2015-05-16When loading scanfile from import definition, changed keyword from VOLUME to BARCODE
2015-05-16Added TMSSUNQUALIFIEDVOLUME environmental variable which forces all barcodes to be printed without Customer-ID and Media-ID
2015-05-04Added support for AD passwords to all command line programs (check for environmental variable TMSSNOMD5)
2015-04-07Reverted database from 6.1.19 to 5.3.28 please contact support before upgrading
2014-11-19Changed server argument parser to allow colon in password to support z/OS DD name files
2014-10-26Upgraded development environment from Visual Studio 2012 to Visual Studio 2013
2014-08-14Upgrade database from 6.0.20 to 6.1.19