:::: MENU ::::

SCCM Different types of Views

 

SCCM Different types of Views :—(In one line )

V_*                 — > By default view(EX:-V_add_remove)

V_R_  *          — > It will fill the values with Discovery data

V_RA_  *      — > It will, fill the values Once Discovered and Assigned

V_GS_*         —-> HINV/SINV/Software Granular data- Present/Current inv data

V_HS_*         —-> Historical data-After 90 days Task mainenance data HINV/SINV/Software Historical data

V_AI_*         —-> Asset Intelligence related

V_LU_*         —–> Part of AI(Localized Unit)

V_CI_*          ——> Configuration Item 5 types

V_CH_*         —–> Client Health validation related

V_CM_RES_COLL_<SMS00012>  ——> Member Class name / Machine details of that collection

 

Download Reference -SCCM 2007 SQL Views SCCM 2007 List of views from Technet

Download  ConfigMgr2012R2_SQLViews SCCM 2012 List of views from Technet

Download  Configmgr Tech Preview Default Reports   SCCM 2012 List of Reports Technet

Download  ConfigMgr 2012 R2 Status Messages  SCCM 2012 List of  Status Messages from Technet

 


SCCM 2012 Client Self healing

https://gallery.technet.microsoft.com/systemcenter/SCCM-2012-Client-Self-50c0cb1a

 

Monitoring Home page in the console will help with 2 things ,Those are “monitor the health and activity of client computers”

However Overall status will be depends on below 2 things

Client Activity : configure thresholds to determine whether a client is active (like DDR,requested policy,Hinv,etc)
Client Check: Self Healing with Task Scheduler

sccm 2012 client self healing in workstation how it works:::

Self healing means auto remediation :

Once SCCM client is installed , It will create a scheduled Task in client side. To check open run and type “taskschd.msc”

Then go to Microsoft : check the Configuration Manager. That is the scheduled task

If you open the  Configuration Manager Task  in Action TAB of Task Scheduler , its calling the “C:\WINDOWS\CCM\ccmeval.exe

Once its executed it will send the report  to SCCM server(MP) “C:\Windows\CCM\start CcmEval.xml”.. To check the log open “C:\Windows\CCM\Logs\CcmEval.log”

If the workstation if it has any issues it will be auto healed . CcmEval.xml it will show up what is the issue and whether it got fixed or not. and CcmEval.log will show up what kind of regular checks it will do

 

EX:– If  CCMexec service is stopped or BITS is disabled ,etc,It will check at the Task Scheduler time and  will be auto re-mediated.You can do a test with stopping the WMI service and execute the C:\WINDOWS\CCM\ccmeval.exe. After some time it will be starts the WMI service

CCMevalreport CCMEval

If it is unable to resolve it will be showing in server side under Monitor-> Client Status :

 

CLient status of a specific machine

 

 

To Exclude/Disable automatic remediation

Open Regedit.

Go to “HKEY_LOCAL_MACHINE\Software\Microsoft\CCM\CcmEval\NotifyOnly”

Make it as “True” – computers will not automatically remediate
Make it as “False”– computers will automatically remediate problems


Configuration Manager Support Center

System Center 2012 Configuration Manager Support Center

 

Which is use full when you want to debug in the client side issue or analyzing the logs it will be more help full, You can zip the log’s and you can sent to others  also download

Pre-Requirement Microsoft .NET Framework 4.5.2 downalod


SCCM Client registration failed “RegTask: Failed to get certificate. Error: 0x80004005”

Error :–RegTask: Failed to get certificate. Error: 0x80004005 In ClientIDManagerStartup.log showing

Need to delete the RSA Key’s from “C:\ProgramData\Microsoft\Crypto\RSA\MachineKeys” (need to take the back up of it). Then above error will go

0x80004005

  • First stop the ccmexec service or SMSAgentHost service on the machine.
  • Goto the location \c$\ProgramData\Microsoft\Crypto\RSA\MachineKeys(Hidden Folder)
  • Check for this system file starting with 19c5cf9c7b5dc9de3e548adb70398402_36b8284c-fb19-4e8d-8b06-03433f195f77 (it may be different for different machine but it starts with 19 only)
  • Delete the file and restart the SMSAgenHost service again.
  • Now check ClientIDManagerStartup.log
  • Issue should be resolved.

SCCM Client installation Failed “VAppRegHandler.dll failed to register”

ESCCM Client Installation Failed . In CCMsetup.log showing below lines MSI: Module C:\WINDOWS\system32\CCM\VAppRegHandler.dll failed to register. HRESULT -2147024769. Contact your support personnel. ccmsetup 8/5/2015 11:20:18 PM 4996 (0x1384) MSI: Action 23:20:18: Rollback. Rolling back action: ccmsetup 8/5/2015 11:20:18 PM 4996 (0x1384) Installation failed with error code 1603 ccmsetup 8/5/2015 11:20:50 PM 4996 (0x1384) VAppRegHandler.dll failed to register   I Guess most of the times, It will get success, when you do below steps

1. Manually created folder “CCM” under C:\WINDOWS\system32\ to the problem computer

2. Copied “VAppRegHandler.dll” to the problem computer’s C:\WINDOWS\system32\CCM\

3. On the problem computer, ran in the console: regsvr32 atl.dll

4. On the problem computer, ran in the console: regsvr32 C:\WINDOWS\system32\CCM\VAppRegHandler.dll

5. WMI repair.

If still its not resolved .. Please delete the below “.dll” Files which is related to SCCM client CCMPerf.dll (C:\Windows\system32\) CCMcore.dll(C:\Windows\system32\) Then retry the installation it will get success


How to check Windows update Agent Version

Open the %systemroot%\system32 folder.

Right-click Wuaueng.dll, and then click Properties.

Click the Details tab, and then locate the file version number

 

SQL Query to check Windows update Agent Version :-

SELECT dbo.v_R_System.Name0 AS [Machine Name], dbo.v_GS_WINDOWSUPDATEAGENTVERSIO.Version0
FROM dbo.v_R_System INNER JOIN
dbo.v_GS_WINDOWSUPDATEAGENTVERSIO ON dbo.v_R_System.ResourceID = dbo.v_GS_WINDOWSUPDATEAGENTVERSIO.ResourceID
WHERE (dbo.v_R_System.Name0 IN (‘X1,X2’))


WCM.log (system.Net.WebException: The request failed with HTTP status 503)

In SCCM Software updates synchronization not working when I check WCM.log showing as below error

system.Net.WebException: The request failed with HTTP status 503: Service Unavailable.~~   at Microsoft.UpdateServices.Administration.AdminProxy.CreateUpdateServer(Object[] args)~~   at Microsoft.UpdateServices.Administration.AdminProxy.GetUpdateServer(String serverName, Boolean useSecureConnection, Int32 portNumber)~~   at Microsoft.SystemsManagementServer.WSUS.WSUSServer.ConnectToWSUSServer(String ServerName, Boolean UseSSL, Int32 PortNumber)

Then I just removed all Proxy settings it worked for me ( Go to internet options ->conections Tab-> LAN settings-> Uncheck all boxes)

Note: open the IE with System account using psexec command

psexec -s -d -i cmd.exe :– It will open the new command prompt from here need to open the IE (C:\program Files\Internet Explorer) 


Software Updates : Colde 80244007 Windows Update ran into a problem

When you got the below error in the sccm client side, SCCM software update is not working on that machine. But however other sccm client agents like Software distribution,Inventory ,etc are working as expected

Software Updates : Colde 80244007 Windows Update ean into a problem

Software Updates : Colde 80244007 Windows Update ran into a problem

 Before going for advanced troubleshooting we can a give try of below Steps::

1. Logon in the server and open Control Panel –System and Security – Configuration Manager (32-bit) (or run%windir%\SysWOW64\CCM\SMSCFGRC.cpl)

2. In “Advanced” tab click “Configure Settings” then click “Discover” then click “Apply”.
3. Reboot server
4. Open Control Panel –System and Security – Configuration Manager (32-bit), select “Components” tab and then repair.
5. Reboot server
6. Wait for the “Run advertised programs” popup then trigger the installations
7. If no advertised programs appear:
8. Open and Administrative Command Prompt.
9. Run “DISM.exe /Online /Cleanup-image /Restorehealth”
10. Run “sfc/scannow”
11. Reboot Server
12. Open Control Panel –System and Security – Configuration Manager (32-bit)
13. Select Actions tab
14. Initiate Action for:
15. Machine Policy Retrieval & Evaluation Cycle
16. Software Updates Deployment valuation Cycle
17. Software Updates Scan Cycle

If still its not working please check whether Client is contacting correct WSUS server or not we can check in the  client registry

wsus registry location client

If it is pointing to correct WSUS but still not the issue is same , Need to install the Patch in repective WSUS server.

Most of the time, this issue will occur on windows 8 or windows server 2012  operating system .

Please download the patch from the location : KB2734608

Once you download and install this patch in WSUS server. Issue will get auto resolved

If the Error is “Code 80244007 Windows Update ran into a problem”

Please check this “https://support.microsoft.com/en-us/kb/2883201”

 

 


Hardware/Software Scan with last boot up time on specific machines – SQL Query

SELECT

v_R_System.Name0AS[Server Name],

v_GS_OPERATING_SYSTEM.Caption0AS[Operating System],

v_GS_OPERATING_SYSTEM.LastBootUpTime0AS[Last Machine Boot Up Time],

v_GS_WORKSTATION_STATUS.LastHWScanAS[Last HW Scan Date],

V_GS_LASTSOFTWARESCAN.LASTSCANDATEAS[LAST SOFTWARE SCAN DATE]

FROMv_R_SystemINNERJOINv_GS_OPERATING_SYSTEM

ONv_GS_OPERATING_SYSTEM.ResourceID=v_R_System.ResourceIDINNERJOIN

v_GS_LastSoftwareScanONv_R_System.ResourceID=v_GS_LastSoftwareScan.ResourceIDINNERJOIN

v_GS_WORKSTATION_STATUSONv_R_System.ResourceID=v_GS_WORKSTATION_STATUS.ResourceID

ANDv_R_System.Name0IN(‘Machine01’,‘Machine02’)


SQL query for “X” package DP status

SQL  query  for “X” package DP status..By using Package Name

 

 

select

SUBSTRING(dp.ServerNALPath, CHARINDEX(‘\\’, dp.ServerNALPath) + 2, CHARINDEX(‘”]’, dp.ServerNALPath) – CHARINDEX(‘\\’, dp.ServerNALPath) – 3 ) AS [Code Server Name],

dp.SiteCode,stat.SourceVersion,pstat.UpdateTime,stat.InstallStatus,

dp.PackageID,V_package.Name AS [Package Name] from v_DistributionPoint dp

left join v_PackageStatusDistPointsSumm stat on dp.ServerNALPath=stat.ServerNALPath

and dp.PackageID=stat.PackageID left join v_PackageStatus pstat on dp.ServerNALPath=pstat.PkgServer

and dp.PackageID=pstat.PackageID INNER JOIN

V_package ON V_package.packageid=dp.PackageID

where V_package.name = ‘Package Name’