250 likes | 762 Views
Office 365 ProPlus Office Telemetry and Compatibility. Office 365 ProPlus Deployment Track. Agenda. Office upgrade challenges. Office Telemetry Overview. Inside Office Telemetry. Office Upgrade Challenges. Training. Office Compatibility. Deployment.
E N D
Office 365 ProPlus • Office Telemetry and Compatibility
Agenda Office upgrade challenges Office Telemetry Overview Inside Office Telemetry
Training Office Compatibility Deployment “How does this fit in the services world?” Traditional Enterprise Office Deployment User Acceptance Testing Inventory Pilot Triage New Capability Training Desktop Imaging Testing Stand-alone Installations 3-9 Months Fixing 1-2 Months Up to One Year Before First Seat Deployed 2-4 Months
Common Headaches VBA, Add-ins, and Macros Still work? Complex docs Print the same? Third-party apps Still functional? Users slowed down by faulty add-ins! “Wouldn’t it be easier todo nothing?” Impractical to test every solution
Office Telemetry Dashboard Overview
Office Telemetry Enables Determine frequency of documents & solutions used Manage add-ins & solutions Report detected issues & performance Track deployments
Demo Telemetry Dashboard Introduction
How Office Telemetry Works Office 2013 Clients Telemetry Dashboard Telemetry Foundation Database Collection Point Office 2010/ 2007/2003 Clients Processing Service Group Policy
Specify Office solutions / file type Privacy Solutions Obfuscate the file properties ab**** Threshold of use by specified limit Hide Filter Threshold Minecraft acquisition plan.docx Mi********(1).docx
Telemetry Elements Telemetry Elements Office 2013 Clients Telemetry Agents Telemetry Dashboard Office 2013/ 2007/2010 Clients Database Collection Point Telemetry Processor Group Policy
Telemetry Agent Group Policy Template ProPlus Pre ProPlus office15.admx and office15.adml User Configuration\Administrative Templates\Microsoft ProPlus\Telemetry Dashboard System info ~25,000 Users (~8hrs) Office 365 ProPlus Most recently used files 11GB Registry Setting Static Scan 64KB Add-ins startup Registered add-ins Policy and Registry Office 2003+ Runtime events Telemetry Collection Point Telemetry Issue logging 50KB Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\15.0\osm] "CommonFileShare"="\\\\<SERVERNAME>\\<SHARENAME>" "Tag1"="<TAG1>" "Tag2"="<TAG2>" "Tag3"="<TAG3>" "Tag4"="<TAG4>" "AgentInitWait"=dword:00000258 "Enablelogging"=dword:00000001 "EnableUpload"=dword:00000001 "EnableFileObfuscation"=dword:00000000 "AgentRandomDelay"=dword:000000F0 Static Scan Setting
Telemetry Agent Settings Group Policy Template office15.admx and office15.admlUser Configuration \Administrative Templates \Microsoft Office 2013 \Telemetry Dashboard
Telemetry Elements Telemetry Elements Office 2013 Clients Telemetry Agents Telemetry Dashboard Office 2013/ 2007/2010 Clients Database Collection Point Telemetry Processor Group Policy
Telemetry Processor Windows Server 2008+ (Windows 7+) SQL Setting Access permission “td_readonly” 1 Telemetry Processor Up to 50,000users Database can handle multiple Telemetry Processors 10,000 users x 1yr 14GB Error log %systemroot%\ServiceProfiles\NetworkService\AppData\Local\Temp\DPERRORLOG.txt Osql.exe SQL Server 2005+ (Express Edition) > osql.exe -E -S servername\instancename -d databasename -Q "EXEC sp_addrolemember 'td_readonly', 'domain\grouporuser'" > osql.exe -E -S servername\instancename -d databasename -Q "update [ServerSettings] Set [IntValue] = 3 Where [Name] = 'SolutionFilterThreshold'" Windows Database size Settings SQL Server
Telemetry Dashboard Admin Tool Privacy Replace collected data to obfuscate Change server settings of Solution threshold easily Optimization Copy/Move old events data to separate database Delete data of userX, department, file name Replace or manage tags Deployment Change server settings to manage Change permission to allow / decline user to access easily Copy / Delete / Move Cleanup ab ac Replace Setting / Permission Replace Setting / Permission
Mining Data from the Dashboard ActiveX Macros Builds Scope
Demo Telemetry Custom Reports
LAB OBJECTIVES Install the Office Telemetry components Install and use Office Telemetry Dashboard Navigate through the Office Telemetry Dashboard Create a custom report