Both sides previous revisionPrevious revisionNext revision | Previous revision |
cli:list_added_at_repository [2019/04/12 14:16] – 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"); |
| |
# 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 unqualified 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> |
| |
| |