partitions

Description

This table lists all the partitions of the server and specifies their free disk space, total disk space...

Fields

Field name

Data type

Description

id_snapshot

number

snapshot auto-number.

server_name

string

Netbios name of the server without the 2 backslashes.

partition

string

Name of the partition

disksize

number

Total disk space on the partition (in Kb)

id_disk

number

Physical disk number (link to PhysicalDisks table)

FileSystem

string

NTFS or FAT

FileSystemFlags

number

See appendix 1 for the meaning

VolumeName

string

Label of the partition

VolumeSerial

string

Serial number of the partition

spacefree

number

Total free disk space on the partition (in Kb)

Appendix 1 File system flags

Symbolic constant

Value

Meaning

FS_CASE_IS_PRESERVED

0x00000002

The file system preserves the case of file names when it places a name on disk.

FS_CASE_SENSITIVE

0x00000001

The file system supports case-sensitive file names.

FS_UNICODE_STORED_ON_DISK

0x00000004

The file system supports Unicode in file names as they appear on disk.

FS_PERSISTENT_ACLS

0x00000008

The file system preserves and enforces ACLs. For example, NTFS preserves and enforces ACLs, and FAT does not.

FS_FILE_COMPRESSION

0x00000010

The file system supports file-based compression.

FS_VOL_IS_COMPRESSED

0x00008000

The specified volume is a compressed volume; for example, a DoubleSpace volume.

FILE_NAMED_STREAMS

0x00040000

The file system supports named streams.

FILE_READ_ONLY_VOLUME

 

Windows XP: The specified volume is read-only.

FILE_SUPPORTS_ENCRYPTION

0x00020000

The file system supports the Encrypted File System (EFS).

FILE_SUPPORTS_OBJECT_IDS

0x00010000

The file system supports object identifiers.

FILE_SUPPORTS_REPARSE_POINTS

0x00000080

The file system supports reparse points.

FILE_SUPPORTS_SPARSE_FILES

0x00000040

The file system supports sparse files.

FILE_VOLUME_QUOTAS

0x00000020

The file system supports disk quotas.