| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| cli:list_added_at_repository [2018/08/07 15:46] – dcumming | cli:list_added_at_repository [2025/01/21 22:07] (current) – external edit 127.0.0.1 |
|---|
| ====== Volumes Added Within A Defined Date Range, Currently Located In A Selected Repository ====== | ====== Volumes Added Within A Defined Date Range, Currently Located In A Selected Repository ====== |
| |
| Listing all volumes added to TapeTrack within a defined range of dates and currently located within a selected repository is a two step process. | Listing all [[object:volume|Volumes]] added to TapeTrack within a defined range of dates and currently located within a selected [[object:repository|Repository]] is a two-step process. |
| |
| You must first extract an inventory listing of all volumes added between the specified range of dates. Then use that file to compare against a listing of all volumes located in the selected repository and extract all volumes that appear in both inventories and export to file. | You must first extract an inventory listing of all [[object:volume|Volumes]] added between the specified range of dates. Then use that file to compare against a listing of all [[object:volume|Volumes]] located in the selected [[object:repository|Repository]] and extract all [[object:volume|Volumes]] that appear in both Inventories and export to file. |
| |
| The comparison of the volumes within the files also requires the use of a configuration file and a definition file to extract the data in the correct format. | The comparison of the [[object:volume|Volumes]] within the files also requires the use of a Configuration file and a Definition file to extract the data in the correct format. |
| |
| {{cli_date_range_repository.png}} | {{cli_date_range_repository.png}} |
| ===== Extracting An Inventory Of Volumes Added Within A Defined Date Range ===== | ===== Extracting Volumes Added Within A Defined Date Range ===== |
| |
| Using the command line program [[TMSS10ListHistory]], along with the attributes: | Using the command line program [[TMSS10ListHistory]], along with the Attributes: |
| * -S user:-password@server for logon access | * ''-S user:-password@server'': Logon access |
| * -R "YYYY-MM-DD:YYYY-MM-DD" to specify the date range | * ''-R "YYYY-MM-DD:YYYY-MM-DD"'': Specify the date range required. |
| * -t "*Added*" to only extract volume added records | * ''-t "*Added*"'': Extract only [[object:volume|Volume]] Added records |
| * -V "CUST.MEDIA.*" to limit customer and media types extracted if required | * ''-V "CUST.MEDIA.*"'': Limit [[object:customer|Customer]] and [[object:media|Media Types]] extracted if required |
| |
| Output from this process needs to be captured and written to file using stdout. | Output from this process is captured and written to file using stdout. |
| |
| To extract all volumes added between the start of the year 2000 and the end of 2010 and write to file historyOut.txt | To extract all [[object:volume|Volumes]] added between the start of the year 2000 and the end of 2010 and write to file ''historyOut.txt'' |
| |
| <sxh plain;> | <code plain;> |
| TMSS10ListHistory -S user:-password@server -R "2000-01-01:2010-12-31" -t "*Added*" -V "*.*.*" > historyOut.txt | TMSS10ListHistory -S user:-password@server -R "2000-01-01:2010-12-31" -t "*Added*" -V "*.*.*" > historyOut.txt |
| </sxh> | </code> |
| |
| |
| ===== Configuration File ===== | ===== Configuration File ===== |
| |
| The configuration file is used for traversal of the history (volumes added) file for comparison of volumes currently in the selected repository. | The configuration file is used for traversal of the history ([[object:volume|Volumes]] added) file for comparison of [[object:volume|Volumes]] currently in the selected [[object:repository|Repository]]. |
| |
| The following example instructs TapeTrack to compare each volume ID to the scanfile, if it is present include it in, otherwise skip it and move to the next volume. | The following example instructs TapeTrack to compare each [[object:volume|Volume-ID]] to the Scanfile, if it is present include it in the output file, otherwise skip it and move to the next [[object:volume|Volume]]. |
| |
| <sxh plain;> | <code plain;> |
| traversal | traversal |
| { | { |
| ); | ); |
| }; | }; |
| </sxh> | </code> |
| |
| ===== Definition File ===== | ===== Definition File ===== |
| |
| The definition file (default.ttidef) is used to instruct TapeTrack how the data is formatted in the extracted file. | The [[concepts:definition_file|Definition File]] (default.ttidef) is used to instruct TapeTrack how the data is formatted in the extracted file. |
| |
| <sxh plain;> | <code plain;> |
| # input file for volume comparison (TMSS10ListHistory output) | # input file for Volume comparison (TMSS10ListHistory output) |
| SetFile("historyOut.txt"); | SetFile("historyOut.txt"); |
| |
| # extract volume ID | # extract Volume-ID |
| Extract(BARCODE, 1, 15, 0); | Extract(BARCODE, 1, 15, 0); |
| |
| # exclude any line starting with - | # exclude any line starting with - |
| AddString(Exclusion, 0, " -*"); | AddString(Exclusion, 0, " -*"); |
| </sxh> | </code> |
| |
| ===== Inventory Of Volumes Added Within A Defined Date Range Located In A Specified Repository ===== | ===== Inventory Of Volumes Added Within A Defined Date Range Located In A Specified Repository ===== |
| |
| Using the list of volumes added between the defined date range, we now compare that list to the inventory located at the specified repository and output the volumes to file. | Using the list of [[object:volume|Volumes]] added between the defined date range, we now compare that list to the [[object:volume|Volumes]] located at the specified [[object:repository|Repository]] and output the [[object:volume|Volumes]] to file (inventory_out.txt). |
| |
| <sxh plain;> | <code plain;> |
| TMSS10Inventory -S tapemaster:-@localhost -V "*.*.*@OFFS" -c "inventory.cfg" > inventoryout.txt 2> inventoryerr.txt | TMSS10Inventory -S tapemaster:-@localhost -V "*.*.*@OFFS" -c "inventory.cfg" > inventory_out.txt 2> inventory_err.txt |
| </sxh> | </code> |
| |
| or if you prefer CSV output with unqualifed volume ID's, set the environmental variables TMSSREPORTFORMAT and TMSSUNQUALIFIEDVOLUME. | or if you prefer CSV output with [[concepts:unqualified_barcode|Unqualified]] [[object:volume|Volume-ID's]], set the [[variable:start|Environmental Variables]] [[variable:tmssreportformat|TMSSREPORTFORMAT]] and [[variable:tmssunqualifiedvolume|TMSSUNQUALIFIEDVOLUME]]. |
| |
| <sxh plain;> | <code plain;> |
| set TMSSUNQUALIFIEDVOLUME=1 | set TMSSUNQUALIFIEDVOLUME=true |
| set TMSSREPORTFORMAT=CSV | set TMSSREPORTFORMAT=CSV |
| |
| TMSS10Inventory -S tapemaster:-@localhost -V "*.*.*@OFFS" -c "inventory.cfg" > inventoryout.txt 2> inventoryerr.txt | TMSS10Inventory -S tapemaster:-@localhost -V "*.*.*@OFFS" -c "inventory.cfg" > inventory_out.csv 2> inventory_err.txt |
| </sxh> | </code> |
| |
| |
