We can export a list of content host with operating system from satellite 6 server using below steps

Login to satellite webui --> Content --> Errata --> search for errata --> Click on Content Hosts --> you will get list of content host profiles on which the selected errata is applicable.

RFE :- export list of content host with operating system from satellite 6 server into a csv file.