In which table I will find the serial number of the computers.
Hi, not sure why you need this to be done by DB querying, but you can easily create a property for it (For Windows clients: string value of select “serialnumber from Win32_bios” of wmi) - if you have not done that already.
After that, you can run Property ID Mapper utility which will create/update your PROPERTYIDMAP table. That contains the name of the properties and the ids you need to query for the results (SiteID, AnalysisID, PropertyID).
You can than use those ids to query for the results of “SerialNumber” property from the QUESTIONRESULTS and LONGQUESTIONRESULTS tables.
If you do not want to run Property ID Mapper utility, you can go over this by querying QUESTIONRESULTS for a specific Serial Number on ResultsText column - this way you will find out the SiteID, AnalysisID and PropertyID values for your specific property.