---
title: "Configure Views"
slug: "configure-views-1"
updated: 2026-02-16T12:55:13Z
published: 2026-02-16T12:55:13Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.lakesidesoftware.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Configure Views

A view is a custom query run on an endpoint database. You can use views to select data to be collected and uploaded to the cloud when agents condense data.

To access the Views page, select **Views** under **SysTrack Settings**. You can use this page to create, edit, delete, and duplicate views. The Add, Delete, and Duplicate icons display in the **Views** panel at the top of the page.

![files](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/views_buttons.jpg)

## Create Views

1. Click the Add icon and complete all fields in the **Settings** panel.

![files](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/Views_Setttings.jpg)
2. Enter a view definition in the **SQL Selection** panel. This can be modified after the view is created. The agents on each endpoint run the SQL once a day and send the results to the cloud, the results are stored in a table for you to view. The table name is indicated in the **Settings** panel.

You must complete either the Generic query, or the SQLite and SQL Server query.

![files](https://cdn.document360.io/87d11426-6b1f-4b19-b593-b71e55a81af3/Images/Documentation/Views_sql.jpg)

> [!WARNING]
> **IMPORTANT:** There are two scenarios where columns containing a specific data type are required:
> 
>   
> 
> - For all custom Views, a WGUID column is required. The column needs to contain the "GUID" data type.
> - For custom Views that are set to **Append Data**in **Settings** > **Lifespan** > **When Expired:**, a VWTIME column containing the "datetime" type is required.

> [!NOTE]
> **NOTE:** Factory views cannot be edited.
> 
> Once you have created your view, it should be added to the role applied to the systems you would like to collect the data from.