CSV format specification
Using the backup software, create a comma-separated file that contains the following 15 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.
Note:
The CSV file must be UTF-8 encoded, however be sure to remove any UTF-8 BOMs (Byte Order Marks). The CSV cannot be properly parsed with these additional characters.
Table: CSV format specification
| 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. If an IP address is not available, simply use two single straight quotes ('') or 'null' to indicate a blank/missing value. |
|
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 IT Analytics uses 1024 for a KiB. |
|
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 |
STRING |
Vendor job ID, enclosed in single straight quotes. |
|
VendorPolicyName |
STRING |
Vendor policy name, enclosed in single straight quotes. |
|
JobLevel |
STRING |
Job level, enclosed in single straight quotes. Example: Incremental, Full. |
|
TargetName |
STRING |
File system backed up by the managed backup system (MBS), enclosed in single straight quotes. |
|
ScheduleName |
STRING |
Name of the backup schedule, enclosed in single straight quotes. |