View Password

System > Database Views

View Definitions defined here.

The system exposes set of database views allowing clients to directly access data within the Kaseya repository. These views can be used by to bring data into a spreadsheet for analysis or to prepare reports. This document describes the views and gives two example applications, Crystal Reporting and Microsoft Excel. Kaseya does not present itself as an expert in how to use Excel or Crystal. These examples are to assist in the basics of getting started. For third party product training or other questions please contact the third party tool vendor. Finally, an appendix is provided with a field-by-field description of the contents of the views.

The views provided can be broken into three groups. The first group provides information on all the machines being monitored. The second group provides information about the activity and current status of key parts of the system. The third group provides information on the ticketing system. The views provided are:

Machines Group
vBaseApplicationInfo	The baseline list of applications on a client desktop machine.
vBaseCpuInfo	The baseline list of the CPUs in a client desktop machine.
vBaseDiskInfo	The baseline list of the disks in a client desktop machine.
vBaseDriveManufacturer	The baseline list of the manufacturers of the disks in a client desktop machine.
vBasePciInfo	The baseline list of the PCI cards in a client desktop machine.
vBasePrinterInfo	The baseline list of printers in a client desktop machine.
vCollectionMember	List the collections each machine ID belongs to (if any)
vCurrApplicationInfo	The current list of applications on a client desktop machine.
vCurrCpuInfo	The current list of the CPUs in a client desktop machine.
vCurrDiskInfo	The current list of the disks in a client desktop machine.
vCurrDriveManufacturer	The current list of the manufacturers of the disks in a client desktop machine.
vCurrPciInfo	The current list of the PCI cards in a client desktop machine.
vCurrPrinterInfo	The current list of printers in a client desktop machine.
vSystemInfo	All items collected by the System Info function under the Audit tab.
VLicenseInfo	The licenses of applications on this machine.
vMachine	The information known about each client desktop machine.
vOnBoardDeviceInfo	The current list of on board devices in a client desktop machine.
vPortInfo	The current list of ports in a client desktop machine.

Activity / Status Group
vAgentConfiguration	Lists agent specific configuration data
vAdminNotesLog	Notes each admin enters manually for a machine or group of machines. Entries in this log never expire.
vAlertLog	Logs each alert sent out via email. Multiple rows per machine.
vBackupLog	Logs all backup related events
vConfigLog	Log of all configuration changes. One entry per change.
vNetStatsLog	Network statistics log from the Agent.
vNtEventLog	NT Event log data collected from each managed machine.
vPatchStatus	Information on the state of all patches on a per machine basis. There is one row per patch for each machine.
vScriptLog	Log of script executions as viewed by the KServer.
vScriptStatus	Script status for each client.

Ticketing Group
vTicketSummary	Trouble ticket summary. One row per ticket. Column names are used as the names displayed in the view summary table.
VTicketNote	The notes associated with a ticket. Potentially multiple rows per ticket.
VticketField	The fields associated with a ticket. The standard fields, category, status and priority are always attached to a ticket. User fields added will also be included in this view.

Monitor Alarm Group
vMonitorAlarmCounter	The current list of alarms for all monitor counters.
vMonitorAlarmService	The current list of alarms for all monitor services.
vMonitorAlarmProcess	The current list of alarms for all monitor processes.
vMonitorAlarmSNMP	The current list of alarms for all monitor SNMP Get objects.
vMonitorAlarmAlert	The current list of alarms for all alerts.
vMonitorAlarmSystemCheck	The current list of alarms for all system checks.

Access to Views

The views are installed whenever the Reapply Schema action is taken. Once this is accomplished the views are ready to be used. A single data user id, KaseyaViews will be provided. To give access to these views an administrator needs to go to the system menu. Under the title View Access there is a function to change the password of KaseyaViews. By selecting this option the administrator will be presented with a screen to enter a password. Once this is accomplished, the new views can be accessed using the KaseyaViews user id and the password entered.

Crystal Reporting Usage

Crystal Reporting can be used to create client specified reports. Crystal 9 and 10 can be used to produce various output formats include PDF, Word and Excel. To set up a report the Crystal Report Wizard can be used. This process begins with the following dialog.

The client picks a report format. For this example standard will be used.

Next the data source is selected. This begins by picking an access method. ADO should be selected.

Once ADO is selected the SQL Server driver can be selected. This is the correct selection to access the Kaseya database.

The next step is providing the credential to make connection to the database. As shown in this dialog, the Server, User Id, Password, and Database must be provided.

Once the credentials are provide all the available views are displayed. Pick one or more for the report desired.

After a view is selected the columns to be included can then be selected. Crystal provides a variety of ways to format this data. This document does not attempt to describe these options. The Crystal documentation should be reviewed for this information.

The resulting report can be printed or emailed to the appropriate consumers of the report. The format of the report can be designated. This facility can be used to produce a PDF or a variety of other formats.

Excel Usage

Microsoft Excel can access the views by setting up a data source. Selecting the Settings option from the Start button allows the creation a data source. From the Settings option select the Control Panel. From the Control Panel next select Administrative Tools. From this menu a data source can be created.

The data source should be set up as a System DSN. From this dialog, create a source using the SQL Server driver. The set-up will require the name of the database server (usually the ComputerName), the user id (KaseyaViews) and password, and the database schema name (ksubscribers).

Once a data source is created it can be referenced by Excel. Selecting Get External Data from the Data menu does this. A new database query can be started from this selection. The user is prompted for the credentials to the database. Once this completes a view can be selected. A SQL query can be constructed to bring information directly into Excel at this point.

A data source is a core definition within Microsoft. Most Microsoft products have facilities to access data through a data source definition.

MSDE/SQL Server Variations

If you are using MSDE/SQL Server rather than the full SQL Server, there are a few minor variations to the steps listed above.

The SQL server name will always be [ComputerName]\KVSAMSDE.
Always set the authentication using a login ID and password. This will be KaseyaViews with the password you have defined.

View Definitions

vAdminNotesLog	Notes each admin enters manually for a machine or group of machines. Entries in this log never expire.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
AdminAdmin	varchar	Admin logon name. (note: no not name this col adminName)
EventTime	datetime	Time stamp string representing the time the action took place. Default is CURRENT_TIMESTAMP so nothing needs to be entered here.
NoteDesc	varchar	description of the action

vAgentConfiguration	Logs each alert sent out via email. Multiple rows per machine
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
firstCheckin	datetime	timestamp recording the first time this agent checked into the system
lastCheckin	datetime	timestamp recording the most recent time this agent checked into the system
currentUser	varchar	login name of the currently logged in user. Blank if no one logged in at this time
lastLoginName	varchar	login name of the last user to log into this system
lastReboot	datetime	timestamp when this system was last rebooted
agentVersion	int	version number of agent installed on this system
contactName	varchar	User contact name assigned to this agent
contactEmail	varchar	User email address assigned to this agent
contactPhone	varchar	Contact phone number assigned to this agent
contactNotes	varchar	Notes associated with the contact information for this agent
enableTickets	int	0 if this user does not have access to ticketing through the user interface
enableRemoteControl	int	0 if this user does not have access to remote control through the user interface
enableChat	int	0 if this user does not have access to chat through the user interface
loginName	varchar	Login Name assigned to this user (if any) to access the system user portal interface.
credentialName	varchar	The username of the credential set for this agent (if any)
primaryKServer	varchar	address:port agent connects to for its primary kserver connection
secondaryKServer	varchar	address:port agent connects to for its secondary kserver connection
agentTempDir	varchar	The temp directory used by the agent on this system

vAlertLog	Logs each alert sent out via email. Multiple rows per machine
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
EventTime	datetime	time stamp when the event was recorded
AlertEmail	varchar	email address to send the alert to
AlertType	int	1 -> Admin account disabled 2 -> Get File change alert 3 -> New Agent checked in for the first time 4 -> Application has been installed or deleted 5 -> Script failure detected 6 -> NT Event Log error detected 7 -> KServer stopped 8 -> Protection violation detected. 9 -> PCI configuration has been changed 10 -> Disk drive configuration change 11 -> RAM size changed. 12 -> Test email sent by serverInfo.asp 13 -> Scheduled report completed 14 -> LAN Watch alert type 15 -> agent offline 16 -> low on disk space 17 -> disabled remote control 18 -> agent online 19 -> new patch found 20 -> patch path missing 21 -> patch install failed 23 -> Backup Alert
EmailSubject	varchar	Email subject line
EmailBody	varchar	Email body

vBackupLog	Logs each alert sent out via email. Multiple rows per machine
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
EventTime	datetime	time stamp when the event was recorded
description	varchar	description of the reported task
durationSec	int	number of seconds the reported task took to complete
statusType	int	0: full backup 1: not used 2: incremental backup 3: not used 4: not used 5: folder backup 6: not used 7: differential backup 8: incremental folder backup 9: differential folder backup 10: verify volume 11: verify folder 12 volume backup skipped 13: folder backup skipped 14: explore volumes and/or folders
result	int	0: failure 1: success 2: archive incomplete

vBaseApplicationInfo vCurrApplicationInfo	audit results for installed applications. One entry per installed application found in the registry key HKEY_LOCAL_MACHINE\Software\Microsoft\ Windows\CurrentVersion\App Paths.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
ProductName	varchar	Product name (e.g. Microsoft Office 2000)
ProductVersion	varchar	Version (e.g. 9.0.3822)
ApplicationName	varchar	Application name (e.g. Winword.exe)
Manufacturer	varchar	Manufacturers name (e.g. Microsoft Corporation)
ApplicationDesc	varchar	Description (e.g. Microsoft Word for Windows)
LastModifiedDate	varchar	File date (e.g. 02/24/2000 17:23:44)
ApplicationSize	varchar	File size in bytes (e.g. 8810548)
DirectoryPath	varchar	Directory path on client desktop (e.g. C:\PROGRA~1\MICROS~4\OFFICE)

vBaseCPUInfo vCurrCPUInfo	audit results for the CPU in a client desktop machine. One entry per audit of a client desktop.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
CpuDesc	varchar	CPU description (e.g. Pentium III Model 8)
CpuSpeed	varchar	CPU speed in MHz (e.g. 601)
CpuCount	varchar	Number of processors (e.g. 1)
TotalRam	varchar	Amount of RAM in MBytes (e.g. 250)

vBaseDiskInfo vCurrDiskInfo	audit results for the logical disks found in a client desktop machine. One entry per logical disk from an audit of a client desktop.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
DriveLetter	varchar	Logical disk drive letter (e.g. C)
TotalSpace	varchar	Total MBytes on the disk (e.g. 28609 for 28.609 GB) May be null if unavailable.
UsedSpace	varchar	Number of MBytes used (e.g. 21406 for 21.406 GB). May be null if unavailable.
FreeSpace	varchar	Number of MBytes free (e.g. 21406 for 21.406 GB). May be null if unavailable.
DriveType	varchar	Fixed = hard diskRemovable = floppy or other removable mediaCDROMNetwork = mapped network drive
VolumeName	varchar	Name assigned to the volume
FormatType	varchar	NTFS, FAT32, CDFS, etc.

vBaseDriveManufacturer vCurrDriveManufacturer	Hardware audit results for the IDE & SCSI drives manufacturer and product info found in a client desktop machine. One entry per drive from an audit of a client desktop.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
DriveManufacturer	varchar	Manufacturer name (data currently has 8 characters max)
DriveProductName	varchar	Product identification (data currently has 16 characters max)
DriveProductRevision	varchar	Product revision (data currently has 4 characters max)
DriveType	varchar	Type of disk drive found

vBasePciInfo vCurrPciInfo	Hardware audit results for the PCI cards manufacturer and product info found in a client desktop machine. One entry per PCI card from an audit of a client desktop.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
VendorName	int	PCI Vendor Name
ProductName	int	PCI Product Name
ProductRevision	int	Product revision
PciBaseClass	int	PCI base class number
PciSubclass	int	PCI subclass number
PciBusNumber	int	PCI bus number
PciSlotNumber	int	PCI slot number

vBasePrinterInfo vCurrPrinterInfo	Printer audit results for the printers found for the current user logged on to a client desktop machine. One entry per printer from an audit of a client desktop. If no user is logged in, then Agent audits the printers for the system account, typically administrator.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
PrinterName	varchar	Name given to the printer. Same as shown in the Control Panels printer configuration window.
PortName	varchar	Name of the port to which the printer is attached. Same as shown in the Control Panels printer configuration window.
PrinterModel	varchar	Model name is the driver name retrieved from the printer information.

vCollectionMember	Lists all collections each machine ID is a member of (if any).
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
collectionName	varchar	Collection Name

vConfigLog	Log of all configuration changes. One entry per change.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
EventTime	datetime	Time stamp string representing the time the change was entered. (note: timestamp type was picked to force times into the database as year-month-day-hr-min-sec all in numeric format independent of the format sent in the SQL command. This allows records to be easily sorted by time during retrieval.)
ConfigDesc	varchar	Description of the change

vSystemInfo	Data collected by System Info function
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
Manufacturer	varchar	System manufacturer string
Product Name	varchar	Name or model number of the machine supplied by the manufacturer
System Version	varchar	Machine version string
System Serial Number	varchar	Machine serial number string entered by the manufacturer
Chassis Serial Number	varchar	Serial number string supplied by the manufacturer
Chassis Asset Tag	varchar	Asset tag string supplied by the manufacturer
External Bus Speed	varchar	Motherboard bus speed
Max Memory Size	varchar	Max memory this system may be configured with
Max Memory Slots	varchar	Max number of memory slots this system has
Chassis Manufacturer	varchar	Name of manufacturer of the chassis
Chassis Type	varchar	system chassis type
Chassis Version	varchar	version string of the chassis
Motherboard Manufacturer	varchar	Name of motherboard manufacturer
Motherboard Product	varchar	Motherboard model name
Processor Family	varchar	processor family name
Processor Manufacturer	varchar	processor manufacturer name
Processor Version	varchar	processor version string
CPU Max Speed	varchar	max speed of this processor
CPU Current Speed	varchar	configured speed of this processor
Custom Fields	varchar	Additional columns for each customer field created.

vLicenseInfo	License information collected during audit.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
Publisher	varchar	software publisher (usually in the Publisher reg value)
ProductName	varchar	Software title (usually in DisplayName value but may be the reg key title)
LicenseCode	varchar	License code (usually in the ProductID value)
LicenseVersion	varchar	version string returned by the scanner (if any)
InstallDate	varchar	install date string returned by the scanner (if any)

vMachine	The information known about each client desktop machine.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	full machine name. Everything to the left of the left most decimal point is the machine name.
groupName	varchar	full group name for this account. Everything to the right of the left most decimal point is the group name.
Manufacturer	varchar	Manufacturer string (type 1)
ProductName	varchar	Product Name string (type 1)
MachineVersion	varchar	Version string (type 1)
SysSerialNumber	varchar	Serial Number string (type 1)
ChassisSerialNum	varchar	Chassis Serial Number (type 3)
ChassisAssetTag	varchar	Chassis Asset Tag number (type 3)
BusSpeed	varchar	External Bus Speed (in MHz) (type 4)
MaxMemorySize	varchar	Maximum Memory Module Size (in MB) (type 16 - Maximum Capacity or if type 16 not available, Maximum Memory Module Size type 5)
MaxMemorySlots	varchar	Number of Associated Memory Slots (Number of Memory Devices in type 16 or if type 16 not available Number of Associated Memory Slots in type 5)
ChassisManufacturer	varchar	Chassis Manufacturer (type 3)
ChassisType	varchar	Chassis Type (type 3)
ChassisVersion	varchar	Chassis Ver (type 3)
MotherboardManfacturer	varchar	Motherboard Manufacturer (type 2)
MotherboardProductCode	varchar	Motherboard Product Code (type 2)
MotherboardVersion	varchar	Motherboard Version (type 2)
MotherboardSerialNumber	varchar	Motherboard Serial Number (type 2)
ComputerName	varchar	Name of the Computer
IpAddress	varchar	IP Address of the computer in a.b.c.d notation
SubnetMask	varchar	Subnet mask in a.b.c.d notation. String is empty if data is unavailable
DefaultGateway	varchar	Default gateway IP address in a.b.c.d notation. String is empty if data is unavailable.
DnsServer1	varchar	DNS server #1s IP address in a.b.c.d notation. String is empty if data is unavailable.
DnsServer2	varchar	DNS server #2s IP address in a.b.c.d notation. String is empty if data is unavailable.
DnsServer3	varchar	DNS server #3s IP address in a.b.c.d notation. String is empty if data is unavailable.
DnsServer4	varchar	DNS server #4s IP address in a.b.c.d notation. String is empty if data is unavailable.
DhcpEnable	int	0 -> Data is unavailable 1 -> DHCP on client computer is enabled 2 -> Disabled
DhcpServer	varchar	DHCP servers IP address in a.b.c.d notation. String is empty if data is unavailable.
WinsServer	int	0 -> Data is unavailable 1 -> WINS resolution on client computer is enabled 2 -> Disabled
PrimaryWinsServer	varchar	Primary WINS servers IP address in a.b.c.d notation. String is empty if unavailable.
SecondaryWinsServer	varchar	Secondary WINS servers IP address in a.b.c.d notation. String is empty if unavailable.
ConnectionGatewayIp	varchar	IP Address in a.b.c.d notation obtained by the Kserver as the source address of the Agent. This IP is the Agents network gateway and will be different from the IpAddress if the computer is behind NAT for example. String is empty if unavailable.
OsType	varchar	String contains OS type, such as 95, 98, NT4, 2000, NT3.51, or WIN32s. Derived from portions of MajorVersion, MinorVersion, and PlatformId.
OsInfo	varchar	String contains additional OS info, such as Build 1381 Service Pack 3. Derived from portions of BuildNumber and CsdVersion.
MajorVersion	varchar	Major version number from GetVersionEx() Windows function call.
MinorVersion	varchar	Minor version number from GetVersionEx() Windows function call.If PlatformId is Win32 for Windows, then a 0 MinorVersion indicates Windows 95. If PlatformId is Win32 for Windows, then then a MinorVersion > 0 indicates Windows 98.
BuildNumber	int	Build number from GetVersionEx() Windows function call.For NT or 2000, this value is the build numberFor 95 or 98, the high order word contains the major / minor version and the low order word contains the build number.
PlatformId	int	Platform ID from GetVersionEx() Windows function call. 0 -> Win32s 1 -> Win32 on Windows 2 -> Win32 on NT
CsdVersion	varchar	String from GetVersionEx() Windows function call containing additional OS info, such as Service Pack number and other arbitrary data.
MacAddr	varchar	String containing the physical address, i.e. the Media Access Control address, of the connection. A MAC address has the form of: 00-03-47-12-65-77
LoginName	varchar	User name of the currently logged on user. This value is updated with every quick check in. The agent error log file is updated with each change.

vNetstatsLog	network statistics log from the Agent
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
EventTime	datetime	Time stamp string representing the time the change was entered. (note: timestamp type was picked to force times into the database as year-month-day-hr-min-sec all in numeric format independent of the format sent in the SQL command. This allows records to be easily sorted by time during retrieval.)
BytesRcvd	int	Number of bytes received during this statistics period
BytesSent	int	Number of bytes sent during this statistics period
ApplicationName	varchar	Application name using the network

vNtEventLog	Event log data collected from each managed machine
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
LogType	int	1 -> Application Log 2 -> Security Log 3 -> System Log
EventType	int	1 -> Error 2 -> Warning 4 -> Informational 8 -> Success Audit 16 -> Failure Audit
EventTime	datetime	Time the event occurred
ApplicationName	varchar	event log source
EventCategory	varchar	event log category
EventId	int	event log event ID
UserName	varchar	event log user
ComputerName	varchar	event log computer name
EventMessage	varchar	event log message

vOnBoardDeviceInfo	Data collected by KaSmBios.exe during an audit for on-board device information. There is one row per active slot. All information is retrieved from Type 10.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
DeviceType	varchar	Device Type
DeviceDesc	varchar	Device Description

vPatchStatus	Shows the state of all patches on a per machine basis. There is one row per patch for each machine.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
BulletinID	varchar	bulletin ID string reported from the patch scanner
QNumber	int	Q Number for this patch. Refers to the Knowledge Base article on Microsofts site
FixedInServPackFlag	int	0 -> not part of a service pacelse the service pac ID that this patch has been incorporated into.
PatchAppliedFlag	int	0 -> patch has not been applied 1 -> patch has been applied
PatchIgnoreFlag	int	0 -> process this patch 1 -> ignore this patch
InstallDate	dateTime	timestamp when this patch was applied by the VSA
InstalledBy	varchar	Name of admin (if we installed the patch) or value from registry (if scanner retuned the value)

vPortInfo	Data collected by KaSmBios.exe during an audit on port connector information. There is one row per active slot. All information is retrieved from Type 8.
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
InternalDesc	varchar	Internal Description
ExternalDesc	varchar	External Description
ConnectionType	varchar	Connection Type
PortType	varchar	Port Type

vScriptLog	Log of script executions as viewed by the KServer
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
EventTime	datetime	Time stamp string representing the time the change was entered. (note: timestamp type was picked to force times into the database as year-month-day-hr-min-sec all in numeric format independent of the format sent in the SQL command. This allows records to be easily sorted by time during retrieval.)
ScriptName	varchar	Name of script
ScriptDesc	varchar	Event description
AdminName	varchar	Admin name that scheduled this script.

vScriptStatus	script status for each client
Column Name	Type	Purpose
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
ScriptName	varchar	Name of script
lastExecTime	datetime	Time stamp string representing the last time that the script was executed
lastExecStatus	varchar	Status of the last execution. The string will be one of the following:Script Summary: Success <ELSE or THEN>Script Summary: Failed <ELSE or THEN> in # step<ELSE or THEN> is replaced with the respective word ELSE or THEN.# is replaced by the number of steps that failed in the script (not useful unless allowing the processing to continue after a failure)step is replaced by the work steps if the script failed more than 1 step.
AdminLogin	varchar	Admin name that last scheduled this script. (Dont name this column adminName because that is a primary key used by database migration. adminName and emailAddr should not appear in the same table.

vTicketSummary	Trouble ticket summary. One row per ticket. Column names are used as the names displayed in the view summary table.
Column Name	Type	Purpose
TicketID	int	unique trouble ticket ID number
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
machName	varchar	Machine Name used for each agent
groupName	varchar	Group Name used for each agent
TicketSummary	varchar	summary string briefly describing the ticket
Assignee	varchar	Admin name this ticket is assigned to
CreatedBy	varchar	admin name (or machine ID if entered by user) of the person that created this ticket
CreationDate	datetime	timestamp when the ticket was created
DueDate	datetime	ticket due date
ResolutionDate	datetime	timestamp when the ticket was closed
UserName	varchar	The name of the submitter
UserEmail	varchar	The email address of the submitter
UserPhone		The phone number of the submitter
LastModifiedDate	varchar	Date of the most recent note entered for this ticket

vTicketNote	Trouble ticket notes are stored in the database. Each ticket summary can have multiple notes. There is a timestamp that identifies the order they were attached.
Column Name	Type	Purpose
TicketID	int	unique trouble ticket ID number
TicketNoteTime	dateTime	Timestamp identifying when the note was added
Author	varchar	person who wrote this note in the ticket
TicketNote	varchar	Contents of the ticket note
HiddenNote	int	0 if the note is visible. 1 if the note is hidden.

vTicketField	Each ticket will have a set of fields associated with it. Three of these fields are standard fields, status, priority, and category. Also, a series of user fields can be added that will also be seen in this view. Each field has a datatype. All lists are stored as integer values. The view vTicketFieldValue has the associated text for each list value.
Column Name	Type	Purpose
TicketID	int	unique trouble ticket ID number
FieldLabel	varchar	The label of the field
IntegerValue	int	The value of a integer field
NumberValue	NUMBER(22,4)	The value of a number field
StringValue	varchar	The value of a string field
ListValue	varchar	The value of a list field

vMonitorAlarmCounter	Listing of all alarms created by monitor counters.
Column Name	Type	Purpose
MonitorAlarmID	int	unique monitor alarm number
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with
MachineName	varchar	Machine Name used for each agent
MonitorType	int	0 -> Monitor Counter
MonitorName	varchar	Name of monitor counter object
AlarmType	int	0 -> Alarm 1 -> Trending
AlarmState	smallint	1 -> Open 2 -> Closed
Note	varchar	Notes administrator has entered on the alarm
Message	varchar	Message created from alarm, email message body
AlarmSubject	varchar	Subject of alarm and email subject
AlarmEmail	varchar	Email Address(es) alarm is sent to
EventTime	datetime	Date and Time of alarm
TicketID	int	Ticket ID created from alarm
LogValue	float	Value causing alarm
AdminName	varchar	Administrator who assigned monitor counter to machine

vMonitorAlarmService	Listing of all of the alarms created by monitor services.
Column Name	Type	Purpose
MonitorAlarmID	int	unique monitor alarm number
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with.
MachineName	varchar	Machine Name used for each agent
MonitorType	int	0 -> Monitor Service
MonitorName	varchar	Name of monitor service object
AlarmType	int	0 -> Alarm 1 -> Trending
AlarmState	smallint	1 -> Open 2 -> Closed
Note	varchar	Notes administrator has entered on the alarm
Message	varchar	Message created from alarm, email message body
AlarmSubject	varchar	Subject of alarm and email subject
AlarmEmail	varchar	Email Address(es) alarm is sent to
EventTime	datetime	Date and Time of alarm
TicketID	int	Ticket ID created from alarm
LogValue	float	Value causing alarm, below are service values: -1 -> Does not exist 0 -> Reserved 1 -> Stopped 2 -> Start Pending 3 -> Stop Pending 4 -> Running 5 -> Continue Pending 6 -> Pause Pending 7 -> Paused
AdminName	varchar	Administrator who assigned monitor service to machine

vMonitorAlarmProcess	Listing of all alarms created by monitor processes.
Column Name	Type	Purpose
MonitorAlarmID	int	unique monitor alarm number
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with
MachineName	varchar	Machine Name used for each agent
MonitorType	int	2 -> Monitor Process
MonitorName	varchar	Name of monitor process object
AlarmType	int	0 -> Alarm 1 -> Trending
AlarmState	smallint	1 -> Open 2 -> Closed
Note	varchar	Notes administrator has entered on the alarm
Message	varchar	Message created from alarm, email message body
AlarmSubject	varchar	Subject of alarm and email subject
AlarmEmail	varchar	Email Address(es) alarm is sent to
EventTime	datetime	Date and Time of alarm
TicketID	int	Ticket ID created from alarm
LogValue	float	Value causing alarm, below are process values: 0 -> Stopped 1 -> Running
AdminName	varchar	Administrator who assigned monitor process to machine

vMonitorAlarmSNMP	Listing of all alarms created by monitor SNMP Get objects.
Column Name	Type	Purpose
MonitorAlarmID	int	unique monitor alarm number
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with
MachineName	varchar	Machine Name used for each agent
MonitorType	int	3 -> Monitor SNMP Get
MonitorName	varchar	Name of monitor SNMP Get object
AlarmType	int	0 -> Alarm 1 -> Trending
AlarmState	smallint	1 -> Open 2 -> Closed
Note	varchar	Notes administrator has entered on the alarm
Message	varchar	Message created from alarm, email message body
AlarmSubject	varchar	Subject of alarm and email subject
AlarmEmail	varchar	Email Address(es) alarm is sent to
EventTime	datetime	Date and Time of alarm
TicketID	int	Ticket ID created from alarm
LogValue	float	Value causing alarm, if the return value of the SNMP Object Get command is a string the value will be the the Message
SNMPName	varchar	Name returned from SNMP Device on scan
SNMPCustomName	varchar	Custom name for SNMP Device
AdminName	varchar	Administrator who assigned monitor SNMP Get to machine

vMonitorAlarmAlert	Listing of all alarms created by monitor alerts.
Column Name	Type	Purpose
MonitorAlarmID	int	unique monitor alarm number
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with
MachineName	varchar	Machine Name used for each agent
MonitorType	int	4 -> Monitor alert
EventLogType	smallint	Only applies to AlertType=6(NT Event Log) 0 -> Application Event Log 1 -> System Event Log 2 -> Security Event Log
AlarmType	int	0 -> Alarm 1 -> Trending
AlarmState	smallint	1 -> Open 2 -> Closed
Note	varchar	Notes administrator has entered on the alarm
AlertType	int	2 -> Get File change alert 3 -> New Agent checked in for the first time 4 -> Application has been installed or deleted 5 -> Script failure detected 6 -> NT Event Log error detected 8 -> Protection violation detected 9 -> PCI configuration has been changed 10 -> Disk drive configuration change 11 -> RAM size changed 14 -> LAN Watch alert type 15 -> Agent offline 16 -> Low on disk space 17 -> Disabled remote control 18 -> Agent online 19 -> New patch found 20 -> Patch path missing 21 -> Patch install failed 23 -> Backup Alert
Message	varchar	Message created from alarm, email message body
AlarmSubject	varchar	Subject of alarm and email subject
AlarmEmail	varchar	Email Address(es) alarm is sent to
EventTime	datetime	Date and Time of alarm
TicketID	int	Ticket ID created from alarm
AdminName	varchar	Administrator who assigned monitor alert to machine

vMonitorAlarmSystemCheck	Listing of all alarms created by monitor system checks.
Column Name	Type	Purpose
MonitorAlarmID	int	unique monitor alarm number
Machine_GroupID	varchar	A concatenated representation of the machine id and the group id it is associated with
MachineName	varchar	Machine Name used for each agent
MonitorType	int	5 -> Monitor system check
SystemCheckType	smallint	1 -> Web Server 2 -> DNS Server 4 -> Port Connection 5 -> Ping 6 -> Custom
AlarmType	int	0 -> Alarm 1 -> Trending
AlarmState	smallint	1 -> Open 2 -> Closed
Note	varchar	Notes administrator has entered on the alarm
Paremeter1	varchar	First parameter used in system check
Parameter2	varchar	(Optional) Second parameter used by system check
Message	varchar	Message created from alarm, email message body
AlarmSubject	varchar	Subject of alarm and email subject
AlarmEmail	varchar	Email Address(es) alarm is sent to
EventTime	datetime	Date and Time of alarm
TicketID	int	Ticket ID created from alarm
AdminName	varchar	Administrator who assigned of monitor counter to machine