Administrative Templates are responsible to facilitate the management of registry based policies that allows to configure many settings on Windows machine. With the availability of these Administrative Templates in Intune for Windows 10 it is helping Administrators to easily manage applications on Windows 10 or later devices using device configuration profiles. Profiles in Intune lets you configure settings and then push them to the devices in an Organization. In this article, we will see how to configure an Administrative Template for OneDrive so that the settings are pushed to the enrolled devices and provide below features. Silently Sign in users to the OneDrive Sync client. Silently move Windows known folder to OneDrive Set File on-Demand states. Pre-Requisites: Devices must be Joined to Azure AD. If you have on-premises environment that uses AD, you can enable Hybrid AD Join. Step 1: Login to Microsoft Endpoint Manager Admin Center (endpoint.microsoft.com). Under Devices, go to Configuration Profiles and then click Create Profile.  Select Windows 10 and later as Platform  and Profile will be Administrative Template. Click Create.  Enter a Name for the Profile and optionally a Description. Click Next.   Under Computer Configuration, select OneDrive and then select the settings you want to configure.   In our instance, we will configure the first setting which is Silently signed-in users on to the OneDrive Sync client. Second setting is to silently move the windows known folders to OneDrive. In this case the known folders which is Documents, Desktop and Pictures will be automatically get synced with the OneDrive. Note: Some configuration required Tenant ID which you get from portal.azure.com >  Azure Active Directory. Third setting is to Use files on-demand. Files on-demand allows you to access all your files stored in the cloud using File Explorer without having to sync them directly and storage space on your device. Similarly, there are various other setting which can be configured. Step 2: Once the settings are configured, click Next and go to Assignments. Under Assignments, you need to select a Group, if you want to assign this profile to a specific set of people. You may also choose All users or All Devices.  Once selected, click Next, Review and create the Profile. With the help of these Administrative Templates, Administrators can easily manage the Applications and push the settings to all the Users and Devices.

Your Organization might have a requirement to change the Microsoft Teams recording storage mode from Stream to OneDrive for Business and it has some advantages as well. You have had tried working on sharing and permission on Microsoft Streams and it is not much effective so why not use our OneDrive for Business and we can easily set permissions on the recordings. Currently there is no option to share the recording to external users from MS Stream in this case OneDrive for Business helps additionally you can provide shared links as well. This recording option is a setting that is available at Teams policy level and in this article, we will see how to achieve that. Pre-requisites: You need to have the Teams PowerShell Module installed. Microsoft 365 license is required which includes OneDrive for Business. Installing Teams PowerShell module: Open Windows PowerShell as an Administrator. Enter the command “Install-Module MicrosoftTeams”. Install the Skype for Business Online Connector: Skype for Business Online Connector is currently a part of Teams PowerShell Module. Enter below commands“Import-Module -Name MicrosoftTeams”“$userCredential = Get-Credential” – Enter Admin Credentials.“$sfbSession = New-CsOnlineSession -Credential $userCredential”“Import-PSSession $sfbSession” Set Teams Meeting Policy to transition from the Stream storage to OneDrive for Business or SharePoint. Once you are connected to SfB Connector using the above steps, you can use the below command to set the transition.“Set-CsTeamsMeetingPolicy -Identity Global -RecordingStorageMode “OneDriveForBusiness“ To check if the setting successfully applied, get the Teams Policy Settings using the below command and the “Recording Storage Mode” status, it should be OneDrive for Business.“Get-CsTeamsMeetingPolicy”. You might think that it will take huge storage and OneDrive for Business only has 1 TB of storage, in that case I recommend increasing the storage for OneDrive for Business. You can increase your OneDrive for Business storage to up to 5TB. Please refer this blog for more information – https://www.cloudfronts.in/how-to-increase-onedrive-for-business-storage-up-to-5tb/ Where will the recordings get stored? For non-Channel meetings, the recording will get stored in OneDrive for Business under a folder named “Recording”. This OneDrive will be of the person who started the meeting. For Channel meetings, the recording will get stored in the Team Site document library in SharePoint Online in a folder names Recording.

Your Organization might have this requirement to publish Win32 Application with Microsoft Intune. You might think if it is even possible to deploy the Windows 10 store Apps, MSI files or .exe file. Yes, it is possible to deploy these apps through Microsoft Intune. The only hurdle is you will not be able to publish the .exe files directly. You need to either convert the .exe file to MSI package or you can convert the same to an. INTUNEWIN file. In this article we will discuss how to create an INTUNEWIN file from an .exe file. Step 1: Create 3 folder on your device. Here I am creating the below 3 folders in C:\ C:\Adobe: Since I am generating INTUNEWIN file for Adobe, I have created a folder with Adobe name. You will need to place the source files here which is required for installation. C:\IntuneApps: This folder is for the Output file which will be generated and then we can use this file to deploy on Microsoft Intune. C:\IntuneWinAppUtil: This folder is for the tool which we will be using for converting the file to INTUNEWIN. This tool is Intune Win 32 Prep Tool. Step 2: Put the file in the respective folder. Here we will gather the Source file and the Intune Win 32 Prep Tool and will put it in the respective folder. We can get the Intune Win 32 prep Tool from here –https://github.com/microsoft/Microsoft-Win32-Content-Prep-Tool/blob/master/IntuneWinAppUtil.exe Download this file and put it in the C:\IntuneWinAppUtil. Now you can download your source file, in my case I have downloaded .exe file for Adobe and put it into C:\Adobe. Step 3: Create the IntuneWin file. Open Windows PowerShell as an Administrator and navigate to the folder where we have kept the Intune Win32 Prep Tool. Once you run the IntuneWinAppUtil.exe, you will be asked to provide the below details. Please specify the source folder: Enter the source folder where you have the .exe file. Please specify the setup file: You will need to specify the name of the .exe file. Please specify the Output folder: Enter the folder where your Output file will get generated. After that press Enter. INTUNEWIN file will be created within seconds and you see something like this. Now you can go to the Output folder and check whether the file is generating over there. This is how we can generate INTUNEWIN file and can publish the App on Microsoft Intune.

Suppose you are sharing a confidential file externally, of course, you will not want the external user to edit the file or download it or share it again with others. In this article, we are going to see how we can achieve that. This is applicable to both OneDrive for Business Online as well as with the app (OneDrive files synced on your system). OneDrive for Business users have the option to restrict the level of access. Anyone – gives access to anyone with the link, whether received directly or forwarded. This can also include external users as well. People in your Organization – give anyone in your organization who has the link access, whether received directly or forwarded. People with Existing access – Can only be used by the people who already have access to the document. Specific People – gives access only to people you specify. This cannot be accessed if forwarded to others who don’t have access already. If you see any of these options greyed out, your admins might have restricted the options from Admin Center. Steps 1: Sharing process for the confidential files. Go to OneDrive for Business, select a file you want to share by selecting the circle, you can also pick multiple items to share them together. Select Share at the top of the page or beside the file name there is a small Share icon (See above screenshot). Select “Anyone with the link can edit” to customize the option. You can see the other options as well, now select “Specific People”, uncheck Allow Editing and toggle ON the Block download option and click Apply. Enter the email address of this user with whom you want to share this file and click Send. Steps 2: What happens when the external user receives the file. The user received the email with a file link and it is clearly indicated that this link will not work if forwarded to someone who doesn’t have access to this file already. When the user will try to open the file, it will ask for verification and users will need to click on Send Code. The code will be generated and sent to the user via email. The user will enter the code and verify it. The file will open after it is verified. Users won’t be able to edit or download the file. If this user will forward this document to another user, the other user will be asked to log in with the credentials to which the file was initially shared, hence securing the file if it gets forwarded. In this way, you can share confidential documents with external users and hence securing the data. Hope this article helps to achieve the same.

Introduction: In order to move your Pipeline from one environment to other you require your Pipeline to be saved on Github. This Blog will guide you through how to connect your Azure Data Factory Pipeline with your Github account. Step 1: Create a new Azure Data Factory and Tick the Enable GIT checkbox.     Step 2: Create a new Repository in your Github Account.     Step 3: Copy the URL from of the newly created repository from the address bar.     Step 4: Enter the GIT URL, the repository name which you recently created, branch name (usually master) and your root folder (usually same as your repository name) and click on Create.     Step 5: Now you must authorize your GIT Account on ADF. You will be promoted to Login with your Github Account. Do the necessary and click on Authorize Azure Data Factory.     Step 6: Now you must select the Working Branch. We are using the default master branch. Click Save and then you can proceed to create your Pipeline.     Conclusion: Each Time you publish the changes in ADF they are simultaneously stored in the GIT repository’s branch.

Separate versions of Word, Excel, and PowerPoint is already available on both iOS and Android. The new Office mobile app combines Word, Excel, and PowerPoint into a single app and introduces new mobile-centric features to make it your go-to productivity app on a phone. Microsoft has done a good job of combining all of the functionality from the separate Word, Excel and PowerPoint apps into a single Office app and this is surely going to replace all the separate versions. Key Benefits: Combining Word, Excel, and PowerPoint and to some extent Microsoft Office Lens to a single app making switching between the apps easy and requires less space with respect to the individual apps. Do more with your phone camera like converting images into editable Word and Excel documents, scanning pictures into PDF, Scan QR code and capturing whiteboards with digital enhancements to make content easier to read. New functionality for common tasks like making quick notes, signing PDF, converting a document to PDF and transferring files between devices. Connect your Office App with Work or School account. All productivity apps in the same and easily switch between Apps. Find all the recent documents.   4. Easily locate the document in OneDrive, SharePoint. Browse Google Drive documents, documents on your device and also you can connect other cloud storage such as Dropbox.   5. Easily search for documents through the Search bar. 6. Transfer files between devices -Open the Office App on your mobile device and open transfer.office.com on your system, pair the device by scanning the QR code and easily transfer files. 7. Share files to nearby devices quickly.   8. Other important features: Image to Text – Extract text from your image to Word document. Image to Table – Extract a table for an image to Excel document. Sign a PDF – Add your signature to a PDF file. Scan to PDF – Scan pictured to PDF. Pictures to PDF – Create PDF from the pictures stored on your system. Document to PDF – Easily convert your documents to PDF. Scan QR code – Scan QR code from within the Office App to open a document. Upcoming Features –  Word Dictation – Turn your voice into written text and use voice commands. Refer  – Word Dictation Source  – Microsoft Article Outline to PowerPoint –  Write your presentation content as a simple outline and let PowerPoint designer turn it into presentable slides with proper formatting and styling of the content. Refer – Outline to PowerPoint Source – Microsoft Article Excel Card Views – View and edit data in an Excel table row in a simple, digestible card format so you do not have span across columns that extend beyond the limits of the screen. Refer – Excel Card Views The new Office app is surely going to replace the individual apps for Word, Excel, and PPT as it makes very easier to download and install. It saves space of individual apps on the device and quickly switches the apps within the Office app. Additionally, we have seen above the features that provide the opportunity to do more with the App. Thanks!

Introduction We are performing Integration of Accounts from CRM to SQL using ADF Copy activity pipeline. We want to upsert the accounts instead of inserting duplicate records again. Step 1: Auto create the Table named “accounts” in SQL Server during the first Integration run by selecting the Auto create table option.   Step 2: Create a custom data type named “AccountType” using following query.   CREATE TYPE AccountType AS TABLE( accountid uniqueidentifier, transactioncurrencyid uniqueidentifier, address1_city nvarchar(MAX), createdon datetime2(7), accountnumber nvarchar(MAX), name nvarchar(MAX), address1_country nvarchar(MAX), address1_composite nvarchar(MAX), telephone1 nvarchar(MAX), emailaddress1 nvarchar(MAX), websiteurl nvarchar(MAX), primarycontactid uniqueidentifier ) Step 3: Create a Stored Procedure named “spUpsertAccounts”.   CREATE PROCEDURE spUpsertAccounts @account AccountType READONLY AS BEGIN   MERGE dbo.accounts AS target_sqldb USING @account AS source_tblstg ON (target_sqldb.accountid = source_tblstg.accountid) WHEN MATCHED THEN UPDATE SET accountid = source_tblstg.accountid, transactioncurrencyid = source_tblstg.transactioncurrencyid, address1_city = source_tblstg.address1_city, createdon = source_tblstg.createdon, accountnumber = source_tblstg.accountnumber, name = source_tblstg.name, address1_country = source_tblstg.address1_country, address1_composite = source_tblstg.address1_composite, telephone1 = source_tblstg.telephone1, emailaddress1 = source_tblstg.emailaddress1, websiteurl = source_tblstg.websiteurl, primarycontactid = source_tblstg.primarycontactid     WHEN NOT MATCHED THEN INSERT ( accountid, transactioncurrencyid, address1_city, createdon, accountnumber, name, address1_country, address1_composite, telephone1, emailaddress1, websiteurl, primarycontactid ) VALUES ( source_tblstg.accountid, source_tblstg.transactioncurrencyid, source_tblstg.address1_city, source_tblstg.createdon, source_tblstg.accountnumber, source_tblstg.name, source_tblstg.address1_country, source_tblstg.address1_composite, source_tblstg.telephone1, source_tblstg.emailaddress1, source_tblstg.websiteurl, source_tblstg.primarycontactid ); END Step 4: Enter the Stored Procedure Name, Table Type and Table type parameter as shown in the image below:     Step 5: Publish all the changes and debug your Pipeline.  You can Verify the results in SQL Server “accounts” table.  

You must have known that OneDrive for Business storage has a limitation of 1TB but what if you have utilized the full capacity (1TB). There is no such announcement for the same, but the limit is not 1TB. In this article, we will see how we can increase the storage capacity for OneDrive for Business up to 5TB through PowerShell. As per one of the Microsoft articles “If your organization has a qualifying Office 365 plan and 5 or more users, you can change the storage space to more than 5TB”. So as per this statement, we can get more than 5TB as well. That means the limitation is not 5TB as well. Increasing the storage from 1TB to 5TB can be done with the help of your Microsoft 365 Administrator through PowerShell, but going beyond 5TB, you will need the help of Microsoft Support with justification and then it might get increased up to 25TB quota. Pre-requisites: Download SharePoint Online Management Shell. https://www.microsoft.com/en-us/download/details.aspx?id=35588 Connect to SharePoint Online through PowerShell. $adminUPN=”<the full email address of administrator account>” $orgName=”<name of your Office 365 organization>” $userCredential = Get-Credential -UserName <the full email address of administrator account> This is prompt to enter Message, enter the admin account password and hit enter. Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential You will be prompted to provide admin credentials. Increasing the storage quota for OneDrive for Business: Check the current set quota for a user. Get-SPOSite -Identity <User’s OneDrive URL> | select $StorageQuota Note: – Storage quota is in MB. Change the storage quota for a specific user. Set-SPOSite -Identity <User’s OneDrive URL> -StorageQuota $StorageSize Note: – Replace $StorageSize with 5242880 (MB) which is 5TB To verify the change, run cmd Get-SPOSite -Identity <User’s OneDrive URL> | select $StorageQuota You can also verify the same from Office 365 Admin Center > Active Users > Select User > OneDrive.  This article will help you to increase storage quota for OneDrive for Business up to 5TB without any need of calling Microsoft Support. If you need to increase it more than 5TB then you will need to take help from Microsoft Support with justification. Thanks!

Introduction: This blog will guide you through how you can schedule your Pipeline in ADF with the help of scheduled trigger. The Time is crucial when you schedule your Pipeline. Go through all the steps to avoid the common mistake which you might make. Step 1: Click on Trigger and select “New/Edit”. Step 2: Click on “New”. Step 3: Select Type = “Scheduled”. Set the Start Date (UTC) and Time Recurrence to 1 Week(s) and Select the required Day(s). Step 4: Click on OK and Publish the changes. Step 5: The Time that you must enter here is in UTC, so convert the local time at which you want to schedule to UTC and set it accordingly. Use the following link to convert it. https://www.prokerala.com/travel/timezones/time-converter.php

Introduction: ADF has a feature to Monitor and Audit the ADF activity. These Alerts can be Fired on both success and failure of a pipeline based on how we configure it. Step 1: Go to ADF Monitory and click “New Alert Rule” to create a new alert. Step 2: Set the Alert rule name and its severity: – Sev 0 = Critical – Sev 1 = Error – Sev 2 = Warning – Sev 3 = Informational – Sev 4 = Verbose Here we will select Sev1 Step 3: Set the Alert criteria as Failed pipeline runs metrics which will trigger only when a pipeline activity fails. Step 4: Set the Alert criteria as Failed pipeline runs metrics which will trigger only when a pipeline activity fails.   Step 5: Select the Name of the Pipeline for which you want to send the alerts. Step 6: Select All the Failure Types. Step 7: Set the Alert Logic to compare the metric value with threshold calculated based on time aggregation. Set the period and frequency based on which the above time aggregation in alert logic condition works. For now, keep these options as default and click on Add Criteria. Note: Only two criteria can be added. Check the Next Part 2 of this Blog at :