This video explains what Office telemetry is and how it can be used.
- View Offline
- [Instructor] Office Telemetry is a solution that provides information about your Office documents. This information includes the Office client usage, including the frequency of documents and solutions used, it manages and detects faulty add-ins and solutions, it checks for compatibility issues, and details critical failures of Office solutions. It also provides the links to correct, and in Office 2016, an option to fix it for me when applicable. Here's how Office Telemetry works.
First, the Telemetry Agent is installed on your devices. The Agent pushes the data to the Shared Folder. Then, the Telemetry Processor moves the data from the Shared Folder to the Database. And finally, the Excel Dashboard creates reports that are human readable. In order to deploy Office Telemetry, the following components are required. You need one license of Professional or Office 365 ProPlus, you'll need the Agent, a SQL Server, the Telemetry Processor, and the Telemetry Agent.
This may seem like a lot, but the Getting Started page of the Telemetry Dashboard provides step-by-step instructions and links to the required software. SQL Server is required to manage the data. You can use an existing installation of SQL or a new SQL Server can be installed. You must have rights to create and configure the SQL database as well as rights to the associated shared drive where the data will live. SQL Server Express can be used. SQL Server 2005 is the lowest version that is supported.
But just as a friendly reminder, SQL Server 2005 and SQL Server 2005 Express are no longer supported by Microsoft as of April 12th, 2016, and should not be used. The Telemetry Processor collects inventory and other data from the shared drive and then imports that data to the database. The Processor should be installed on a Server 2008 or above in a production environment. In a test or small production environment, the Telemetry Processor can be installed on Windows 7 with SP1 or above.
In this type of environment, there is a limit of 20 concurrent connections. A minimum of 11 gig of hard disk space is also needed for temporary Telemetry data. The Processor also creates a shared folder and database, configures the permissions and configures the database role. The Telemetry Agent is included in Office 2013 and Office 2016. For all other Office versions, the Agent must be deployed manually. The Agent collects the usage data and sends that data to the shared folder.
Please note, the Agent does not collect the contents of the files or anything information about files that are not in the most recently used list. The Agent pulls the user and computer name, it also provides file compatibility issues or critical errors, and details ActiveX controls, VBA macros, and data connections. The Agent needs to be enabled and configured using Group Policy.
- Restricting self-provisioning of Office 365 ProPlus
- Restricting and revoking activation
- Self-provisioning Windows Store apps and Office for Mac
- Managing deployments of Office 365 ProPlus
- Enabling telemetry
- Deploying agents
- Configuring Outlook, Skype, and Office Online
- Implementing authentication