Windows Server without Serial number on Serial number table

[Raunak kapoor2]

I want to create a report for the list of windows servers which do not have serial numbers mapped on cmdb_serial number table

can anyone suggest how can i create a report or a fix script ?

[Raunak kapoor2]

This will not pick up the CI's without serial number on the serial number table in the related list 

[pratik0306]

you can try the same filter on base table also

and you can create a report on cmdb_serial_number table also to check if any Windows servers are without a serial number. Ideally any Virtual machine will not have a serial number, only physical machines are supposed to have it.