Hello people :) I am looking for the right querie to collect every computers serial number inside a collectiong. Tried googling alot, but nothing seems to work. I usually get a syntax error on anything I try. Anyone here who can help me out? Best regards, Roy

Hi Roy, Here is the query that return NetBIOS Name and Serial Number. select sms_r_system.NetbiosName,SMS_G_System_PC_BIOS.SerialNumber from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_system_PC_BIOS.ResourceID=SMS_R_System.ResourceID When you are creating a query, select "Prompt for collection", so you can select the collection and run it against that collection. Regards, Madan