/build/static/layout/Breadcrumb_cap_w.png

Report DAT version - Custom Data field

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

Answers (1)

Posted by: SMal.tmcc 9 years ago
Red Belt
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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ