Scripting

If you are on 5.4 you should be able to do that with the wizard and create a report using the Computer and the topic and Software as the subtopic. You can also do it via machine labels. Create smart label that looks for machines who don't have Software Title Mcafee and give it a label like Don't have Mcafee. 

Then create a computer report to show you:

system name, ip address, BSN, OS name, label

in step 5 filter so it only shows you machiens that have the Dont' have mcafee machine label.

SELECT DISTINCT M.NAME, IP, BIOS_SERIAL_NUMBER,OS_NAME

FROM MACHINE M

LEFT JOIN MACHINE_SOFTWARE_JT MSJT ON M.ID = MSJT.MACHINE_ID

LEFT JOIN SOFTWARE S ON MSJT.SOFTWARE_ID = S.ID

WHERE S.DISPLAY_NAME NOT LIKE '%MCAFEE%'

Make sure you use the EXACT name from the software inventory.

Select

  MACHINE.NAME As 'System Name',

  MACHINE.SYSTEM_DESCRIPTION As 'Description',

  MACHINE.IP As 'IP Address',

  Group_Concat(Distinct SOFTWARE.DISPLAY_NAME Separator '\n') As

  'Software Title Name',

  SOFTWARE.DISPLAY_VERSION As 'Software Version'

From

  MACHINE Left Join

  MACHINE_SOFTWARE_JT On MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID Left Join

  SOFTWARE On SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID

Where

  SOFTWARE.DISPLAY_NAME != 'INSERT EXACT SOFTWARE NAME' And

  SOFTWARE.DISPLAY_VERSION !=  'INSERT EXACT SOFTWARE VERSION'

Group By

  MACHINE.ID

Order By

  MACHINE.NAME, SOFTWARE.DISPLAY_NAME

Here is one that correctly uses a subquery to limit to only machines that don't have McAfee Installed. I use McAfee Agent as the name for the software.

Select

  MACHINE.NAME As 'System Name',

  MACHINE.SYSTEM_DESCRIPTION As 'Description',

  MACHINE.IP As 'IP Address'

From

  MACHINE,

  MACHINE_SOFTWARE_JT,

  SOFTWARE  

Where

MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID  

andMACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID

and MACHINE.NAME not in (Select 

  MACHINE.NAME 

From

  MACHINE,

  MACHINE_SOFTWARE_JT, 

  SOFTWARE  

Where

MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID  

andMACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID

andSOFTWARE.DISPLAY_NAME in ('McAfee Agent')

)

Group By

  MACHINE.ID

Order By

  MACHINE.NAME

Here is a query using a subquery that only shows machines that do not have McAfee installed. The software name that I use is "McAfee Agent"

Select

  MACHINE.NAME As 'System Name',

  MACHINE.SYSTEM_DESCRIPTION As 'Description',

  MACHINE.IP As 'IP Address'

From

  MACHINE,

  MACHINE_SOFTWARE_JT,

  SOFTWARE  

Where

MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID  

andMACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID

and MACHINE.NAME not in (Select 

  MACHINE.NAME 

From

  MACHINE,

  MACHINE_SOFTWARE_JT, 

  SOFTWARE  

Where

MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID  

andMACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID

andSOFTWARE.DISPLAY_NAME in ('McAfee Agent')

)

Group By

  MACHINE.ID

Order By

  MACHINE.NAME