DeviceWithIdentificationNames

DeviceWithIdentificationNames

Column Name

Type

Nullable

Description

Column Name

Type

Nullable

Description

deviceid

integer

No

Uniquely identifies the device.

siteid

integer

No

Uniquely identifies a site

siteguid

unique-identifier

No

The GUID of the site

deviceguid

unique-identifier

No

The GUID of the device

description

string

Yes

A more detailed description of the device

status

string

Yes

The status of the device

omidentifier

integer

No

The identifier of the Onsite Manager that manages the device

wmienabled

boolean

No

Identifies if WMI is enabled on the device

wsmanenabled

boolean

No

Identifies if WSMan is enabled on the device

snmpenabled

boolean

No

Identifies if SNMP is enabled on the device

sshenabled

boolean

No

Identifies if SSH is enabled on the device

sshname

string

Yes

The SSH name

endoflife

datetime

Yes

The end of life for the device

monitor

boolean

No

Identifies if the device is a monitor

timecreated

datetime

No

The date and time the device was identified

notes

text

Yes

Notes entered by the user who added the device

inventorytag

string

Yes

An inventory identifier for the device

physicalallocation

string

Yes

Identifies the physical memory allocation of the device

activestate

string

No

Identifies the active state of the device

amtenabled

boolean

No

Identifies if AMT is enabled on the device

timestatuschanged

datetime

No

The date and time the device’s status last changed

omguid

unique-identifier

No

The GUID of the Onsite Manager that manages the device

alias

string

Yes

An alias for the device

computername

string

Yes

The computer name of the device

snmpname

string

Yes

The SNMP name of the device

netbiosname

string

Yes

The NetBIOS name for the device

name

string

Yes

The name of the device

isonsite

boolean

Yes

Identifies if the device is on site

warrantyexpirydate

datetime

Yes

The date and time the warranty of the device expires

comment

text

Yes

Any comment created by the individual who created the device

isrespondingtoarp

boolean

No

Identifies if the device responds to ARP

timeexcluded

datetime

Yes

If applicable, the date and time the device was excluded

ipaddresses

text

Yes

The IP addresses of the device

identificationnamewithalias

text

Yes

If applicable, an identifying name for the device, with an alias for the device

iscurrent

character

Yes

Not used