Views and Functions Provided

NOTE   Views can be returned using the API web services operations GetPublishedViews, GetPublishedViewRows, and GetPublishedViewColumns.

NOTE   Items marked with a flag icon are parameterized functions that are not available via the API web service operations described above. On premises users can access these flag icon functions using SQL Server.

Machines Group

vAddRemoveList

Add/remove application list returned by the latest audit.

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.

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.

vPortInf

The current list of ports in a client desktop machine.

vSystemInfo

Data collected by the Audit > System Info function.

vSystemInfoManual

Custom fields and values added to the SystemInfo function.

vUptimeHistory

Data collected for the uptime history report. Use in conjunction with the getMachUptime web service.

vvProAssetDetails

Lists information about a vPro enabled machine, including manufacturing details about the motherboard.

Activity / Status Group

fnMissingPatchCounts_UsePolicy

Returns the number of patches, using the patch approval policies, for the specified machine group. Tabular data as seen in the missing patch pie charts in the executive summary reports and the View Dashboard page under the Home tab. Only one row is returned.

fnMissingPatchCounts_NoPolicy

Returns the number of patches, without using the patch approval policies, for the specified machine group. Tabular data as seen in the missing patch pie charts in the View Dashboard page under the Home tab. Only one row is returned.

fnOSCounts

Returns the types of operating systems and the counts for each for the specified machine group. Tabular data as seen in the OS pie charts in the executive summary reports and the View Dashboard page under the Home tab. Returns one row for each OSType.

vAdminNotesLog

Notes each admin enters manually for a machine or group of machines. Entries in this log never expire.

vAgentConfiguration

Lists agent specific configuration data

vAgentLabel

Identifies the status of agents. Used for display purposes.

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.

vEventDetail

Provides a description of an event.

vEventInstanceDetail

Provides a description of an event instance that was triggered.

vEventInstanceHistoryDetail

Provides a history of event instances that were triggered.

vNetStatsLog

Network statistics log from the Agent.

vNtEventLog

NT Event log data collected from each managed machine.

vPatchApprovalPolicyStatus

The patch approval status of a patch by patch policy.

vPatchApprovalStatus

Show the approval status of a patch. There is one row for each active patch.

vPatchPieChartCountsNoPolicy

Provides patch counts for machines without an assign policy.

vPatchPieChartCountsUsePolicy

Provides patch counts for machines with an assigned policy.

vPatchPolicy

Show the approval status of a patch. There is one row for each active patch in each patch policy.

vPatchPolicyMember

Lists all patch policies to which each machine ID is a member, if any.

vPatchStatus

Information on the state of all patches on a per machine basis. There is one row per patch for each machine.

vPatchStatusByAgent

Describes the patch status of an individual agent machine.

vScriptLog

Log of procedure executions as viewed by the Kaseya Server.

vScriptStatus

Procedure 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

vMonitorAlarmAlert

The current list of alarms for all alerts.

vMonitorAlarmCounter

The current list of alarms for all monitor counters.

vMonitorAlarmProcess

The current list of alarms for all monitor processes.

vMonitorAlarmService

The current list of alarms for all monitor services.

vMonitorAlarmSNMP

The current list of alarms for all monitor SNMP Get objects.

vMonitorAlarmSystemCheck

The current list of alarms for all system checks.