# 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

# Add translations to set Description based off Media Pool-ID