DeviceCoreInfo

DeviceCoreInfo

Provides information on the device

Column Name

Type 

Nullable

Description

Column Name

Type 

Nullable

Description

deviceguid 

unique-identifier

No

Uniquely identifies a device.

datecreated 

datetime

No

The date and time the device was identified.

datemodified 

string

No

The last date and time the device was modified.

manufacturer 

string

Yes

The device’s manufacturer.

model 

string

Yes

The model of the device.

shortdescription 

string

Yes

A short description of the device.

shortdescriptionoverride

string

Yes

An override description of the short description.

description

string

Yes

A more detailed description of the device.

operatingsystemname

string

Yes

Identifies the device’s operating system.

operatingsystemtype 

string

Yes

Identifies the type of operating system.

networkrole 

string

Yes

The device’s role in the network.

hardwaretype 

string

Yes

Identifies the device’s hardware.

serialnumber

string

Yes

A manufacturer-allocated number used to identify the device. 

devicerolecategory 

string

Yes

The category role of the device.

iscurrent 

character

Yes

Not used.