Does this have to be in SQL?

Can you use the Computer Hardware Information report and select the criteria as: Number of Cores Equal To xx

Then if you specifically want only servers add the column Server in and tick it to display just servers.