Automatically Enable Products Based on SCCM Inventory Scans
Today, we are excited to release a new feature that allows automated scanning and product enablement based on products being detected in your environment.
This new feature is directly from customer feedback on our UserVoice.
In the Updates tab, you can click the database icon to launch the scan feature. The scan feature allows you to perform a one-time query against your environment as well as automated scanning during scheduled synchronizations and automatic product enabling.
Hows Scanning Work?
Each time a synchronization is performed, the service will query the SCCM database and evaluate if any of our supported products match entries in the v_GS_INSTALLED_SOFTWARE, v_Add_Remove_Programs, V_GS_ADD_REMOVE_PROGRAMS, and v_GS_ADD_REMOVE_PROGRAMS_64 views collected via hardware inventory in SCCM. If a product is detected and exceeds the count, it will automatically be enabled for publishing.
You can even enable custom actions for any products that get auto-enabled.
In the event you want to exclude any existing products, you can right-click the product in the update or application rules tab in the publishing service.
SQL Permissions Required?
For better performance, the query is performed directly against the SQL server and does not go through the SMSProvider.
When running the query in the publishing service user interface, it’s performed under the logged on users context. When the query is performed during a synchronization, it’s performed using the SYSTEM account of the WSUS server where the publishing service is installed.
If the WSUS server is remote from the SQL server, you will likely need to grant the computer account the minimum permissions required to run the SQL query.