How to get the total number of assets in the SCCM server using SQL query?

Please follow the instructions given below: 

1. 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');
  
  

2. The above queries get the total number of devices in SCCM from the Probe.