Pre-Installation Setup for Generic Backup > CSV Format Specification
   
Version 9.1
CSV Format Specification
Using the backup software, create a comma-separated file that contains the following data elements from the backup/restore job(s). Note that each field must have an entry, even if it is a null entry within the commas. Field values cannot contain embedded commas. All string fields must be enclosed within single straight quotes.
Name
Type
Value
VendorName
STRING
The name of the backup application used to perform the backup, enclosed in single straight quotes
ClientName
STRING
The host name of the machine being backed up, enclosed in single straight quotes
ClientIPAddress
NUMBER
The IP address of the machine being backed up (otherwise use 'null'), enclosed in single straight quotes
VendorJobType
STRING
Valid values include: BACKUP or RESTORE—enclosed in single straight quotes
StartDateString
DATE
The start date and time of the backup job in the format: YYYY-MM-DD HH:MI:SS (enclosed in single straight quotes)
Note: Adhere to the specific date format—number of digits and special characters—as shown above.
FinishDateString
DATE
The end date and time of the backup job in the format: YYYY-MM-DD HH:MI:SS (enclosed in single straight quotes)
Note: Adhere to the specific date format—number of digits and special characters—as shown above.
BackupKilobytes
NUMBER
The numeric size of the backup in kilobytes (otherwise use 0). Remember StorageConsole uses 1024 for a KB.
NbrOfFiles
NUMBER
The number of files that were backed up (otherwise use 0).
MediaType
STRING
The type of media that was used: T for Tape or D for Disk, enclosed within single straight quotes.
VendorStatus
NUMBER
A numeric job status: 0=Successful, 1=Partially Successful, or 2=Failed.
VendorJobId
NUMBER
Vendor job ID.
VendorPolicyName
STRING
Vendor policy name.
JobLevel
STRING
Ex: Incremental, full.
TargetName
STRING
Filesystem backed up by MBS.
EXAMPLE: genericBackupJobs.csv
'Mainframe Backup','mainframe_name','10.10.10.10','BACKUP','2008-03-24 10:25:00', '2008-03-24 11:50:00',3713,45221,'D',0,413824,'Retail_s01002030','Incremental','/I:/Shared/'
'UNIX tar backup','host_xyz.anyco.com',,'BACKUP','2008-03-24 10:22:00',
'2008-03-24 12:50:00',1713,45221,'T',0
'ArcServe','host_123.anyco.com',,'RESTORE','2008-03-24 8:22:00',
'2008-03-24 9:12:00',0,0,'T',0
'NBU PureDisk','pd_client1.anyco.com','172.168.1.1','BACKUP','2008-03-24 9:22:00',
'2008-03-24 12:44:00',1713,45221,'D',1