Reporting Data Layer

DeviceGuid

Uniquely identifies a device.

SiteID

The site that this device belongs to.

Name

The device's fully qualied domain name (FQDN).

Alias

An alias assigned to a device from the SC UI (optional). If no alias has been entered in the UI, is NULL.

SNMPName

The device name received via SNMP protocol. If the device is not managed by SNMP (SNMPEnabled = 0), is NULL.

CurrentStatus

Indicates status. 1 - Up or 0 - Down

WmiEnabled

Indicates whether WMI protocol is enabled (TRUE) or not (FALSE).

SnmpEnabled

Indicates whether SNMP protocol is enabled (TRUE) or not (FALSE).

TimeCreated

The date and time the device was created.

InventoryTag

The device inventory tag as entered in the SC UI. If no inventory tag has been entered in the UI, is NULL.

PhysicalLocation

The Device location as entered in the SC UI. if no physical location has been entered in the UI, is NULL.

Notes

Notes entered for a device in the SC UI.

ActiveState

Indicates the device's state. Possible values are: Deleted = 0, Active = 1, DeleteConfirmed = 2, MarkedForExclusion = 3, Excluded = 4

TimeDeleted

The date and time the device was deleted.

AMTEnabled

Indicates whether device is AMT enabled (TRUE) or not (FALSE).

ComputerName

The name of the computer. If the device is not managed by WMI (WMIEnabled = 0) or WSManagement (WSManEnabled = 0), is NULL.

IsDeviceManagerOnsite

Indicates whether DM device is onsite (TRUE), offsite (FALSE), or managed by an OM (NULL).

NetbiosName

The Netbios name. This name is retrieved via Netbios. If the device is not managed by WMI(WMIEnabled = 0) or WSManagement (WSManEnabled = 0), is NULL.

ProductionDate

The production date, entered from SC UI. If the production date has not been entered in the UI, is NULL.

SshEnabled

Indicates whether SSH protocol is enabled (TRUE) or not (FALSE).

IsRespondingToArp

Indicates whethe device responds to Arp (TRUE) or not (FALSE).

WSManEnabled

Indicates whether the device has WSMan enabled (TRUE) or not (FALSE).

TimeExcluded

The date and time of the device exclusion.

SshName

The name of the device. Obtained through SSH protocol. If the device is not managed by SSH (SshEnabled = 0), is NULL.

Manufacturer

The name of the organization responsible for producing the device.

Model

The product name that the manufacturer gives to the device.

ShortDescription

A phrase that typically describes the operating system, form factor and network role.

OperatingSystemID

The operating system family. Possible values are: 0=Unknown, 1=Windows, 2=MacOsx, 3=Unix, 4=iOS, 5=Android, 6=Blackberry, 7=Windows Phone

NetworkRoleID

The role of the device on a network. Possible values are 0=Unknown, 1=NetworkDevice, 2=Server, 3=Workstation.

HardwareTypeID

The hardware type of the device. Possible values are Unknown = 0, Desktop = 1, Laptop = 2, Tablet = 3, MobilePhone = 4, RackMount = 5, Printer = 6, PizzaBox = 7, PhoneOrTablet = 9, VoipPhone = 10

SerialNumber

The serial number for the device.

Shipped

Date and time (in UTC) when a device has been shipped from a manufacturer.

OutOfWarranty

Flag indicating whether device is out of warranty (TRUE) or not (FALSE).

DeviceWarrantyUrl

URL for the device warranty.

DeviceGuid

The device that the bandwidth data was collected for. The foreign key for the Device table.

AssetObjectGuid

The network card that the bandwidth data was collected for.

SampleTimestamp

The date and time (in UTC) the bandwidth data was sampled.

CurrentBand-

widthInBps

The rate (in bits/second) at which bytes are received over the network adapter.

DeviceGuid

The device that the Windows event was created for.

EventLog

The log that the event was generated in. Possible values are: Application, Security, Setup, or System.

EventSource

The application, service, or component that logged the event.

EventID

The unique value for the type of event and source, as given by the Vendor.

EventSeverity

The severity of the event. Possible values are: Information, Warning, Error, Success Audit or Failure Audit.

Description

A description of the event.

OccurenceNbr

The number of occurrences of this event. If duplicate events are detected within the same 1 minute interval, the first event is retained and this value is incremented by 1 for each duplicate.

TimeOfEvent

The date and time (in UTC) that the event was generated.

DeviceGuid

The device that the counter data was created for. The foreign key for the Device table.

SampleValue

The value of the counter at the time of the sample.

CounterID

The counter that the data was sampled for. The foreign key for the Counter table.

SampleTimestamp

The date and time (in UTC) the bandwidth data was sampled.

CounterID

A unique value used to identify a counter. The primary key for Counter records.

CounterName

The name of the counter. For example: "% Free Space".

InstanceName

The instance of the counter. For example: "C:".

CategoryName

The category of the counter. For example: "Logical Disk".

CounterHelp

A description of the counter. For example: "% Free Space is the percentage of total usable space on the selected logical disk drive that was free."

SessionGuid

A unique value used to identify a remote access session. The primary key for RemoteAccessSession records.

DeviceGuid

The device that the remote access session was created for. The foreign key for the Device table.

UserID

The user that initiated the remote access session. The foreign key for User table.

TimeStarted

The date and time (in UTC) the session started.

TimeEnded

The date and time (in UTC) the session ended.

ServicePort

The number of the port the session was hosted on.

ServiceName

The name of the remote access application.

ServiceParameters

The command line parameters used to execute the remote access viewer on the client device.

HostIPAddress

The IP address of the host device.

ClientDNSName

The DNS name of the client device.

ClientDNSName

The IP Address of the client device.

Status

The status of the session. Possible values are: 0 = Requested, 1 = Connected, 2 = Disconnected, Timed Out = 3, Error = 4

Notes

Notes entered by the user who initiated the session.

TerminationReason

A description of why the session was terminated.

TerminationReason

Code

The session was terminated. Possible values are: 0 = Unknown, 1 = UserClosedClientApplication, > 1 = Error

SessionGuid

The remote access session during which this tool was accessed.

EventData

The name of the tool.

TimeOfEvent

The date and time (in UTC) the tool was accessed.

UserID

Uniquely identifies a user.

Name

The unique login name of the user. For example: admin

FirstName

The first name of the user.

LastName

The last name of the user.

LastModified

The last date and time that this information was updated, in UTC.

LastLoginDate

The date and time that the user last logged into Service Center, in UTC.

IsLockedOut

Indicates whether the user account is locked out (TRUE) or not (FALSE).

Status

Indicates whether the user account is disabled (TRUE) or not (FALSE).

Email

The email address of the user.

SiteID

Uniquely identifies a site.

SiteName

A name provided by the user when creating the site.

Company

The company name.

Street

The street name.

POBox

Post office box.

City

The city.

Province

The province.

PostalCode

The postal code.

Country

The country.

ContactName

The contact name.

ContactPhone

The contact phone number.

ContactEmail

The contact email.

TicketStatus

Uniquely identifies a ticket.

ReportedSeverity

The status of the ticket. Possible values for built-in statuses are: New, Open, Closed and Healed

AssignedSeverity

The current severity assigned to the trouble ticket. Possible values are: 1=Info, 2=Warning, 3=Critical.

AssignedTo

The user assigned to the trouble ticket.

AssignedBy

The user that created the trouble ticket.

Title

A short description of the trouble ticket.

Problem

A description of the problem that needs to be resolved by the trouble ticket.

SiteID

The site that the trouble ticket belongs to.

Priority

The priority of the trouble ticket. Possible values are: 1=Low, 2=Medium, 3=High.

TicketCategoryID

The category of the trouble ticket. Possible values are: 1=Onsite Manager Alerts, 2=Service Requests, 3=Hardware Problems, 4=Software Problems

Created

The date and time (in UTC) that the trouble ticket was created.

LastModified

The date and time (in UTC) that the trouble ticket was last modified.

Note

Trouble ticket notes.

IPAddressID

Uniquely identifies an IP address.

DeviceGuid

The device that this IP address belongs to.

Status

The status of the IP address. Possible values are: 0 = Down, 1 = Up

MACAddress

The Media Access Control (MAC) address associated with this IP.

DateModified

The date and time that this information was last updated, in UTC.

Address

The IP address (e.g. 192.168.0.1)