Software

Hello all,

I am trying to create a report which shows the Machines, McAfee Software installed and DAT version.

So far, I have created the custom data field for retrieving the DAT version as follows:

RegistryValueReturn(HKEY_LOCAL_MACHINE\SOFTWARE\McAfee\AVSolution\AVS\AVS\, szAMCoreVersion, TEXT) which works as expected; Howerver I don't know how to include this value on my SQL query:

select
    M.NAME as MACHINE_NAME,
    M.IP,
    OS_NAME,
    SERVICE_PACK,
    S.DISPLAY_NAME as SOFTWARE_NAME,
    S.DISPLAY_VERSION as VERSION
from
    SOFTWARE S
        left join
    MACHINE_SOFTWARE_JT MSJ ON S.ID = MSJ.SOFTWARE_ID
        left join
    MACHINE M ON MSJ.MACHINE_ID = M.ID
where
    ((S.DISPLAY_NAME like 'McAfee T%' or S.DISPLAY_NAME like 'McAfee L%')      
    and not IS_PATCH)

How do I suppose to include the value of that registry key, in order to show apart from the values listed (Hostname, IP, OS, McAfee Software and Version) above the DAT version?

Thanks in advance.