query to find installation date of VSE 8.7

[serc09]

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

[Rene.TRK.Wiese · Accepted 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

[serc09]

THX, works fine.

FMR will be done this day too!

Regards

serc09