Auditing Update Requests
Topic Last Modified: 2009-02-12
You can use the logs in the Logs\Server\Audit\imageUpdates\ folder to audit software update requests from UC devices. For Office Communications Server 2007 R2 Enterprise Edition, each Front End Server stores its audit logs in a separate file within the imageUpdates folder. A new log is generated by each Front End server each day. The files are distinguished by server name and date as follows: RequestHandlerAuditLog_<server name>_<date>.log. In order to see all of the update requests and responses for a given time period, you must view all of the entries for the appropriate dates in the different files.
The easiest way to view multiple log file entries together is to open the log files in Microsoft Excel. You can copy multiple log files into the same Excel spreadsheet so that you can analyze multiple days of update requests and logs from multiple servers at the same time.
This topic explains how to perform the following tasks:
- View audit logs in Microsoft Excel.
- Verify that a request was received from a particular device, for example, when testing Device Update Service connectivity or testing a device update.
- Verify that a device received the correct update, for example, when testing Device Update Service functionality, testing a device update, or troubleshooting a problem with a device.
- View information about the UC devices that are currently running in your organization and the updates that have been deployed to them.
Prerequisites
To view and work with log files, you must be logged on as a member of the RTCUniversalServerAdmins group or with an account that has equivalent user rights.
To view audit log files in Microsoft Excel
Locate the log files in Logs\Server\Audit\imageUpdates\.
Copy the audit log files that you want to view to another folder.
Change the file extension of the copied log files to .csv.
Double-click each log file that you want to view.
To view the contents of log files together, copy the contents of all files into a single spreadsheet.
To verify that a request was received from a particular device
In Microsoft Excel or a text editor, open the audit log file for the date that the request was sent from the device.
Note
The log file is updated every five minutes, so be sure to wait five minutes from the time the device made the request before you check the log file.
Search in the file for the device ID, which is the MAC address for Communicator Phone Edition or the serial number for RoundTable.
If you can locate the entry for the device, in the Request Date Time field, verify that the date and time of the request are correct.
If there is no entry for the device or the date and time are incorrect, there is an issue with the connection between the device and the Device Update Service.
For details about verifying device connections, see Verifying the Connection for a Test Device.
To verify that a device received an update
In Microsoft Excel or a text editor, open the audit log file for the date that the update request was sent from the device.
Note
The log file is updated every five minutes, so be sure to wait five minutes from the time the device made the request before you check the log file.
Search in the file for the device ID, which is the MAC address for Communicator Phone Edition or the serial number for RoundTable.
In the Response field, verify that the response contained the correct update.
The following example shows a response in the form <update file name>;<update version>;<date and time of the response>:
To view update and UC device information for your organization
Import into an Excel worksheet the audit log files that were generated on the dates for which you want to view logging information.
Do one of the following:
- In the Response list, view the list of deployed updates.
- In the MAC Address list, view the MAC address of the Communicator Phone Edition devices in your organization that have sent a request to Device Update Service during the time period of the logs.
- In the Serial Number list, view the serial numbers of the RoundTable devices in your organization that have sent a request to Device Update Service during the time period of the logs.
- View other items in the log, as needed. All of the categories are described in Update Audit Log Schema.