Please follow the instructions given below:
Access the database and execute the SQL queries provided below:
SELECT COUNT(*) as TotalCount FROM v_GS_SYSTEM;
SELECT COUNT(*) as TotalCount FROM v_GS_SYSTEM LEFT JOIN v_GS_WORKSTATION_STATUS ON v_GS_SYSTEM.ResourceID = v_GS_WORKSTATION_STATUS.ResourceID WHERE v_GS_WORKSTATION_STATUS.LastHWScan > CONVERT(DateTime, 'YYYY-MM-DD HH:MM:SS');
The above queries get the total number of devices in SCCM from the Probe.