SMS_MP_CONTROL_MANAGER failed to start with 0x80041006

Cause :

0x8004100e = WBEM_E_INVALID_NAMESPACE

Resolution :

To resolve above problem needs to check WMI Permissions or follow below steps.

1) Reboot Site Server. ( also Reboot Database server if installed separately. )  OR

2) Uninstall SCCM Client from Site Server.    OR

3) Open Command Prompt on Site server and type winmgmt /salvagerepository  command to refresh WMI Permission.   OR

4) Reset Site System will reinstall Management Point.

Last logged on User SQL report

SELECT v_GS_SYSTEM.Name0 AS ComputerName, v_GS_SYSTEM.Domain0 AS [Logon Domain], v_GS_SYSTEM.SystemRole0 AS [System Role],
v_GS_SYSTEM.SystemType0 AS [System Type], v_GS_COMPUTER_SYSTEM.UserName0 AS [Logon User],
v_GS_COMPUTER_SYSTEM.TimeStamp AS [Last Loggedin Time]
FROM v_GS_SYSTEM INNER JOIN
v_GS_COMPUTER_SYSTEM ON v_GS_SYSTEM.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID
WHERE (v_GS_SYSTEM.Name0 = @ComputerName)
ORDER BY ComputerName

Name :ComputerName

Promptname:ComputerName

SQL Statement:

begin
if (@__filterwildcard = ”)
SELECT DISTINCT V_GS_SYSTEM.Name0 from V_GS_SYSTEM ORDER By V_GS_SYSTEM.Name0
else
SELECT DISTINCT V_GS_SYSTEM.Name0 from V_GS_SYSTEM
WHERE V_GS_SYSTEM.Name0 like @__filterwildcard
ORDER By V_GS_SYSTEM.Name0
end

SCCM 2012 Virtual Labs

Client Status Reporting Tool for SCCM

Using Client Status Reporting to Monitor Client Status

Client status reporting in Configuration Manager 2007 R2 provides up-to-date information on the manageability of clients in a Configuration Manager 2007 hierarchy. This information can be used by the site administrator to identify individual client problems and to maintain a more accurate site database. It can also help to increase software distribution success rates.

Client status reporting in Configuration Manager 2007 R2 provides the following improvements over existing methods for diagnosing the status of Configuration Manager 2007 clients:

  • Identifies clients that are online but are not requesting policy.
  • Provides a number of reports that detail the status of clients on your site.
  • Identifies clients that are online but have nonfunctioning client components.
  • Identifies clients that are online but do not have up-to-date discovery or inventory records.
  • Identifies clients that are offline.
  • Is not dependent on Configuration Manager 2007 site systems. For example, client status reporting will not be affected by problems with backlogged site systems which could cause traditional reporting mechanisms to generate inaccurate results.
  • Uses a number of data sources for its analysis, including data from the Configuration Manager 2007 site database, such as inventory, discovery, and heartbeat data. Additionally, client status reporting components gather and analyze policy request log files from management points, and can also check the status and activity of Configuration Manager 2007 client components.

This post is to provide an insight on Client Status Reporting tool that can be used to provide up-to-date Information on the status of client computers in Configuration Manager 2007 hierarchy.

A number of methods exist in Configuration manager 2007 R2 that can assist you in monitoring the status of client computers on your CM 2007 R2 site. These methods are largely based on the data of the latest discovery and inventory data received from the client.By using CSR tool to identify individual client problems and to maintain a more accurate site database. It can also help to increase software distribution success rates.

Source : http://technet.microsoft.com/en-us/library/cc161853.aspx

Installing and configuring Client status Reporting

Select “Client Status Reporting” from the main installation wizard under the “Additional Content” section. You can also browse to the “Client Status Reporting” folder on the CD as the install will take you there anyways.

clip_image002

Launch the “Clientstatusreporting” MSI.

clip_image004

Select “Next”.

clip_image006

Select “I accept the license agreement” and select “Next”.

clip_image008

Select the destination folder and select “Next”.

clip_image010

Select “Next” to start the installation.

clip_image012

Select “Finish”.

clip_image014

You will have a new menu option in the Start menu. Launch the “Configure Client Status Reporting” to finalize the installation.

clip_image016

On the “Site Settings” tab, you will need to configure the SQL server and instance, along with what account you want the Client Status reporting to run under. I typically will configure it to use the local system account.

clip_image018

On the Options tab, you will want to select the “Update Configuration Manager 2007 site database with inactive client information”, you will also want to configure the client activity periods for your environment.

clip_image020

On the Schedule tab, you will want to enable the Client pulse settings along with the Client ping settings. You will also want to configure the schedules for those settings.

clip_image022

clip_image024

8. Importing the Client Status reports into Configuration Manager

Select “Import Objects” on the Reporting node.

clip_image026

Select “Next”.

clip_image027

Select “Browse”.

clip_image028

Browse to the path you see below. Then select “Open”.

clip_image029

Select “Next”.

clip_image030

Select “Next”.

clip_image031

Select “Next”.

clip_image032

Select “Finish”.

clip_image034

After the reports have been imported, you can see them listed in the reports folder or

clip_image036

Bottom of Form

After the reports have been imported you can see them listed in Report viewer link

clip_image038

You will get More information about Client status reporting tool in Microsoft TechNet Library http://technet.microsoft.com/en-us/library/cc161956.aspx

 

To grant DCOM Remote Activation permissions to the SMS Admins group for the SCCM console to connect DB from any machine

 

  1. From the Start menu, click Run and type Dcomcnfg.exe.

  2. In Component Services, click Console root, expand Component Services, expand Computers, and then click My Computer. On the Action menu, click Properties.

  3. In the My Computer Properties dialog box, on the COM Security tab, in the Launch and Activation Permissions section, click Edit Limits.

  4. In the Launch Permissions dialog box, click Add.

  5. In the Select User, Computers, or Groups dialog box, in the Enter the object names to select (examples): box, type SMS Admins and click OK.

  6. In the Permissions for SMS Admins section, select the check box to allow Remote Activation.

  7. Click OK twice, and then close Computer Management.

WQL queries to find out x86 and x64 bit

Windows 7 -x64:

select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_SYSTEM.SystemType from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = “x64-based PC” and SMS_G_System_OPERATING_SYSTEM.Caption like “Microsoft Windows 7%”

 

Windows 7 -x86:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.SystemType = "X86-based PC" and SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 7%"

SQL query for Applicable and Installed updates for a Collection

SELECT DISTINCT

SYS.Name0 AS [Server Name], CASE WHEN UCS.Status = ‘2’ THEN ‘Applicable’ WHEN UCS.Status = ‘3’ THEN ‘Installed’ ELSE ” END AS ‘Patch Status’,

UI.BulletinID AS [Bulletin ID], UI.ArticleID AS [Article ID], UI.Title

FROM         v_R_System AS SYS LEFT OUTER JOIN

                      v_Update_ComplianceStatusAll AS UCS ON SYS.ResourceID = UCS.ResourceID INNER JOIN

                      v_UpdateInfo AS UI ON UCS.CI_ID = UI.CI_ID

WHERE     (UCS.Status IN (‘2’, ‘3’)) AND (SYS.Name0 IN (SELECT DISTINCT v_FullCollectionMembership.Name

FROM v_FullCollectionMembership INNER JOIN

     v_R_System ON v_R_System.ResourceID = v_FullCollectionMembership.ResourceID AND v_R_System.Active0 = 1 AND

                                                   v_FullCollectionMembership.CollectionID IN (‘xxxxxxxx’)))