:::: MENU ::::

Specific application From specific Collection ID

SELECT DISTINCT c.Name0 AS [Machine Name] , a.DisplayName0 AS [software name], a.Version0 AS [Version], dbo.v_FullCollectionMembership.CollectionID
FROM dbo.v_Add_Remove_Programs AS a INNER JOIN
dbo.v_R_System AS c ON a.ResourceID = c.ResourceID INNER JOIN
dbo.v_FullCollectionMembership ON c.ResourceID = dbo.v_FullCollectionMembership.ResourceID
WHERE (a.DisplayName0 LIKE ‘JAVA%’) AND (dbo.v_FullCollectionMembership.CollectionID IN (‘XXXXX’))


Basic USMT Understanding with example of windows 7 to Windows 10 user profile migration

USMT is one of the Tool from ADK (Windows Assessment and Deployment Kit )

 

ADK_JPEG


 

 

User State Migration Tool (USMT) is a  tool that can be used to migrate user state, data and settings as part of a image build or outside of image.  It will process to transfer mapped drives,  favorites, and other settings listed below to a separate computer in hopes that it would help with machine refreshes and replacements.

 

With this USMT tool we are able to copy and restore the following:

  • Custom Map drives
  • STARTMENU configuration
  • QUICK LAUNCH settings
  • DESKTOP settings
  • Printers
  • User Accounts
  • PERSONAL
  • MYPICTURES
  • FAVORITES
  • MYVIDEO
  • MYMUSIC

Files with the following extensions:we can do customization if we want

  • .qdf, .qsd, .qel, .qph, .doc*, .dot*, .rtf, .mcw, .wps, .scd, .wri, .wpd, .xl*, .csv, .iqy, .dqy, .oqy, .rqy, .wk*, .wq1, .slk, .dif, .ppt*, .pps*, .pot*, .sh3, .ch3, .pre, .ppa, .txt, .pst, .one*, .vl*, .vsd, .mpp, .or6, .accdb, .mdb, .pub

Limitation of USMT ,Which it wont migrate following things :—

  • Files tagged with both the hidden and system attributes.
  • Files and folders on removable drives,
  • Data from the %WINDIR%, %PROGRAMFILES%, %PROGRAMDATA% folders.
  • ACLS for files in folders outside the user profile.
  • Local attached printers won’t migrate

How USMT will work :

USMT will work based on XML Files. USMT Package will have XML Files.Like MigApp.XML , MigUser.XML , MigDocs.XML , Config.xml etc. Each and every XML file has specific components to migrate.  If you want to read the XML file user the XML Editor for easy to understand.

I haven’t tried but you can also use the USMT GUI editor check out this .

so if you want to customize the XML file always better to create new XML file rather than editing the default XML file

in my example I’m attaching my XML file.

My requirement is user profile only requires to  restore .below are the points in detailed

  1. it should not restore any documents under C:\Drive (or any other folders under C drive).
  2. User desktop documents and user profile settings,shortcuts,Pin items,desktop wallpaper , favorites  , My pictures,my documents,etc
  3. Also under C:\temp\Printer\any files it should restore

download sample  XML files  it has my sample custom files Custom2.xml and Migration.xml  you needs to call at  Capture User Files and Settings in Task sequence and Restore User State

 

 


 

Sample SCCM Task Sequence :–

Assuming you already have the USMT package in place in SCCM console

Here Profile Capturing /Storing will be in 2 Ways

  • SMP (State Migration Point) : Its a role from SCCM. its kind of share location where we can use for profile storage

Advantages /Disadvantages : —

  1.   We should have enough space to store the user data . If your concern about space check out this to get some idea how much space you may requires Collecting USMT Estimates using ConfigMgr
  2.  With SMP It has it own mechanism for deleting the aged data or maintenance task
  3.  Also data will be encrypted and we can’t able to see the files. It will be stored in .MIG format
  4.  It will slow process to compare to Hard-Link process . Since data will be stored in remote location. Speed of the process will depends on the bandwidth
  • Local store / Wipe Mode (Hard-link migration) – It will create Links in the  Sectors of inside the Hard disk  and It will Wipe the HardDrive. When It restore calls.

Advantages /Disadvantages : —

  1. By using the linking mechanism from sectors it will restore the user data – So here We can’t  format 100% of the hard drive
  2. Since data will be stored under local hard drive.it will be faster to compare to SMP

 

 

Summary  of steps need to perform to migrate the StandAlone user profile [SMP]. :—

SCOPE :User  profile migration from Windows7 to Windows 10/other machine as your wish

  1. USMT Package should be ready with above Xml Files. Paste above XMl files under USMT folders
  2.  SMP Role should be in place
  3.  relate the old and new computers in Computer Association as shown 
  4. create a task sequence for capture in above case Task sequence 1
  5. create a task sequence for restore in above case Task sequence 2
  6. Create a Collection  called ” Capture ” and add the machine windows 7
  7. Deploy the Task sequence 1 on ” Capture “Collection. Make sure it should get success
  8. Create a Collection  called ” Restore ” and add the machine windows 10
  9. Deploy the Task sequence 2 on  ” Restore ”  Collection. Make sure it should get success

Above steps will explain in details in below :—

I have 2 machines windows 7 and Windows 10 / Or any other version windows7/8.1 etc

Now I want to transfer my user profile data from Windows7 machine to windows 10 machine

 

For this, we need 2 Task sequences  with below steps and  Computer Association

 

First we need to co-relate the machine relation with help of Computer Association.

computer association 1.

computer association 2

 

Here you can add specific user or all user etc settings

computer association 3

 

computer association 4

 

1 Task sequence — > For user profile Capturing – Here “Capture USMT “ Task Sequence Set will be use full as showing in below screenshots. This  Task sequence we will be run on Windows 7 machine

2. Task Sequence –>  To restore user profile.Here “Restore” Task Sequence Set will be use full as showing in below screenshots. This  Task sequence we will be run on Windows 10 machine

 


 

Task sequence 1 : ScanState [ For Capturing the User profile settings]

SCANSTATE1

SCANSTATE2

ScanState3

 

Task sequence 2 : LoadState [ For Restoring the User profile settings]

 

LoadState1

 

LoadState2

 


 

TrobleShooting Steps  and Logs info :—

  • You may face the issues in either capturing or Restoring stage which are related to USMT
  • At the time of running the task sequence it create a Folder “C:\_SMSTaskSequence” and download the USMT Package inside it and also it will create the folder “SMSTSLog”under C:\Windows\CCM\Logs\SMSTSLog
  • SMSTSLog folder contains the log at the time of running the task sequence .once task sequence completes it will move the logs to under CCM folder C:\Windows\CCM\Logs

For  capturing the user data below logs will help you

  1. SMSTS.log : General Task sequence execution info
  2. scanstate.log –  scans all user profiles and what files its scanned according to the XML defined
  3. scanstateprogress.log :  How much Percentage it completes

capturelog

For  restoring the user data below logs will help you

  1. SMSTS.log : General Task sequence execution info
  2. loadstate.log-  Loads all user profiles and what files it should restore according to the XML
  3. loadstateprogress.log :  How much Percentage it restored s it will shows

LoadStateLog1


 

Known Issues: —

 



 

  1. If you’re running multiple time on same machine irrespective of result . so might get certificate error.
  2. certificate error
  3.  Just delete the certificates from the  locations [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SystemCertificates\SMS\Certificates] It will resolve the issue 
  4. certificate

 



 

Failed to decrypt state encryption key

CA

sometime at the time creating the computer association it got sucked , hanged. Please remove it and recreate the computer association will fix above error

 

 



Most of the cases USMT will failed due to Invalid User Mapping or duplicate SID issue on Source machine while capturing.

This issue will occur due to domain migration when they are migrating the user profile with ADMT (Active Directory Migration Tool) They won’t delete the old domain SID’s

check out for more info http://networksteve.com/?p=5022

Please find the script which it will remove the Specified SID user profile SIDREMOVAL.vbs .It will takes the Registry back and removes the user profile if the user profile has duplicate SID.

 


List of Users to add in a SCCM User Collection

 

select SMS_R_USER.ResourceID,SMS_R_USER.ResourceType,SMS_R_USER.Name,SMS_R_USER.UniqueUserName,SMS_R_USER.WindowsNTDomain from SMS_R_User where SMS_R_User.UserName in (‘User1′,’User2’)



Software Updates Installed using SCCM or Manually

SELECT  sys.Name0,ui.BulletinID, ui.ArticleID,ui.Title,

CASE when (ucs.Status=2 and ui.IsDeployed=0 )then ‘Required_General’

when (ucs.Status=2 and ui.IsDeployed=1 )then ‘Required_ITICSDeploy’

WHEN (UCS.Status=3 and ui.IsDeployed=1 ) then ‘Installed_SCCM’

WHEN (UCS.Status=3 and ui.IsDeployed=0 ) then ‘Installed_Manual’

when UCS.Status=0 then ‘Unknown’  end as ‘Status’, case WHEN ui.severity=10 THEN ‘Critical’

WHEN ui.severity=8 THEN ‘Important’

WHEN ui.severity=6 THEN ‘Moderate’

WHEN ui.severity=2 THEN ‘Low’ WHEN ui.severity=0 THEN ‘AddOn’ end as ‘Severity’

FROM v_R_System sys

INNER JOIN v_UpdateComplianceStatus UCS ON   sys.ResourceID = ucs.ResourceID

INNER JOIN v_UpdateInfo UI ON   UCS.CI_ID = UI.CI_ID

WHERE –UI.IsDeployed=1 and

sys.Netbios_Name0=’computer1′

ORDER BY Status

 


Pull Distribution Points with Source Distribution Points SQL Query

SELECT DISTINCT
dbo.v_DistributionPoints.ServerName AS [Source DP for Pull], dbo.v_DistributionPoints.IsPeerDP, dbo.v_DistributionPoints.IsPullDP,
dbo.vPullDPFullMap.PullDPNALPath AS [All Types of DP List], dbo.v_DistributionPoints.IsPXE, dbo.v_DistributionPoints.Description
FROM dbo.vPullDPFullMap INNER JOIN
dbo.v_DistributionPoints ON dbo.vPullDPFullMap.SourceDPNALPath = dbo.v_DistributionPoints.NALPath


//////////******* List of Views /Tables with fields**********////////////

////////////////****************************** List of Tables with fields************************///////////////////////////

SELECT T.NAME AS [TABLE NAME], C.NAME AS [COLUMN NAME], P.NAME AS [DATA TYPE], P.MAX_LENGTH AS[SIZE], CAST(P.PRECISION AS VARCHAR) +’/’+ CAST(P.SCALE AS VARCHAR) AS [PRECISION/SCALE] FROM SYS.OBJECTS AS T JOIN SYS.COLUMNS AS C ON T.OBJECT_ID=C.OBJECT_ID JOIN SYS.TYPES AS P ON C.SYSTEM_TYPE_ID=P.SYSTEM_TYPE_ID WHERE T.TYPE_DESC=’USER_TABLE’;

 

////////////////****************************** List of Views with fields************************///////////////////////////

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE, DATETIME_PRECISION FROM INFORMATION_SCHEMA.COLUMNS


RDP Enable using PSEXEC

psexec \\XXXXXXXXXX reg add “hklm\system\currentcontrolset\control\terminal server” /f /v fDenyTSConnections /t REG_DWORD /d 0