The output of these queries is an XML file containing results. The structure of the results depends on the query being run, but in general, the element that contains the results is <dataResultSet>. It has these subfields:
|
Field |
Description |
|---|---|
|
version |
The backed-up version number of the file. (Not included for queries that use <queries type="TOPBOTTOM"/>.) |
|
size |
The size of the file, in bytes. |
|
path |
The full path the file, including the file's name. |
|
name |
The Windows internal name of the file, which includes some characters prepended to the name that you probably don't want. We recommend using displayName instead. |
|
modificationTime |
The file's modification timestamp, in seconds offset from January 1, 1970 (Unix standard timestamp format). |
|
displayName |
The file's name as displayed in Windows Explorer. |
|
aggrResultSet result |
The result returned by queries using <queries type=AGGREGATE/>. |
Important: When SQL errors occur, the SQL server also returns its error messages to the output XML file.