Colleagues asked me to create a two custom reports, because we installed updates a few years ago by packages and then deleted advertisements. So in this case we couldn’t use a built-in reports.
SELECT DISTINCT TOP (100) PERCENT dbo.v_R_System.Netbios_Name0 FROM dbo.v_R_System INNER JOIN dbo.v_GS_QUICK_FIX_ENGINEERING ON dbo.v_R_System.ResourceID = dbo.v_GS_QUICK_FIX_ENGINEERING.ResourceID WHERE (dbo.v_R_System.Netbios_Name0 LIKE '%PARX0100%' OR dbo.v_R_System.Netbios_Name0 LIKE '%PARX0602%' OR dbo.v_R_System.Netbios_Name0 LIKE '%PARX0603%') AND (dbo.v_GS_QUICK_FIX_ENGINEERING.HotFixID0 LIKE '%2427997%' OR dbo.v_GS_QUICK_FIX_ENGINEERING.HotFixID0 LIKE '%2531912%' OR dbo.v_GS_QUICK_FIX_ENGINEERING.HotFixID0 LIKE '%2521923%' OR dbo.v_GS_QUICK_FIX_ENGINEERING.HotFixID0 LIKE '%2577550%' OR dbo.v_GS_QUICK_FIX_ENGINEERING.HotFixID0 LIKE '%2706168%') ORDER BY dbo.v_R_System.Netbios_Name0
SELECT DISTINCT TOP (100) PERCENT Netbios_Name0 FROM dbo.v_R_System WHERE (Netbios_Name0 NOT IN (SELECT v_R_System_1.Netbios_Name0 FROM dbo.v_R_System AS v_R_System_1 INNER JOIN dbo.v_GS_QUICK_FIX_ENGINEERING AS v_GS_QUICK_FIX_ENGINEERING_1 ON v_R_System_1.ResourceID = v_GS_QUICK_FIX_ENGINEERING_1.ResourceID WHERE (v_GS_QUICK_FIX_ENGINEERING_1.HotFixID0 LIKE '%2427997%') OR (v_GS_QUICK_FIX_ENGINEERING_1.HotFixID0 LIKE '%2521923%') OR (v_GS_QUICK_FIX_ENGINEERING_1.HotFixID0 LIKE '%2577550%') OR (v_GS_QUICK_FIX_ENGINEERING_1.HotFixID0 LIKE '%2706168%') OR (v_GS_QUICK_FIX_ENGINEERING_1.HotFixID0 LIKE '%2531912%'))) AND (Netbios_Name0 LIKE '%PARX0100%' OR Netbios_Name0 LIKE '%PARX0101%' OR Netbios_Name0 LIKE '%PARX0603%') ORDER BY Netbios_Name0