Horizon View Events Database Export Utility
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.
- Any Windows OS with Microsoft .NET 3.5
- VMware View 5.x or later
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.
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.
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.
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.
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.
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.
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
- 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