Fix The Blue Screen Of Death On Your Pc

• Follow the Directions for WinRM to letter.  I tried set the policy in the domain group policy and the installer looks in the local policy, so I had to set it in both places.  I also tried to limit the trusted hosts with , *.mydomain.local instead of just using * and it didnt like what I entered, so I just went back to * and it worked.
• Make sure you create a folder for every prerequisite and only download the files you need.  For most of us that will be just the x64 files.  Some files have the same name in both the x86 and x64 packages and you could end up expanding the x86 files over your x64 files and then the install will fail or hang.
• Expand all your prerequisites.  When I downloaded all the prerequisites, I didnt expand them.  It will not let you choose the folder where your prerequisites are stored until you do this.  All of the SQL Server CU4 hotfixes will need to be expanded and the one that is 333mb will need to be expanded a second time.  For the most part if you downloaded an ISO or EXE, you will need to expand it.
• Check your firewall on the installer PC.  My installer PC had a Symantec Firewall that was hanging up my installation.  I removed that firewall and turn the windows one off until I was done.
• Remote Desktop can crash your Unified installer.  Every time I used remote desktop to check the install progress from home it would crash the installer. I found that I stay connected the whole time that it will be fine, but if I disconnect and then re-connect later it will kill the installer.
• If all else fails, try manually installing the prerequisites and look for problems.  My SCCM 2012 install kept hanging up after the installation of SQL Server 2008 R2.  When I would manually run the SP1 installer it would give me an error and then fixsqlregistrykey would crash.  I had installed .NET 4.0 in advance and fixsqlregistrykey didnt like it for some reason, so removing .NET Framework 4.0 Client Profile and Microsoft .NET Framework 4 Extended seem to fix that problem.
• Make sure your prereqs were not corrupted when they were copied to the server. While using remote desktop at some point it crashed the installer and it must have interrupted the transfer of the .NET Framework 4.0 exe to the server, because when I tried to run it manually, it failed to run.  Manually copying the exe to the sever resolved that problem.

sc config WinRM start= delayed-auto 
net start WinRM
winrm create winrm/config/listener
Address=*+Transport=HTTP
netsh firewall add portopening TCP 80 "Windows Remote Management" 

• Use the Virtual Machine Manager Configuration Analyzer (VMMCA)
• Verify the VMM service account is a member of the local administrators group on the host
• Check for corrupted performance counters
• Check the Svchost.exe process of the Windows Remote Management service

• Increase the default values for WinRM (Shown in this code sample)

winrm set winrm/config @{MaxTimeoutms = "1800000"}
winrm set winrm/config/Service @{MaxConcurrentOperationsPerUser="400"}
net stop winrm 
Y
net start winrm 
net start scvmmagent

setspn -A SCVMM/yourmachine -U domainaccount
setspn -A SCVMM/yourmachine.fqdn.com -U domainaccount 

• Use setspn.exe to create SPN for vmmserver using following command "C:Windowssystem32setspn.exe  -S SCVMM/hostname.domain accoutname"
• Add SPN values to following registry key "SoftwareMicrosoftMicrosoft System Center Virtual Machine Manager ServerSetupVmmServicePrincipalNames"
• Run "C:Program FilesMicrosoft System Center 2012Virtual Machine ManagersetupConfigureSCPTool.exe -install" to configure SCP.

SELECT     CUSTOMER_ID, ID, CUSTOMER_PO_REF
FROM         CUSTOMER_ORDER
WHERE     (ID = 200150960)

select  CUST_ORDER_ID from CUST_ORDER_LINE where CUST_ORDER_ID=200150960

SELECT QUOTE_ID FROM QUOTE_ORDER WHERE CUST_ORDER_ID = 200150960

Use SFC to get the Work Order Number:
------------------------------------------

SELECT     SUPPLY_BASE_ID, DEMAND_BASE_ID
FROM         DEMAND_SUPPLY_LINK
WHERE     (DEMAND_BASE_ID = 200150960)


Now find the Operation Status
---------------------------------
SELECT OPERATION_SEQ_NO,  RESOURCE_ID
FROM LABOR_TICKET
WHERE WORKORDER_TYPE = W AND WORKORDER_BASE_ID = 746952 AND WORKORDER_LOT_ID = 1

What is the work order Status, and ship date if its already gone?
----------------------------------------------
SELECT     STATUS, close_date
FROM         WORK_ORDER
WHERE     BASE_ID = 789635


Combine WO and Status
------------------------
SELECT DEMAND_SUPPLY_LINK.DEMAND_BASE_ID AS [Customer Order], DEMAND_SUPPLY_LINK.SUPPLY_BASE_ID AS [Work Order], 
WORK_ORDER.STATUS AS [WO Status], WORK_ORDER.CLOSE_DATE AS [Close Date]
FROM WORK_ORDER INNER JOIN
DEMAND_SUPPLY_LINK ON WORK_ORDER.BASE_ID = DEMAND_SUPPLY_LINK.SUPPLY_BASE_ID
WHERE DEMAND_SUPPLY_LINK.DEMAND_BASE_ID = 200150960



Find the complete list of operations
--------------------------------------
SELECT SEQUENCE_NO, RESOURCE_ID
FROM OPERATION 
WHERE (WORKORDER_BASE_ID = 790939)
ORDER BY SEQUENCE_NO

Find just the completed operations by seqence number
-----------------------------------------------------
SELECT OPERATION_SEQ_NO
FROM LABOR_TICKET
WHERE WORKORDER_TYPE = W AND WORKORDER_BASE_ID = 790939 AND WORKORDER_LOT_ID = 1

• The speed I was getting with 5 full bars was about 6mb down and 1mb up.
• I never got the “Professional Class Support” they list under Office Pro Internet
• They always told me they would email me information when I signed up and I never got anything.  Later I found that it all went to my clear.com email box (They use Google’s Gmail)

 (get-credential).password|convertFrom-SecureString|set-content c:cred.txt  

 $pass = get-content C:cred.txt | convertto-securestring
  
 $cred = new-object -typename System.Management.Automation.PSCredential -argumentlist "superadmin@yourcompany.onmicrosoft.com",$pass
  
 $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell -Credential $cred -Authentication:Basic -AllowRedirection
  
 Import-PSSession $Session | Out-String
  
 Connect-MsolService -Credential $cred | Out-String
  
 echo "Last Dir Sync Completed at:"
  
 $DATEutc = Get-MSOLCompanyInformation | select -expand LastDir* 
  
 $DATEutc.ToLocalTime()