SCCM SQL Query to capture CPU information

SELECT
DISTINCT(CPU.SystemName0) AS [System Name],
CPU.Manufacturer0 AS Manufacturer,
CPU.Name0 AS Name,
COUNT(CPU.ResourceID) AS [Number of CPUs],
CPU.NumberOfCores0 AS [Number of Cores per CPU],
CPU.NumberOfLogicalProcessors0 AS [Logical CPU Count]
FROM [dbo].[v_GS_PROCESSOR] CPU
GROUP BY
CPU.SystemName0,
CPU.Manufacturer0,
CPU.Name0,
CPU.NumberOfCores0,
CPU.NumberOfLogicalProcessors0

SCCM report for IIS installed with version details on servers

Hi all ,Another report to find out the servers where IIS is installed with the version of it.this assumes that ,you have enabled the inventory agent and set the properties for .exe to not exclude windows folder.If you select exclude files from windows directory,you will not see any results in the report because inetmgr.exe will be located in windows folder.

SQL SCCM query:

select distinct a.Name0,c.FileVersion from v_R_System a inner join

v_GS_SERVICE b on b.ResourceID = a. ResourceID inner join
v_GS_SoftwareFile c on c.ResourceID=a.ResourceID
where b.DisplayName0 like 'World Wide Web%' and
a.Operating_System_Name_and0 like '%Server%'  and
c.FileName ='inetmgr.exe'
Order by a.Name0,c.FileVersion 

Ref: http://eskonr.com/2010/05/sccm-report-for-computers-with-iis-installed-on-servers/

Setup was unable to compile the file DiscoveryStatus.mof The error code is 8004100E

SCCM Client installation issue and fix:

Error code: DiscoveryStatus.mof The error code is 8004100E

Just try this remediation step.

1. Open CMD in the administrator command prompt

2. Navigate to C:\Program Files\Microsoft Policy Platform

3. mofcomp ExtendedStatus.mof

4. Retry the CM client installation

Ref: https://social.technet.microsoft.com/Forums/en-US/1f48e8d8-4e13-47b5-ae1b-dcb831c0a93b/setup-was-unable-to-compile-the-file-discoverystatusmof-the-error-code-is-8004100e?forum=configmanagerdeployment