A necessary part of any good application, service, or hardware is the ability to record and view log information. Why is this important? Log information can help admins in the pursuit of troubleshooting issues or in tracking down who accessed a system during a given period. In VMware View it will be likely that these types of details will also be very important to customers. Event information is not stored by default, and an event log database must be set up for View to record these events. Today I will walk you through the process of setting up the VMware View events database feature.
To accomplish this task we do indeed need a database for View to record its events into. The two options are a Microsoft SQL or Oracle database. The only other real requirement here is the it must use SQL server authentication and not Windows authentication. I won’t step you through database creation since it is very well documented elsewhere, such as on the VMware support site.
This part can be a bit fuzzy for server admins who do not regularly work with databases. With our database already created we need to create a local SQL account to use for accessing the database. In this example I’m using MS SQL 2008, and it should be very similar in other versions also. You can find more SQL help on the Petri SQL Server resource page.
Log into SQL Management Studio and find the Security folder. Then right-click it and choose to create a New >> Login.
You will be prompted with a window similar to the one shown below that will have both mandatory and optional fields. For the sake of this post, I’m going to just cover the minimum necessary for our task.
We are now ready to enter the connection details for the events database that was created. The following image shows the window and some sample details form my lab setup.
At this point we have successfully connected View with the database that was created. The image below shows what you should see in View manager once the connection is established.
You have the option to choose how long you would like events to be displayed for in the events logs. By default it is three months, but you can change this based on your requirements. The other option is to specify for how many days should items be considered new. This might be helpful if you do not plan on looking at events each day.
Now that everything is configured, we can now see if we have any events to look at. In my test it was a lab, so there was really nothing happening at the moment; if you have users actively using it, you might see more details. Otherwise, wait a bit and check back.
You are now armed and ready to be an events ninja for VMware View, remember with great power comes great responsibility. So use your tools wisely and hope this helps in your troubleshooting attempts.