realfiles

Description

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.

Fields

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.

Appendix

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.

Example

To retrieve all the compressed files shared on server MYSERVER, use the following SQL query:

SELECT pathname
FROM realfiles
WHERE attribs & 0x800 <> 0