fling logo of Horizon View Events Database Export Utility

Horizon View Events Database Export Utility

version 2.2 — March 27, 2020

Contributors 1

View All

Comments 91

  • profile picture of Chris Halstead
  • profile picture of Chris Halstead
  • profile picture of Chris Halstead
  • profile picture of Chris Halstead
  • profile picture of Chris Halstead
  • profile picture of Robert-Jan
  • profile picture of Chris Halstead
  • profile picture of Chris Halstead
View All

Summary

The VMware View Events Database is used to record all the events that happen in a View environment. There is a great deal of good information in the database, but it can be difficult to extract. This utility allows administrators to easily apply very detailed filtering to the data and export it to a .CSV file. You can filter on time range, event severity, event source, session type (application or desktop), usernames and event types. The application allows for extremely granular export of data. The exported columns can also be customized and the application will export data from both the live and the historical tables in the View Events Database.

Requirements

  • Any Windows OS with Microsoft .NET 3.5
  • VMware View 5.x or later

Instructions

When you open the application for the first time you will need to establish a connection to an existing View Events DB. You can choose to authenticate via SQL or Windows authentication, depending on what your SQL server is currently configured for. This connection data is stored in the registry under HKCU\Software dynamically as you type in the settings. The password (if using SQL Authentication) is encrypted in the registry.

  • SQL Auth Type: Choose Windows or SQL. Windows will pass through the credentials of the currently logged in user.
  • DB Server: The address to the SQL server along with the instance name if required. server\instance.
  • Database: The name of the View Events Database.
  • Username: The SQL username with at least read access to the DB if using SQL Authentication.
  • Password: The SQL password if using SQL Authentication. The password is encrypted when stored.
  • Table Prefix: View allows the use of a table prefix so you can monitor multiple view instances from the same database. If table prefix is used, type it in.
  • Click “Test Connection” – this will initiate a connection to the database and indicate success or any connection issues. If any required data is missing you will be notified as to what information must be entered in order to connect to the SQL DB.
  • When you are able to connect to the database successfully, click the “Connect to DBServer” button at the bottom of the form. You are now connected to the View Events DB. The button will indicate connection state. You can click the button again to disconnect from the DB server.
  • Filtering Data: As mentioned earlier the application allows for many layers of filtering of the View Event data before export.

General Filtering

The general filtering tab allows for high-level filters to be set that will apply to the data as it is queried and exported.

Query Historical Data: By checking the “Query Historical Data” checkbox, the application will use the historical tables in the View Events DB to query older data.

Time Range: The time range will automatically be populated with the time of the first and last event in the View Events DB. You can click the date/time picker to choose a specific start and end date range to query.

Query on Severity: The “Audit Fail”, “Warning”, “Informational” and “Error” checkboxes control what severity of events you want to query and export. They are all selected by default.

Query on Module: The “Broker”, “Admin”, “Agent” and “Vlsi” checkboxes allow you to determine what modules you want events to be exported for.

Broker – All brokering activity
Admin – Administrative actions, typically through the GUI
Agent – View Agent events
Vlsi – VMOMI Leveraged Server Infrastructure – these are API related calls.

Session Type: You can query if you want to return only desktop or application session types. NOTE: This entry is only populated for specific events, so use sparingly to avoid limiting search results too much.

User Filtering

By default the application will return data for all usernames when running a query. The user filtering tab allows you to filter the results returned on specific usernames. The usernames are populated dynamically out of the Events Database, so there is no need to type them in.

To filter on usernames do the following:

  • Click the “Refresh Users” button to populate the list of usernames.
  • Select the users you want to filter on and click the down arrow to add to the “Users to Export Data For” list box.
  • You can de-select a user by selecting it in the “Users to Export Data For” listbox and clicking the Up Arrow.
  • If you want to reset the filter to all users, click the “Return Data for All Users” checkbox.

NOTE: If you choose to filter on usernames, the application will automatically filter the items in the “Event Filtering” and “Pool Filtering” tabs based on records for those specific users. That way you will see the only records that actually apply to those users.

Pool Filtering

The application allows filtering of specific desktop pools. You can select as many pools as you want to return. If you filter on any users, you will only see the pools that apply to those specific users.

  • Select the pool names you want to query on and click the Down Arrow to add to the “Pools to Export Data For” listbox.
  • Selected Pools can be removed by selecting them in the “Pools to Export Data For” listbox and clicking the Up Arrow.

Event Filtering

The application allows filtering of specific event types. You can select as many event types as you want to return. These events are also filtered by selecting the “Module” checkboxes on the “General Settings” tab as shown above (Broker, Agent, Admin, Vlsi). In addition, if you filter on any users, you will only see the event types that apply to those specific users.

  • Select the event types you want to query on and click the Down Arrow to add to the “Events to Export Data For” listbox.
  • Notice in the screenshot below how events are filtered based on selected users and the label indicates this filtering.
  • Selected Event Types can be removed by selecting them in the “Events to Export Data For” listbox and clicking the Up Arrow.

Exporting Data

At this point, you are ready to export data based on the filters you selected. Click on the “Export Data” tab.

Columns to Export:
You can choose which columns to export into the .CSV file. Simply check or uncheck the column name to add or remove it from the output. NOTE: Certain columns are specific to user events (Pool Name, Username, Session Type and Desktop Name), and the Server Name column is only available when no users are selected. Client IP Address is only available when the BROKER_USERLOGGEDIN event type is selected or All Events are returned.

Select File to Export Data Into

At this point you will select a .CSV file to export the data into. You need to use the built-in file save dialog to select the file. Click the ... button to open the file save dialog. The application will provide a default name – you can change the name as required. Click the “Save” button when you are satisfied with the file name and location.

  • Show SQL Command: This is an optional item that will show you the parameterized SQL command to be executed.
  • Click the "Export Data" button when ready to export the data.
  • The query will now export; you will see a progress bar and the “Export Status list box will populate with the data as it is written to the .CSV file.

Changelog

Version 2.2

Fixed the following issues:

  • Able to return data for All Pools
  • Able to return data on just user logon and logoff events
  • Both of these actions would cause a crash or error in previous versions

Version 2.0

  • Added support for RDSH Pools
  • Returns desktop name now
  • Several bug fixes
  • Tested with Horizon 7.11
  • Version 1.6 fixes the export of Client IP Addresses

Similar Flings

No similar flings found. Check these out instead...
Sep 08, 2022
fling logo of Horizon Network Label Assignment Tool

Horizon Network Label Assignment Tool

version 1.0

Horizon Network Label Assignment Tool helps the administrator to deploy large pools with a single Parent Virtual Machine or template by enabling to set up multiple network labels present on the ESXi host Cluster. It also provides an option to reset and view the network label configuration setting set previously in a tabular format.

Jun 23, 2020
fling logo of Diagnostic Tools for Unified Access Gateway

Diagnostic Tools for Unified Access Gateway

version 1.0

This fling is collection of scripts which will help troubleshoot various issues on UAG w.r.t specific services hosted on UAG. The script which is released first as part of this fling is to identify any misrouting session (Horizon) due to incorrect Load Balance configuration.

Apr 26, 2023
fling logo of USB Network Native Driver for ESXi

USB Network Native Driver for ESXi

version 1.12

This Fling supports the most popular USB network adapter chipsets found in the market.

Nov 10, 2022
fling logo of Skyline Automation Toolkit

Skyline Automation Toolkit

version 1.2.7

The Skyline Automation Toolkit is designed to save valuable time in remediating potential issues surfaced by Skyline Advisor to ensure stability, security and productivity. The Toolkit allows cloud admins and SREs to automate Skyline Advisor's Proactive Intelligence with their own tools and processes.

Feb 22, 2021
fling logo of Horizon Reach

Horizon Reach

version 1.3.1.2

Horizon Reach aims to resolve this disconnect between Cloud pods and distinct environments by discovering, monitoring and alerting on issues across your entire Horizon estate from a single UI. Horizon Reach gives alerts, usage reports, insights, etc. in a web console.

Apr 19, 2021
fling logo of Workspace ONE Access Migration Tool

Workspace ONE Access Migration Tool

version 1.0.0.24

Workspace ONE Access Migration Fling helps eases migration of Apps from one Access tenant to another (on-premise to SaaS or SaaS to SaaS).

View More