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.
Create Views
Click the Add icon and complete all fields in the Settings panel.
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.
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 Datain Settings > Lifespan > When Expired:, a VWTIME column containing the "datetime" type is required.
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.