Alerts in SCCM
Default Queries in SCCM console
Custom Queries:
-Custom Query For Installed Software In SCCM Console
-Custom Query to get a list of all Windows 10 Computers
-Custom Query To Get Computers With a Specific File
-Custom Query To Get Computers Where Specific Service Is Running
-Custom Query To Get Computers Where C Drive Free Space < 100 GB
Alerts in SCCM
Default Queries in SCCM console
Custom Queries:
-Custom Query For Installed Software In SCCM Console
For example, I'm going to create one query which will show me the list of all the computers where a particular application is installed.
“General” tab is the display section, and we also need to add criteria in “criteria” tab.
Actual queries that run in the backend:
-Custom Query to get a list of all Windows 10 Computers
-Custom Query To Get Computers With a Specific File
For example: iexplore.exe
-Custom Query To Get Computers Where Specific Service Is Running
For example: SMS_Executive service
In Configuration Manager, the core components include the SMS_EXECUTIVE Service, Site Component Manager, Site Control Manager, and Site Hierarchy Manager. The SMS_EXEC service is the host process in which most other components run. This service exists on every ConfigMgr site system other than the site database server. The sms_executive service is always set to Automatic.