How to find all PC where Boot from CD is supported

In order for this to work you must enable the “BiosCharacteristics” within the PC Bios class. http://smsug.ca/blogs/garth_jones/archive/2007/03/30/228.aspx

 

SELECT CS.Name0, CS.UserName0

FROM v_GS_COMPUTER_SYSTEM CS, v_GS_PC_BIOS BIOS

WHERE BIOS.ResourceID = CS.ResourceID AND (BIOS.BiosCharacteristics0 Like ‘% 15,%’)

ORDER BY CS.Name0

Leave a Reply

Your email address will not be published. Required fields are marked *