building a view w/ fields that only contain a certain word
What you have is the simplest and most straightforward.


your WHERE will require every column mentioned somewhere
changing YES into NULL requires a function on each column


For some RDBMS you can create computed column at the table level.

ALTER TABLE PhysicalBuild
   ADD SummaryState AS 
     CASE WHEN Labels = 'No' AND 
        DNSDRAC = 'No' AND                
        DNSHOST = 'No' AND 
        PRTGDRAC = 'No' AND 
        PRTGHOST = 'No' AND 
        LouKVM = 'No' AND 
        SwitchPorts = 'No' AND 
        FiberSwitch = 'No'
     THEN 'No' ELSE 'Yes' END


Then your query is

...
FROM PhysicalBuild
WHERE SummaryState = 'No'


Note: you don't need aliases the same as the column name...