realfolders

This table describes all folders available on your Windows computers (or a subset). See the software scan configuration for more information about scanning folders and files. Shared folders are scanned if shares are selected in the Windows scan configuration.

Field name

Data type

Description

id_snapshot

number

snapshot auto-number

server_name

string

Netbios name of the server without the 2 backslashes.

id_realfolder

number

Identifier of this folder. The field is used to link tables such as aces\object_id

id_share

number

Link to the share if the folder is shared (shares table).

pathname

string

Full path of the folder.

foldername

string

Name of the folder

attribs

number

Bit mask specifying the folder's attributes (see Appendix in table realfiles).

time_created

time

Time when the folder was created.

account_name

string

Owner of the file. The field can be linked with an entry of the groups table or the user table.

realsize

number

Size of the folder including al subdirectories and files (Bytes)

compressedsize

number

Currently not scanned

NbFiles

number

Number of files in the folder (scan files needed)

NbFolders

number

Number of subfolders in the folder (scan files needed)

time_accessed

time

 

rootsize

number

Size of all files at the root of the folder