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 file with data elements.
Data Elements | Data 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. |