macOS_PhysicalDisk

DeviceGuid 

uniqueidentifier 

A globally unique identifier for the macOS device.

DateCreated 

datetime 

The date and time the OM identified the physical disk.

DateModified 

datetime 

The date and time the OM last modified the physical disk.

BSDName 

nvarchar(100) 

The BSD Name of the physical disk.

Capacity 

bigint 

The capacity of the physical disk, in bytes.

DetachableDrive 

bit (1 or 0)

Indicates if the drive is detachable (1) or not (0).

MediumType 

nvarchar(100) 

The medium type of the physical disk.

Model 

nvarchar(100) 

The name of the physical disk.

NativeCommandQueuing 

bit (1 or 0) 

Indicates if native command queuing is available (1) or not (0).

PartitionMapType 

nvarchar(100) 

The type of the partition map.

QueueDepth 

int 

The depth of the queue.

RemovableMedia  

bit (1 or 0)

Indicates if the physical disk is removable (1) or not (0).

Revision 

nvarchar(100) 

Indicates the revision of the physical disk.

SerialNumber 

nvarchar(100) 

The serial number of the physical disk.

SMARTStatus 

nvarchar(100) 

Indicates the S.M.A.R.T. status of the physical disk. For example, ‘Verified’ or ‘Failing’.