cancel
Showing results for 
Search instead for 
Did you mean: 
serc09
Level 10
Report Inappropriate Content
Message 1 of 3

query to find installation date of VSE 8.7

Jump to solution

Hey.

Is there a way to find out the instalation date of VSE 8.7 on the clients via query?

Using epo 4.5.

Regards

serc09

1 Solution

Accepted Solutions
Highlighted

Re: query to find installation date of VSE 8.7

Jump to solution

Dear serc09,

it appears that this query can not be created using the query builder built into the ePO 4.5 console.

I would like to ask you to create for this particular query a FMR.

https://secure.nai.com/apps/downloads/products/product.asp

Meanwhile you can use the sql script below to gather the information needed:

select

NodeName as Machinename, ps.value as 'VSE First Install Date', LastInstalled as 'VSE Last Install Date' from epoleafnode as t INNER JOIN dbo.EPOProductproperties as pp on t.autoid = pp.parentid INNER JOIN dbo.EPOProductSettings as ps on ps.parentid = pp.autoid where pp.productcode = 'VIRUSCAN8700' AND ps.settingname = 'szInstallDateTime'

HTH,

Rene

View solution in original post

2 Replies
Highlighted

Re: query to find installation date of VSE 8.7

Jump to solution

Dear serc09,

it appears that this query can not be created using the query builder built into the ePO 4.5 console.

I would like to ask you to create for this particular query a FMR.

https://secure.nai.com/apps/downloads/products/product.asp

Meanwhile you can use the sql script below to gather the information needed:

select

NodeName as Machinename, ps.value as 'VSE First Install Date', LastInstalled as 'VSE Last Install Date' from epoleafnode as t INNER JOIN dbo.EPOProductproperties as pp on t.autoid = pp.parentid INNER JOIN dbo.EPOProductSettings as ps on ps.parentid = pp.autoid where pp.productcode = 'VIRUSCAN8700' AND ps.settingname = 'szInstallDateTime'

HTH,

Rene

View solution in original post

serc09
Level 10
Report Inappropriate Content
Message 3 of 3

Re: query to find installation date of VSE 8.7

Jump to solution

THX, works fine.

FMR will be done this day too!

Regards

serc09

More McAfee Tools to Help You

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community