This table describes all files available on your Windows computers (or a subset if you define file masks or folder restrictions). See the software scan configuration for more information about scanning files.
Field name |
Data type |
Description |
id_snapshot |
number |
snapshot auto-number |
server_name |
string |
Netbios name of the server without the 2 backslashes. |
id_realfile |
number |
Identifier of this file. The field is used to link tables such as versions. |
pathname |
string |
Full path of the file. |
attribs |
number |
Bit mask specifying the file's attributes (see Appendix). |
realsize |
number |
Real size of the file. |
compressedsize |
number |
Compressed size of the file. |
time_created |
time |
Time when the file was created. |
time_modified |
time |
Last modified time. |
time_accessed |
time |
Last accessing time. |
account_name |
string |
Owner of the file. The field can be linked with an entry of the groups table. |
Symbolic constant |
Value |
Meaning |
FILE_ATTRIBUTE_ARCHIVE |
0x00000020 |
The file or directory is an archived file or directory. Applications use this attribute to mark files for backup or removal. |
FILE_ATTRIBUTE_COMPRESSED |
0x00000800 |
The file or directory is compressed. For a file, this means that the file is compressed. For a directory, this means that compression is the default for newly created files and subdirectories. |
FILE_ATTRIBUTE_DIRECTORY |
0x00000010 |
The handle identifies a directory. |
FILE_ATTRIBUTE_ENCRYPTED |
0x00000040 |
The file or directory is encrypted. For a file, this means that data in the file is encrypted. For a directory, this means that encryption is the default for newly created files and subdirectories. |
FILE_ATTRIBUTE_HIDDEN |
0x00000002 |
The file or directory is hidden. It is not included in an ordinary directory listing. |
FILE_ATTRIBUTE_NORMAL |
0x00000080 |
The file or directory has no other attributes set. This attribute is valid only if used alone. |
FILE_ATTRIBUTE_OFFLINE |
0x00001000 |
The file data is not immediately available. Indicates that the file data has been physically moved to offline storage. |
FILE_ATTRIBUTE_READONLY |
0x00000001 |
The file or directory is read-only. Applications can read the file but cannot write to it or delete it. If this is a directory, applications cannot delete it. |
FILE_ATTRIBUTE_REPARSE_POINT |
0x00000400 |
The file has an associated reparse point. |
FILE_ATTRIBUTE_SPARSE_FILE |
0x00000200 |
The file is a sparse file. |
FILE_ATTRIBUTE_SYSTEM |
0x00000004 |
The file or directory is part of the operating system or is used exclusively by the operating system. |
FILE_ATTRIBUTE_TEMPORARY |
0x00000100 |
The file is being used for temporary storage. File systems attempt to keep all of the data in memory for a quicker access, rather than flushing it back to mass storage. A temporary file should be deleted by the application as soon as it is no longer needed. |
To retrieve all the compressed files shared on server MYSERVER, use the following SQL query:
SELECT pathname
FROM realfiles
WHERE attribs & 0x800 <> 0