SCCM is collecting all the data, such as. Since you are changing the SCCM software inventory to gather more metadata from your SCCM agent, you could run into an issue that the inventory files will become too big.Īll the large inventory files are from SCCM secondary servers because of the software inventory task ran against packages in DP folders. dll files from Windows folder the expected database increase is 3-4 times. exe so when expanding the scope of the SCCM agent you should expect a similar increase of the SQL database. Please note that on a standard machine there are up to 10 times more. To configure the broadest possible pattern, select File Detail: full and add the patterns *.dll, *.exe, *.ocx. Then go to Administration > Client Settings > Properties > Software Inventory.

In Microsoft Endpoint Configuration Manager, go to Devices and right-click Install client. To add permissions, open SQL Server Management Studio, right-click the appropriate database, navigate to permissions and add Connect and Select rights.Īssuming that the SCCM site has been set up, open the SCCM console and ensure that the SCCM client (agent) is installed on the hosts to be scanned. The user running the SVM console must have Connect and Select rights over the SQL database of the SCCM.īy default the database is named CM_. Microsoft Endpoint Configuration Manager integration requires the following prerequisites: If all file data is collected, a file size of between 5 and 10 MB for a single host is not uncommon, and the SQL server must be dimensioned to handle this. To produce the best possible scan result using SCCM, the Software Vulnerability Manager uses a relatively broad pattern, which could lead to large amounts of data being collected. The inventory agent is configured by a set of simple rules that govern which files are queried. Microsoft Endpoint Configuration Manager Software Inventory This document describes settings required to achieve the best possible scan results in Software Vulnerability Manager provided by Microsoft Endpoint Configuration Manager.

Microsoft mecm