Configuration Manager

ExtnProv provider started with result code 0x80041013 extnprov.dll

I recently assisted a client with a very specific issue which was stopping the SCCM Console from loading. During my investigation I found there was no suitably ranked article and so here is the issue outline and resolution. Key error codes:- In ‘Windows Logs\Application and Service Logs\Microsoft\Windows\WMI-Activity’ log you see event source WMI-Activity Event 5857 –¬†ExtnProv provider started with result code 0x80041013 extnprov.dll Environment:- Windows Server 2012 R2 Configuration Manager 2012 R2 Symptoms:- Opening the SCCM Console just hangs until the error page is shown. Within the …\AdminConsole\AdminUILog (with verbose enabled) WMI errors are shown “unknown error”. Issue:- Permissions for...

Continue reading...

Inventory Microsoft SQL Server Information with Configuration Manager 2012

Accurately inventory and report on Microsoft SQL Server Instances with SCCM 2012 It is ironic that Configuration Manager provides such basic inventory capabilities for products such as Microsoft SQL Server and Microsoft Exchange. This solution addresses the limitations of attempting SQL Server inventory with the native inventory information available. Specifically this solution provides the following information for SQL Server versions, tested as far back as SQL 2005, and provides the following information for all SQL Instances detected:- Collation Edition EditionType FeatureList InstallPath InstanceName Language PatchLevel ProductCode ProductID ServicePack Version An example of the inventory data is shown below:- An example...

Continue reading...

Client Activity Information Refresh in the Configuration Manager Console

I had someone ask me if Configuration Manager was broken today because the clients hardware inventory date stamp was taking a long time to update in the Configuration Manager Console. Specifically I refer to the information shown in the image below:- The inventory information was in the resource explorer but not being reflected here. Firstly there is a delay of roughly 24 hours between the actual inventory operations (Hardware Inventory, Software Scan, Policy Request etc.) and the console update. The reason for this is because a stored procedure in the Configuration Manager Database (CH_SyncClientSummary) needs to execute before the v_CH_ClientSummary...

Continue reading...