Approved

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.

Parents
  • 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.

Comment
  • 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.

Children
No Data