Hi Alex,
you can create your own query to get all the machines without a Serial Number
- on the DSM go to the Query folder
rigth click and select new, select "Computers" and click OK
on the next widows open the tree "insert argument" / "General Information" / "computer" and select "Serial Number" on the botom let the first entry with the value "=" and select on the combo list the empty value
on he "Boolean Operator" select "Or" and do the same for the value "N/A" and "Not Available" or any other you wich displayed?
click on "preview" to see the results or save and and run the query
- with the mssql query you can run something like
use mdb
SELECT * FROM ca_discovered_hardware WHERE serial_number is null or serial_number = '' or serial_number = 'N/A' or serial_number = 'Not Available'
regards,
Antonio