<sxh>

# Connect to Veeam database SetODBC(“DSN=veeam2”); # Extract data SetSQL(“SELECT [barcode],[media_pool_id],[last_write_time] FROM [VeeamBackup].[dbo].[Tape.tape_mediums]”);

# Set Customer-ID SetLiteral(CUSTOMER, “CUST”); # Set media to LTO as only one media type in report SetLiteral(MEDIA, “LTO”);

# Set place marker for Description SetLiteral(DESCRIPTION, “????”); # Set place marker for Repository SetLiteral(REPOSITORY, “????”);

# Extract Volume-ID from column 1 Extract(VOLUME, 1, 10, 0); # Extract media pool-id for translation from column 2 Extract(USER1, 2, 50, 0); # Extract last writetime from column 3 Extract(WRITETIME, 3, 50, 0);

# Set writetime format SetWriteTimeFormat(“Y-m-d H:M:S”);

# Add translations to set Description based off Media Pool-ID AddTranslation2(DESCRIPTION, USER1, “4C6BFE92-5C7F-BFE9-A18E-B52A8049C167”, “Alpha media pool”); AddTranslation2(DESCRIPTION, USER1, “601ED8E9-647E-A19E-B18E-F6D66B0EE584”, “Bravo media pool”); AddTranslation2(DESCRIPTION, USER1, “ AddTranslation2(DESCRIPTION, USER1, ”

# Add translations to set Description based off Media Pool-ID AddTranslation2(DESCRIPTION, USER1, “4C6BFE92-5C7F-BFE9-A18E-B52A8049C167”, “OFFS”); AddTranslation2(DESCRIPTION, USER1, “601ED8E9-647E-A19E-B18E-F6D66B0EE584”, “Bravo media pool”); </sxh>