Sophos UTM: Decommissioning of obsolete URL categorization services CFFS. Click here for important info.


This query is one you are recommended to read the full content of the post to use. It is not simply a copy and paste query, like others in the forum. It is valuable in the right situation 

Query to collect Serial Numbers of computers

Can someone help me. I need collect serial numbers of computers with sophos agent installed.

  • Hello Christian, 

    Thank you for reaching out to us. The following query may work for you. When running this and comparing the results with the locally run command "wmic bios get serialnumber" the returned output is the same. 

    SELECT hardware_serial AS SerialNumber FROM system_info

    You can determine what information is available to query by using the following schema document. Please note, there is also a separate osquery schema document which this information was taken from. Determining if the information you are looking for is present in the tables available is the first step to verifying if a query can be used to retrieve the data you're looking for.

  • Recommend  you get yourself an RMM tool as this will offer this feature plus much more.