Windows Autopilot Setup Guide

This post is a step-by-step Windows Autopilot setup guide. Especially this guide should be helpful if you are new to Intune.

In this post I will make sure to cover the Windows Autopilot prerequisites, and step-by step process, and End User experience.

SQL Query - Get OS Edition, Version and Build number details in SCCM Database

Query:

--Windows Versions details
Select distinct SYS.Netbios_Name0 as HostName, OPSYS.Caption0 as "OS Edition", WSLN.Value as "OS Version", OPSYS.Version0 as "Version No", v_GS_OPERATING_SYSTEM.BuildNumber0 as 'Build Number', OPSYS.CSDVersion0 as "Service Pack"
from v_R_System SYS
join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID 
JOIN v_FullCollectionMembership FCM on sys.ResourceID = FCM.ResourceID inner join v_gs_operating_system
on SYS.ResourceID=v_GS_OPERATING_SYSTEM.ResourceID
join fn_GetWindowsServicingStates() WSS
on WSS.Build = OPSYS.Version0 and WSS.Branch = SYS.OSBranch01
Join fn_GetWindowsServicingLocalizedNames() WSLN
On WSS.Name = WSLN.Name
--WHERE FCM.CollectionID = 'CMH00015'
order by SYS.Netbios_Name0

Read Only And Attachment Download Restrictions (Exchange Online and OneDrive and SharePoint)

Both SharePoint Online (including OneDrive for Business) and Exchange Online allow a read only mode to be implemented. When this is enabled documents can be viewed in the browser only and not downloaded.

Create a new OwaMailboxPolicy and set the ConditionalAccessPolicy setting. Once that is done you may apply the same policy to the selected users. 

SQL Query - Get Application information from SCCM database

Query:

Select
Pac.PackageID as 'App_ID',
col.CollectionID as 'AppCollection_ID',
Vaa.ApplicationName as 'ApplicationName',
Ds.CollectionName as 'CollectionName',
CASE when col.CollectionType = 1 Then 'User' when col.CollectionType = 2 Then 'Device' Else 'Others' End as 'CollType',
CASE when Vaa.DesiredConfigType = 1 Then 'Install' when vaa.DesiredConfigType = 2 Then 'Uninstall’' Else 'Others' End as 'DeploymentType',
CASE when Ds.DeploymentIntent = 1 Then 'Required' when Ds.DeploymentIntent = 2 
Then 'Available' when Ds.DeploymentIntent = 3 Then 'Simulate' End as 'Purpose',
Ds.DeploymentTime as 'AvailableTime',
Ds.EnforcementDeadline as 'RequiredTime',
Vaa.CreationTime as 'CreatedOn',
Vaa.LastModificationTime as 'LastModifiedOn',
Vaa.LastModifiedBy as 'LastModifiedBy'
from v_DeploymentSummary Ds
left join v_ApplicationAssignment Vaa on Ds.AssignmentID = Vaa.AssignmentID
left join v_Package Pac on Vaa.ApplicationName = Pac.Name
left join v_collection col on Ds.CollectionName = col.Name
Where Ds.FeatureType = 1
order by Ds.DeploymentTime desc

SQL Query - Get Custom Inventory report from SCCM Database

You can use the below query to pull up custom inventory details, including device name, model, serial number, processor name, no of processors, no of sockets, total memory, hardik size, and free space.