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.

 

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

If you use the wizard and create a computer report you can select that from the list of fields at the bottom of the field page under custom fields.

If the custom report is not sufficient for you. Save that query and then choose edit as sql and you will get the ID of that custom field.

Answered 05/19/2014 by: SMal.tmcc
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity