70-347 O365 V2

Office 365 Pro Plus - Manage activation

must be activated for users to be able to create and edit documents depending on the subscription level, each Office 365 user account generally allows for the activation of five concurrent instances of Office 365 ProPlus Activation usually occurs automatically when a user downloads and installs Office 365 ProPlus from the Office 365 portal.

OFFICE APPLICATIONS TO EXCLUDE FROM TELEMETRY AGENT REPORTING

exclude telemetry data from specific applications from being forwarded to the shared folder used by the Telemetry Processor

Allow External Users Who Accept Sharing Invitations And Sign In As Authenticated Users.

externals with o365/hotmail/outlook.com accounts to sign in who receive an invitation to view content site owners and users with full control perms can share sites site owners and users can choose to allow externals view or edit perms on docs they must sign in, and invites are tied to the account they used for access

Telemetry Agent Install

get the MSI files that allow for the installation of the Telemetry Agent through the Deploy Telemetry Agent section of the Getting Started worksheet of the Telemetry Dashboard Clicking on either the x86 or x64 Telemetry Agent MSI links will prompt you to save the Telemetry Agent Installer Package, These MSI files can then be deployed to computers using Group Policy, Microsoft Intune, System Center 2012 R2 Configuration Manager, or any other software deployment solution.

powershell to manage external sharing

get-spotentant: check sharingcapability to change: set-spotenant -sharingcapability -disabled -existingexternalusersharingonly -externalusersharingonly -externaluserandguestsharing

change title of site

go to site, site settings, look and feel title, description, logo change title - OK

user-driven client deployments

great advantages of Office 365 is that it provides end users with the opportunity to perform self-service deployment of software to their own device Problems with user-driven: users exceeding their allocation of Office 365 ProPlus licenses

Disabling External Sharing

if you disable/re-enable - externals who had access previously will regain access site collection access will also be regained if you want to block specific site collection from being re-enabled, you have to disable it on per site basis first turning off external sharing at site collection disables guest links but doesn't remove them to remove access to specific document, you need to disable anonymous links changes to sharing takes up to 60 mins

Deactivating Office 365 ProPlus

maximum of five installations tied to their Office 365 account if you reach your limit you can deactivate one of existing licences to re-claim it deactivating doesn't remove the s/w, just puts it into reduced functionality mode

Restrict self-provisioning of Office 365 ProPlus

might want to allow users to install software directly from the Office 365 portal restrict this ability entirely allow usersto install some applications but restrict them from installing others

Before deploying the Telemetry Processor, ensure that you have the following information:

-Name of SQL server instance on which tele dash will be created or is present already -permission to create/config db on sql server (domain account assigned system admin role for the sql server instance) -permission to create shared folder or unc path of an existing folder -11gb or more of free hard drive space on the computer that hosts the telemetry processor role

install the Office Deployment Tool

1. On the computer on which you want to deploy the Office Deployment Tool, open a web browser and navigate to the following address: https://www.microsoft.com/en-us/ download/details.aspx?id=36778. 2. On the Office Deployment Tool For Click-To-Run webpage, click Download. 3. Save the installer file to a location on the computer 4. After the deployment tool has downloaded, double-click it to start the deployment tool setup. 5. On the Microsoft Software License Terms page, select the Click Here To Accept The Microsoft Software License Terms option and click Continue. 6. On the Browse For Folder page, select the folder in which to store the files associated with the tool. While these files can be extracted anywhere, you will need to interact with the tool frequently so you should create a folder in the root folder of a volume. 7. Two files will be extracted: Configuration.xml and Setup.exe,

To deploy the Telemetry Processor

1. Open the Telemetry Dashboard for Office 2013 spreadsheet and then click the Getting Started worksheet in the workbook. 2. Click the arrow next to Install Telemetry Processor 5. After the file has saved, double-click it to run the Telemetry Processor Installer. 6. On the Welcome To The Microsoft Office Telemetry Processor page of the Setup Wizard, click Next. 7. On the Completed the Microsoft Office Telemetry Processor page, ensure that Run The Office Telemetry Processor Settings Wizard Now option is selected, and click Finish. 8. On the Getting Started page of the Office Telemetry Processor Settings Wizard, review the information, and then click Next. 9. On the Database Settings page, enter the name of the database server and click Connect. The connection will be made using the credentials of the currently signed-on user. Enter a name for the database and then click Create. When the database is created, click Next. 10. On the Office Telemetry Processor Settings Wizard dialog box, click Yes to configure database permissions and database role settings. 11. On the Shared Folder page, click Browse. 12. Create and select a shared folder - must be empty 13. On shared folder page, click next 14. Review information on info dialog, informs you that authenticated users will be granted ability to create files/write data back to the folder without being able to browse contents of folders, click YES 15. On the Microsoft Customer Experience Improvement Program page, decide if you want to participate in the Customer Experience Program. 16. On the Configuration Successful page, click Finish. 17. After the Telemetry Processor is deployed, return to the Telemetry Dashboard spreadsheet and on the Getting Started tab, under section 5: Connect To The Database To View Telemetry Data, click Connect To Database 18. The Data Connection Settings dialog box, should be automatically populated with the name of the SQL instance and the name of the database. Click Connect 19. Until you have configured telemetry collection, the Telemetry Dashboard will display a message informing you that there is no telemetry data

To Deactivate an existing office 365 pro plus activation

1. Sign in to the Office 365 portal with their Office 365 user account. 2. Navigate to the software page at https://portal.office.com/OLS/MySoftware.aspx. 3. On the software page, locate the computer for which you want to deactivate an existing activation and then click Deactivate. 4. You will be prompted to confirm that you want to deactivate the installation, Click Yes. 5. If you attempt to start an Office 365 ProPlus application after the product activation has been deactivated, you will be presented with the Product Deactivated dialog box, 6. You can either manually enter an Office product key to reactivate the installation, or sign in with your Office 365 subscription and attempt to perform activation 7. If you have not reached your activation limit, you will be able to successfully activate the deactivated copy of Office 365 ProPlus

To install Office for Mac 2011/2016

1. Using a web browser, navigate to https://portal.office.com and sign in with your Office365 user credentials 2. On the Office 365 Welcome page, click Install. 3. The computer operating system will automatically be detected and Office for Mac 2011 will be offered. Click Install to trigger a download of the disk image containing the Office for Mac 2011/2016 installation files 4. When the disk image file containing the Office for Mac 2011/2016 has downloaded, open it and double-click the Office Installer . This launches the MicrosoftOffice for Mac 2011/2016 installer. 5. On the Welcome page of the Microsoft Office For Mac 2011/2016 Installer, click Continue. 6. Review the Software License Agreement,, and click Continue 7. When prompted to agree with the license agreement, you will need to click Agree, to continue with the installation. 8. On the Installation Type page, click Install. Click Customize to change the installation options, such as placing the files on a separate disk. 9. The installer prompts you for the credentials. (Remember, you must have the credentials of a user who has permission to install software on the Mac OS X computer.) Provide your credentials, and then click Install Software. 10. After a period of time, the installer will report the installation has completed successfully. Click Close to exit the wizard 11. Exiting the installation wizard will trigger the Get Started With Office 2011/2016 wizard . Click Sign In To An Existing Office 365 Subscription to initiate the activation process

To install Office for Mac 2011 cont'd

11. Exiting the installation wizard will trigger the Get Started With Office 2011 wizard . Click Sign In To An Existing Office 365 Subscription to initiate the activation process 12. Enter the email address associated with the Office 365 account 13. When prompted, enter the password associated with the Office 365 account, and click Sign In. 14. You might be prompted to give Office access to your contacts, Choosing not to provide access to contacts will still allow the installation to complete normally. 15. Provide the first name, last name, and company name that you want to associate with this Office for Mac installation, and then click Continue. 16. On the Help Improve Microsoft Office page, choose whether you want Office for Mac to automatically download updates and whether you want to join the Customer Experience Improvement Program, a After your choices have been made, click Continue. 17. When activation has been completed successfully, you will see a message congratulating you, Click Done to complete the installation process.

Telemetry Log cont'd

A file or solution must be either loaded or opened within the local Office application before information about it will be present in the Telemetry Log. To open the Telemetry Log, on the start menu type "Telemetry Log For Office 2013,"Use the name Telemetry Log For Office 2013 for both Office 2013 and Office 365 Pro Plus. The events worksheet of the Telemetry Log shows event information. This is the primary view of the log that you would use if attempting to diagnose user issues using the Telemetry Log. The System Info worksheet provides you with information about the computer on which the Telemetry Log is being run, including user name, computer name, system type, Windows edition, time zone, Telemetry Log version, and Office edition

By Default Office Pro Plus downloads the following:

Access, Excel, InfoPath, OneNote, Outlook, PowerPoint,Publisher, and Word

Create Site Collection

Admin - SharePoint Site Collections New - Private Site Collection title website address template section - collab/enterprise/publishing/custom time zone administrator storage quota server resource quota

Per-site collection storage management

Admin - SharePoint Site Collections Select the site collections you want to configure quota for Select Storage Quota In dialog box - configure limit storage quota for each selected site collection to a maximum of XX -send email to site collection admin when site collection reaches XX

Sharepoint Enable External User Sharing Globally

Admin - SharePoint Admin Center - Sharing (used to be settings) Don't allow sharing outside your org Allow sharing only with external users that already exist in your org's directory Allow users to invite and share with authenticated external users Allow sharing to authenticated external users and use anonymous access links

Delete Site Collection

Admin - Sharepoint Site Collection select site collection click delete Delete

Purchase additional storage

Admin/SharePoint Site Collections Buy Storage Enter o365 credentials (global/billing) Manage Subscription - pick subscription Add More link Optional Add-Ons - enter GB you would like to add or you could add additional licences Add Licences - Place Order

Exclude Office progams for download

Administrators can configure deployments so that only some, not all, of these programs will install. You can configure which programs are excluded from Office 365 ProPlus using the Office Deployment Tool

Regular reactivation

After Office 365 ProPlus has been activated on a computer, additional activation checks must be performed every 30 days These automatic activation checks occur automatically when the computer connects to the Internet. This 30-day period is an important consideration for certain types of scenarios and will determine whether it's okay to deploy Office 365 ProPlus or if it is necessary to deploy an appropriate edition of Office 2013.

Allow Both External Users Who Accept Sharing Invitations And Guest Links.

Anonymous guest links allow access without any form of authentication site owners and users with full control perms can share sites site owners and users with full control perms can choose to allow externals view or edit perms on docs when sharing a doc, you can choose to grant view and edit perms externals are required to sign in with MS account before accessing content anonymous links can be shared and forwarded, so unauthorized people can be granted permission assigned when the document is shared with the link

Allocating Storage

Automatically - pooled storage model Manually - manually configure storage allocations on per-site collection basis

Enable telemetry through Group Policy

Before you can enable telemetry through Group Policy, you need to install the Office 2013 Group Policy administrative template. You can download the administrative template from the Microsoft website at http://www. microsoft.com/en-us/download/details.aspx?id=35554. You'll need to download the file to a domain controller and then run it. If you are deploying to a Windows Server 2012 R2 domain controller, ensure that you download the 64-bit version of the administrative template file. This is because Windows Server 2012 R2 is an x64 platform. While the x86 version will likely also run, you should choose the architecture that matches the platform on which you will install the template. When running the file downloaded from the Internet, you will be asked to agree to the license terms, When you have agreed to the license terms, click Continue. You will be asked to choose a temporary directory in which to extract the template files. After you have extracted the files, you will need to do the following: ■■ Copy the file Office15.admx to the C:\Windows\PolicyDefinitions folder. ■■ Copy the language appropriate Office15.adml file to the C:\Windows\PolicyDefinitions\ Language folder. For example, if using EN-US for US English, copy the Office15.adml file from the EN-US folder where you extracted the templates to the C:\Windows\PolicyDefinitions\ en-US folder Once admx/adml files are copied, the you can edit the following policies, which are located in the User Configuration\Policies\Administrative Templates\Microsoft Office 2013\Telemetry Dashboard

Pooled Storage Model

Came in 2015 - default Admin - SharePoint Settings Site Collection Storage Management -manual -automatic

MSI Install

Classic Install - double-click installer, use group policy, MS Intune, or SCCM or third-party app deployment product. App not available until install complete. Layered servicing - updates must be applied after install complete. Might take some time to install to get install current. Increases install time Volume licencing - office 2013/2016. Option to use licence key. Only available to orgs that have volume licencing agreements with MS Volume activation - allows large numbers of products to be activated, either through use of special activation key (at time of install) or through KMS server Selective app install - easy to deploy individual products Scenario limits - can use remote desktop services, windows to go, and devices that do not connect to internet

Office 365 and mobile devices

Microsoft has made Word, Excel, PowerPoint, and OneNote apps available for the Windows Phone, iOS, Android, and Windows RT mobile platforms

TURN ON PRIVACY SETTINGS IN TELEMETRY AGENT

Enabling this policy, obfuscates the file name, file path, and title of Office documents before telemetry data uploads into the shared folder If this policy is not enabled, the file name, path, and title of documents remain visible.

Reduced functionality mode

If Office 365 ProPlus is not in an activated state, it enters reduced functionality mode. Reduced functionality mode allows users to open and view documents, but restricts them from creating new documents or making modifications to existing documents users are prompted to reactivate the product on a regular basis.

Users access their newsfeeds from here

In app list - select newsfeed shows all existing posts on sites you are following if you have multiple - use drop down menu to select which site to post on

Delete Telemetry and Inventory Data on clients

In the users profile c:\users\administrator\appdata\local\microsoft\office\16.0\telemetry evt.tbl sln.tbl user.tbl delete the three files

Sharing a site

Login to O365 with account with proper permissions Select Sites Choose Site you want to share Click Share Put in name of person you want to share with and choose level: -excel services viewers (view only -team site members (edit) -team sites owner (full control) -team sites visitors (read) Invitation will be sent - they have 7 days to accept

Server Resource Quota

Numerical Way of representing RAM and CPU utilization Each SP deployment allocated a server resource figure based on the number of licences. Used for customized site collections or sandboxes. If number of resources used in 24-hour period exceeds resources available, SP Online turns off sandbox, then custom code can't run. It is turned back on when 24-hour period expires and the resource number is reset.

Telemetry works with:

Office 2013 and Office ProPlus and is included with the applications. Some Office Telemetry features are available for earlier versions of Office if the Office Telemetry Agent is installed on each computer running the previous version of Office.

Central deployment

Office 365 ProPlus can be downloaded to a local shared folder and then deployed centrally. IT department must use the Office Deployment Tool to download the Office 365 ProPlus software from Microsoft servers on the Internet. successful installation of Office 365 ProPlus requires the ability for the software to activate against Microsoft Office 365 servers on the Internet. You can't use a volume licensing solution, such as a Key Management Services (KMS) server, to activate Office 365 ProPlus even when you are deploying it centrally.

Report user issues

Office Telemetry Log is a local log file that is automatically installed when you install Office 2013 or Office 365 Pro Plus tracks the solution types listed in for Office 2013 and Office 365 ProPlus applications: Task pane apps Excel, Word, Project Apps located in the task pane of the client application Task pane apps - excel/word/project - apps located in task pane of the client app Content apps - excel - apps integrate into office doc mail apps - outlook - apps that appear in outlook - when msg contains specific word/phrase active doc - word/pp/excel - files with active x, external data connections, macro enabled, open xml (docx, pptx, ppsx, xlsx), binary files (doc, ppt, pps, xls com add-in - word/excel/pp/outlook - com add-ins including visual studio app level add-ins excel automation add-in - excel - Excel-supported automation add-ins built on COM addins Excel XLS RTD addins - excel - Excels worksheets that use the RealTimeData worksheet function Word WLL add-ins - word - WLL are work-specific add-ins built with compilers that support the creation of DLLs Application add-ins - Word, PowerPoint, Excel - Application-specific files that contain VBA code (.dotm,.xla, .xlam, .ppa, .ppam) Templates - Word, PowerPoint, Excel - Application-specific templates (.dot, .dotx, .xlt, .xltx, .pot, .potx)

Deploy agent

Office Telemetry works natively with Office 2013 and Office ProPlus To use Office Telemetry with Office 2003, Office 2007, and Office 2010 it is necessary to deploy special agent software This agent will collect data about any installed Office addins as well as any documents that have been recently accessed Office Telemetry Agent for previous versions of Office collects inventory and usage data only Office Telemetry Agent for previous versions of Office does not collect application event data.

Configure outlook with exchange online account

Once outlook is installed, you need to configure to access Exchange Online Add Office 365 email account Open Outlook - click next on welcome window Add an email account - Yes Auto Account Setup Page - real user name office 365 email address (same as o365 sign on) o365 password and retype it - next 2nd prompt for user password on security box - OK Once dialog reports outlook has been able to successfully log on to mail server - click finish

Basic methods to share with external

Share entire site and invite users to sign in with ms account share individual documents by inviting external users to sign in using ms account send user a guest link that allows externals access to each document that you want to share anonymously

Assign a resource quota

Sign in to o365 with account with correct perms Admin - SharePoint Site Collections Select site Click Server Resource Quota Assign number to collection and you can assign % reached when it can email Save

View who has accepted invite

Sign in with O365 account with perms Sites Select Site Click Share In Share Site dialog - click Shared With

Site Collection Administrators

Sign in with o365 account with perms Click Admin - SharePoint Admin Centre Site Collections Select Site Select Owners - Manage Administrators Can have one primary site collection administrator Can have multiple site collections administrators Add names - OK

Create sharing link

Sign in with o365 account with perms Sites Select Site Documents - select document Click Share Click Get a Link - choose View Only or Edit or Both

Remove External Access

Sign in with o365 account with perms Sites Select Sites Select Settings Select Users and Groups Select People and Groups Select User - click Actions - Remove User From Group

Click to Run

Streaming Installation - allows app to run before install is completed. First part of install provides minimum functionality. Slipstreaming servicing - updates included in install. Click to run has most up-to-date version of app. User-base licensing - proplus license based on user account not computer (can be installed on up to 5 computers) Retail activation - activated via internet not through volume licencing. Must connect every 30 days SKU-Level app suites - unless admin changes config, proplus installs all products. Depends on subscription. All users get all products, you can't just choose powerpoint etc. for some. You can change what gets installed but then you need different config files for each set of apps. Scenario limits - cannot use o365 proplus with remote desktop services, windows to go or networks that can't connect to internet

TURN ON TELEMETRY DATA COLLECTION

The Turn On Telemetry Data Collection policy must be enabled If this policy is not enabled, Office telemetry data collection will not occur.

Configure Skype for Business Client

To connect to Skype for Business online, user must enter their O365 email address - click sign-in they will be prompted for O365 password, once authenticated, they can add contacts, join meetings etc.

When allowing users to self-provision software from the Office 365 portal, keep the following in mind.

To successfully run Office 365, users will need an Office 365 license to install the software they downloaded from the Office 365 portal, they will need to have local administrator privileges on their computer self-provisioning of software through the Office 365 portal is a suitable strategy in Bring Your Own Device (BYOD) scenarios where the user is the owner of the computer and is responsible for its configuration Standard Operating Environment (SOE) computers worry less about self-provisioning because they rarely have local admin rights If you don't make s/w available, users will see message that informs them office installations have been disabled when they go to s/w page in o365 portal

TURN ON DATA UPLOADING FOR THE TELEMETRY AGENT

When you enable this policy, Office telemetry data is uploaded to a shared folder specified in another policy If you don't enable this policy, Office telemetry data is stored on the client and cannot be accessed at a central location through the Telemetry Dashboard.

Office 365 ProPlus is only run on the following operating systems

Windows 7 sp1 ■■ Windows 8 ■■ Windows 8.1 Windows 10 ■■ Windows Server 2008 R2 ■■ Windows Server 2012 ■■ Windows Server 2012 R2 Windows Server 2016

Configuration.xml

You use the Configuration.xml file to perform the following tasks: ■■ Add or remove Office products from an installation. ■■ Add or remove languages from the installation. ■■ Specify display options, such as whether the installation occurs silently. ■■ Configure logging options, such as how much information will be recorded in the log. ■■ Specify how software updates will work with Click-to-Run.

Office Web Apps

allow basic functionality of variety of MS Office apps through web browser word, excel, pp and one note online if you have o365 accounts - you can access documents stored in org's locations such as one drive for business and sharepoint online. docs will be able to be opened directly from OWA or Lync Web App. Office Web Apps support azure rms functionality on supported browsers

Newsfeeds

allow members of org to post and reply to posts exist at the SP Online tenancy level can exist at team site level

SPECIFY CUSTOM TAGS FOR OFFICE TELEMETRY DATA

allows you to apply tags to telemetry data forwarded to the shared folder used by the Telemetry Processor can specify up to four separate tags,

Deploy Telemetry Dashboard

allows you to view information collected by the Telemetry Processor, a special server that you deploy on the network to collect telemetry information installed automatically when you install Office 365 ProPlus, Office Professional Plus 2013, and Office Standard 2013 specially configured Excel worksheet that connects to a database hosted on a supported SQL instance

Click to Run and MSI similiarities

both can be configured through group policy both provide telemetry through dashboard both can use the same file extensions

telemetry service

compatibility-monitoring framework use it to assess Office compatibility issues.

To use the Telemetry Dashboard for Office 2013

configure a computer to function as the Telemetry Processor and a computer to host the SQL Server database used by the Telemetry Dashboard for Office 2013 - they can be same computer

Delete Site Collection

deletes the following: -document and library -lists and list data -site config settings -site and sub-site role and security info -sub-sites of top-level website -web parts -document webspaces -content types -user associations

Site Collection Storage Quota

determine how much storage space can be used allocated by base of 10gb plus 500mb per user Site collection can have max of 1tb View storage Admin - SharePoint Site Collection storage and resource quota shows

Telemetry Dashboard Admin Tool - to turn off threshhold of number of people who accessed files

download tdadmsetup.msi extract files run tdadm.exe command prompt tool tdadm -o settings -databaseserver dc1\instance -databasename name -threshhold 3 3 reporting will only people who have accessed files by three people

Office Deployment Tool

must be run from an elevated command prompt in the /configure and /packager modes. To run the Office Deployment tool in download mode against a configuration file stored in the c:\ClickToRun folder, use the syntax: Setup.exe /download c:\ClickToRun\configuration.xml To run the Office Deployment Tool in configure mode, when the tool is hosted on the share \\SYD-Deploy\O365 and the configuration file is stored on the share \\SYD-Deploy\ Configs, run the command: \\SYD-Deploy\O365\Setup.exe /configure \\SYD-Deploy\Configs\Configuration.xml

Installing O365 on mobiles

navigate to the Office 365 portal using the mobile device on which you want to install each application and select the app that you want to install from the list that is available Selecting an app opens the app's page in the appropriate vendor's app store The application can then be downloaded from the App Store and installed on the device. These applications can also be installed directly from each mobile device operating system vendor's app store

To use all the available features of each app on mobile

necessary to sign in to the app using your Office 365 user account credentials

powershell for new site

new-sposite -url siteurl -owner [email protected] -storagequota 2000

Disable data collection for telemetry agent

registry hkcu/software/policies/microsoft/office/16/osm enablelogging - 0 enableupload - 0 Group Policy user configuration/policies/administrative templates/microsoft office 2016/telemetry dashboard turn off data uploading - disable turn on telemetry data collection - disable

Telemetry - obscure user and file data

registry hkcu/software/policies/microsoft/office/16/osm new dword EnableFileObfuscation 1 group policy windows/policy definitions user configuration/policies/administrative templates/microsoft office 2016/telemetry dashboard turn on privacy settings in Office Telemetry Agent - enabled

Telemetry Reporting Exclusions

registry hkcu/software/policies/microsoft/office/16/osm new key preventedapplications preventedsolutiontypes under preventedapplicaitons new dword for example access: -accesssolution 1 for example outlook: -olksolution 1 for example powerpoint: -pptsolution 1 under preventedsolutiontypes new dword for example com addins: -comaddins 1 for example app addins: -appaddins 1 Group Policy user configuration/policies/administrative templates/microsoft office 2016/telemetry dashboard office applications to exclude... office solutions to exclude.... enable and tick application/solutions to exclude

powershell to add resource quota

set-sposite -identity site url -resourcequota 300 -resourcequotawarninglevel 80

powershell to add site collection admin

set-sposite -identity siteurl -owner [email protected] powershell will add them as primary and site collection admin list

powershell for site collection storage quota

set-sposite -identity siteurl -storagequota 3000 -storagequotawarninglevel 2000

powershell to change the title

set-sposite -identity siteurl -title "New Title"

powershell to manage external sharing on SITE Collection

set-sposite -sharingcapability disabled -identity sitecollectionurl

configure which Office software users are able to install from the portal

signed in to Office 365 with a user account that has Administrator permissions open the Office Admin Center select Settings select Services & add-ins Office software download setting options that are available here will depend on the Office 365 subscription restrict users from deploying software from the Office 365 portal, clear the check box next to the listed software.

OFFICE SOLUTIONS TO EXCLUDE FROM TELEMETRY AGENT REPORTING

stop telemetry data from the following Office solution categories from being forwarded to the Telemetry Processor: ■■ Office document files ■■ Office template files ■■ COM add-ins ■■ Application-specific add-ins ■■ Apps for Office

External user sharing per site collection

tenancy sharing must be enabled for this to work same options at site collection level as tenancy don't allow -prevents all users on all sites in the collection from sharing sites or connect -users are unable to share content with users who are not members of org's tenancy -if sharing was enabled previously, any perms will be deleted allow external users who accept sharing invites and sign in as authenticated users -allow users with MS accounts who have invites to access sites and content in site collection -site owners and users with full permissions can share sites/docs with externals who sign in with ms account -invites that are redeemed by external user are tied to account, cannot be shared. allow both externals users who accept sharing and anonymous links -site owners and users with full permissions can share sites/docs with externals who sign in with ms account -allow sites within site collection that have been authenticated ms accounts to be shared with users -invites can't be shared -Site owners and users with Full Control permissions are able to share documents through an anonymous link. -When sharing documents with external users or through anonymous links, View or Edit permission can be assigned. -Anonymous links can be shared with the original sharer, having no control over which external parties access anonymously shared content after the guest link has been forwarded.

Telemetry Notes:

that the name Telemetry Dashboard For Office 2013 applies even when the installed product is Office 365 ProPlus. You must have Excel installed to open the Telemetry Dashboard For Office 2013.

Configure Telemetry Agent through registry

to enable the collection of telemetry data from computers that are not members of an Active Directory domain and hence are not subject to Group Policy: create and import registry settings that will configure the Telemetry Agent. Using a text file with the .reg extension and then importing it into the registry. [HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\15.0\osm] "CommonFileShare"="\\\\SYD-SQL\\TelemetryData" "Tag1"="<TAG1>" "Tag2"="<TAG2>" "Tag3"="<TAG3>" "Tag4"="<TAG4>" "AgentInitWait"=dword:00000258 "Enablelogging"=dword:00000001 "EnableUpload"=dword:00000001 "EnableFileObfuscation"=dword:00000000 "AgentRandomDelay"=dword:000000F0

Follow - Newsfeed

to use newsfeed to have a convo with small number of users rather than everyone and you can create sites do the following: create site share site with people you want to be in convo use site-specific newsfeed for convo ensure users select site and choose follow

Share a document

two ways - external user that needs to authenticate and through anonymous link Sign in with o365 account with perms Sites Select Site Documents - select document Click Share On Share Page - invite people - add names - choose can edit or can view - tick/un-tick require sign-in Click Share Click Shared With - to see who has access to document

External Access to Sharepoint Online

use rights available to external users depend on the features available to the SharePoint Online tenancy with which they will collaborate So if you have E3 plan, external will be able to use and view those enterprise features view/edit docs in browser, use their own office to interact with content hosted in SP online but are not eligible for licences to tenancy proplus s/w perform tasks on site with their permission level view other site content, ie navigating to subsites to which they have been invited and feeds CAN'T - create personal sites, edit their profiles, view company feed, add storage, search "everything", access site mailbox, use eDiscover, access Power BI features, use sp data connection librarys, open docs protected by azure rm, use excel services features like calculated measures, use visio services

Manual Deployment

user to access the installation files from the Office 365 portal 1. Sign in to the computer with a user account that is a member of the local administrators group. 2. Open a web browser and sign in to the Office 365 portal at https://portal.office.com. 3. On the Office 365 Home page, click Install Now. 4. On the Do You Want To Run Or Save dialog box, click Run. 5. On the User Account Control dialog box, verify that the Program name is set to Microsoft Office Click-to-Run, and then click Yes. 6. On the Welcome To Your New Office page, click Next. On the First Things First page, select Use Recommended Settings and then click Accept. 8. On the Meet OneDrive page, click Next. 9. On the How Would You Like Your Office To Look page, select thetheme to be used with Office 365 ProPlus. 10. On the Take A Look At What's New page, click No Thanks. 11. On the You're Good To Go page, click All Done.

Office for Mac

users with computers running the Mac OS X operating system can obtain Office for Mac 2011 (only 2016 NOW) from the Office 365 portal and activate the program using their Office 365 credentials Office for Mac 2011 includes Word, PowerPoint, Excel, and Outlook. Activating Office 2011 (only 2016 NOW)for Mac with the Office 365 user credentials consumes one of the five available license

Restore Site Collection

when you delete it is moved to recycle bin for 30 days View sites in recycle bin Admin - SharePoint Site Collections Recycle Bin - shows list and number of days you can restore if it hasn't been more than 30 days and resource and storage quotas have not been exceeded site collection url's must be unique so you can't have active one with one named same in recycle bin Select site in recycle bin - click restore deleted items - Restore

Office Deployment Tool

■■ Generate a Click-to-Run for Office 365 installation source This allows administrators to create a local installation source for Office 365 rather than requiring that the files be downloaded for each client from the Internet. ■■ Generate Click-to-Run for Office 365 clients This allows administrators to configure how Office 365 ProPlus is installed. For example, blocking the installation of PowerPoint. ■■ Creating an App-V package Allows administrators to configure Office 365 ProPlus to work with application virtualization

Configuration.xml

■■ Language ID - which lang packs are installed ■■ Logging - allow you to disable/enable logging and path ■■ Product ID: O365ProPlusRetail Office 365 ProPlus VisioProRetail Visio Pro ProjectProRetail Project Professional SPDRetail SharePoint Designer ■■ Remove - if set to all=true all click-to-run removed ■■ Updates - how updates are managed enabled - when true, will check for updates updatePath - if not set, updates will be retrieved form MS servers on net. If set, can be network, local, http path targetversion - allows you to have updates applied to specific office build versions. if not specified, recent version is updated deadline - specifies when updates must be applied. can use with target version to do specific version by specific date. Deadline only applies to single set of updates. Review deadline when new updates are available

Office Telemetry provides similar functionality to the following Office 2010 compatibility tools:

■■ Office Migration Planning Manager ■■ Office Code Compatibility Inspector ■■ Office Environment Assessment Tool

Start Telemetry Dashboard

■■ On computers running Windows 7, Windows Server 2008, or Windows Server 2008 R2, click Telemetry Dashboard for Office 2013 in the Office 2013 Tools folder under Microsoft Office 2013. ■■ On computers running Windows 8 or Windows 8.1, type Telemetry Dashboard on the Start Screen. ■■ On computers running Windows Server 2012 or Windows Server 2012 R2, open the Search charm from the Start menu and type "Telemetry Dashboard for Office 2013,

Telemetry Dashboard details

■■ Overview worksheet - how docs and solutions are functioning on monitored computers - high-level view of solution and stability ■■ Documents worksheet - list of docs collected by agent scans and telemetry docs - info about commonly used docs in org ■■ Document details worksheet - Available through the documents worksheet, allows you to see which users are accessing a document ■■ Document issues worksheet Available through the documents worksheet, allows you to learn about unique events related to a specific document, such as if the document was open during an application crash. ■■ Document sessions worksheet - Available through the documents worksheet, shows session information during which issues occurred including data, user name, computer name, and domain information. ■■ Solutions worksheet - info about solutions collected by telemetry log and agent scans - include com add-ins, application specific add-ins and apps for office ■■ Solution details worksheet Available through the solutions worksheet, allows you to see which users are using a solution. ■■ Solution issues worksheet Available through the solutions worksheet, allows you to discover the details of unique events related to a solution. ■■ Solution sessions worksheet Available through the solutions worksheet, allows you to determine session information about events related to a solution, such as when it occurred, the user, and computer on which the event occurred.

SQL Versions to host db for Telemetry Dashboard for Office 2013

■■ SQL Server 2005 ■■ SQL Server 2005 Express Edition ■■ SQL Server 2008 ■■ SQL Server 2008 Express Edition ■■ SQL Server 2008 R2 ■■ SQL Server 2008 R2 Express Edition ■■ SQL Server 2012 ■■ SQL Server 2012 Express ■■ SQL Server 2014 ■■ SQL Server 2014 Express The Telemetry Dashboard for Office 2013 contains links from which you can download SQLServer Express.

Configuration.xml

■■ SourcePath - location where the Click-to-Run files will be stored When you run the tool in configure mode, the SourcePath attribute determines the installation source. ■■ OfficeClientEdition - must be set to 32 or 64. determines whether the x86 or x64 version of Office applications are retrieved or installed ■■ Version - most recent version of files will be either downloaded or installed if not set. if set that version used ■■ Display - what users sees during deployment level - none: no UI shown level - FULL: normal click-to-run UI, app splash, error boxes AcceptEULA=True: user does not see sw licence term box AcceptEULA=False: user see sw licence term box ■■ ExcludeApp Access Excel Groove (used for OneDrive for Business) InfoPath Lync (used for Skype for Business) OneNote Outlook PowerPoint Project Publisher SharePoint Designer Visio Word

Telemetry Dashboard details cont'd

■■ Telemetry Processor worksheet Provides information about the health of the Office Telemetry infrastructure ■■ Agents worksheet Provides information about the users who have computers forwarding data to the Telemetry Processor. ■■ Deployments worksheet Provides information about the number of Office clients deployed in the organization. ■■ Custom report worksheet Creates relationships based on data in the database in a pivot table.

Premium features include for mobile

■■ The ability to track changes, change page orientation, insert chart elements, and add WordArt and picture effects in the Word app. ■■ Use Pivot Tables, add and modify chart elements in the Excel app. ■■ Use Presenter View with speaker notes, perform audio and video edits, and use picture styles in the PowerPoint app. ■■ Technical support options from Microsoft.

Office Deployment Tool is a command line utility that provides administrators with three general options:

■■ The download mode allows administrators to download the Click-to-Run installation source for Office 365 ProPlus as well as language pack files to a central on-premises location. ■■ The configure mode allows for the configuration and installation of Click-to-Run Office products and language packs. ■■ The packager mode allows for the creation of an App-V package from downloaded Click-to-Run installation files.

Telemetry Agent is supported on the following 32-bit and 64-bit versions of Windows

■■ Windows 8.1 ■■ Windows 8 ■■ Windows 7 ■■ Windows Vista with Service Pack 2 ■■ Windows XP with Service Pack 3 ■■ Windows Server 2012 R2 ■■ Windows Server 2012 ■■ Windows Server 208 R2 ■■ Windows Server 2008 ■■ Windows Server 2003 While the Telemetry Agent is likely to be supported on Windows 10 and Windows Server 2016 when those products are released, it is important to remember that the separate Telemetry Agent software is only required if versions of Office prior to Office 2013 and Office ProPlus are in use.

MS recommends these OS to Host Telemetry Process Role

■■ Windows Server 2008 ■■ Windows Server 2008 R2 ■■ Windows Server 2012 ■■ Windows Server 2012 R2 Windows Server 2016