Intune lets you manage the devices and apps on how they access your company’s data and to us this MDM the devices must first need to be enrolled in the Intune service so that an MDM certificate is issued which is then used to communicate with Intune service. In this blog, we will see the end-user process on how to enroll the devices with Intune. Pre-requisites: Intune must have been set up with MDM enabled. Setup an App Protection Policy in Intune. Microsoft Intune or Microsoft 365 E3 and above license are required to setup Intune. Once the Android App Policy is assigned to all the users, there will be some restrictions (as per your Org. requirements) and without enrolling the devices, users won’t be able to access corporate data. To enroll the mobile devices with Intune, please follow the below screenshots. When you try to access any Microsoft App, like Outlook, Teams, etc. you will be asked to install the Microsoft Intune Company Portal App. Click on “Go to Store”. You will redirected to Google Playstore to install Company Portal App. Install the Application and then Click on Sign In with the Work Account. After you Sign, you will see the list of all the devices. Unmanaged devices will be highlighted as shown in the screenshot below. Click on the mobile device, you are tyring to enrol. The devices will be shown as Unmanaged. Click on “This device is unmanaged”. You will be asked to setup the device through 3 stage starting from creating a Work profile. Click on Begin. Provide the App permission by clicking on Continue. It will then Set up your work profile. Click on  Accept and Continue. Click on Continue once the Work Profile setup is completed. It will then Activate the work profile and will also update device settings. Click on Done. You device is now enroled and ready to access the corporate data.

Many of us who are using SharePoint Online for Document Management as using the manual method for syncing the Document Libraries on our devices. Here we can leverage Intune Administrative Template. Administrative Templates are responsible to facilitate the management of registry-based policies that allows configuring 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 silently sync SharePoint Online Document Libraries via Intune Administrative Template. Pre-Requisites: Devices must be Joined to Azure AD. If you have on-premises environment that uses AD, you can enable Hybrid AD Join. Enabling the Sync: 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, search for team site and then select ‘configure team site libraries to sync automatically’. Get Library ID from SharePoint Online Document Library, the instructions to get the ID will be given in the setting itself. Once the library ID is copied, go to the setting, and click Enable. You will also need to provide the Library Name and the Library ID which you copied. 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 specific set of people. You may also choose All users or All Devices. Once selected, click Next, Review, and create the Profile.

If you want to keep track of the Commits of any Critical Project and want to discuss with your Project Team Member regarding commits made on TFS. We can create a flow that will post the Commit details of that Critical Project on your Project Channel. Step 1: Create a Team and a channel to post the Checked-in Details. Here I have created a Team with the name “Project Team” and a separate channel “Azure DevOps” to post all the messages related to Development and DevOps. Step 2: Create a Cloud flow to post Message when someone commits any changes in Azure DevOps (TFS) Search for Azure and select the triggering condition as “When code is checked in (TFVC)” Configure the Triggering block with Project for which you want to post a message to MS Team. If you want to track the commits of any specific user then you can set a user in Team Member otherwise it will post a message for all checked-in commits made by all Project Members present in Member. Now, we will add Post a message (v3) block in Cloud flow. Make sure that you should select the right channel while configuring the post message block, after configuring your block it should look like the below screenshot: Save the Cloud flow and Test it by making commits from your Visual Studio or Azure DevOps from the browser. Testing. Here, I will make commit using Visual Studio: Result

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.com/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.