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

Issue: Some clients may not show as being installed when viewed through the System Center Configuration Manager 2012 admin console.
From the target computers themselves the agents appear to function properly.
When viewing the ClientIDManagerStartup.log file you may also see the following error:

RegTask: Failed to get certificate. Error: 0x80004005

Cause: This is caused by an issue with the RSA machine keys on the client.

Resolution: To resolve this issue complete the following steps:

Backup all files in the C:\All Users\Application Data\Microsoft\Crypto\RSA\MachineKeys folder Delete(or the corresponding folder on your specific clients).
Restart the SMS Agent Host Service to recreate these certificates.
At this point the clients should start showing up in the console.  If not, remove and push the client agent to the affected computers again.
========

I hope you don’t get this issue yourself but if you do then at least know you’ll know how to fix it.

SSRS Reports error in XML document (1, 43464). ' ', hexadecimal value 0x1F, is an invalid character. Line 1, position 43464.

Some Times when we mistake use the Collection and Query use IF Condition it will effet some more SSRS reports  when we get Below Error :-

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

There is an error in XML document (1, 43464).

' ', hexadecimal value 0x1F, is an invalid character. Line 1, position 43464. 

I used the following SQL query to search through the parameters to find which one(s) contain the 1F hex value

SELECT Name 

FROM v_Collection 

WHERE CONVERT(varchar(max),convert(varbinary(max),convert(nvarchar(max),Name)),2) LIKE ‘%1F%’

Here is what we got:

Name 

RestartOSCE _109057 (as Collection name)

Count of Multiple Application Software's vs Specific Collection Count and Percent.

Count of Application Software's vs Specific Collection Count

Below Query use full for Multiple application software's count and version vs Total active System Cont and Percent.


SELECT DisplayName0,
Version0,
Count(distinct arp.ResourceID) AS 'ApplicationCount',
 @CollID as CollectionID,
 tot.TotalClient,
 CONVERT(decimal(5,2),Count(distinct arp.ResourceID)*100.00/tot.TotalClient) As 'Percent'

  FROM 

( 
        SELECT   
               COUNT(1) TotalClient 
          FROM v_R_System sis 
               INNER JOIN v_RA_System_SMSAssignedSites sit 
                  ON sis.ResourceID = sit.ResourceID 
                 AND sis.Client0 = 1 
                 AND sis.Obsolete0 = 0 
                 AND sis.Active0 = 1 
           GROUP BY sit.SMS_Assigned_Sites0 
        )  AS tot,
v_Add_Remove_Programs arp

JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID

WHERE fcm.CollectionID = @CollID

and  DisplayName0 like 'xxxxxxx'
or  DisplayName0 like 'xxxxxxx'

GROUP BY DisplayName0,Version0,tot.TotalClient
ORDER BY  DisplayName0