Trying to find systems where Package was installed more than 7 days ago

(imported topic written by SystemAdmin)

I’m trying to determine how many days ago a software package was installed on a Windows computer.

I’ve tried looking at the InstallDate under the Uninstall key …

Q: ((exists keys whose (exists value “DisplayName” of it AND value “DisplayName” of it as string as lowercase starts with “pgp” AND (((current date - date (last 2 of it & " " & (month (last 2 of first 6 of it as integer) as three letters) & " " & first 4 of it)) of firsts 8 of (value “InstallDate” of it as string)) > 7*days)) of key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall” of registry))

E: A singular expression is required.

Next I thought I could compare NOW with the Creation Date of the installation folder, but I can’t find how to determine when a Folder was created.

Can anyone help me with either of these two methods?

BTW: The InstallDate value is formatted “YYYYMMDD” ie “20101115” and I’m trying to find computers where is was installed more than 7 days ago.

(imported comment written by Lee Wei)

You have already done all the hard pieces.

firsts 8 should be first 8

7days should be 7day

…without going into explaining the syntactical reasons.

((exists keys whose (exists value “DisplayName” of it AND value “DisplayName” of it as string as lowercase starts with “tivoli endpoint manager excel” AND (((current date - date (last 2 of it & " " & (month (last 2 of first 6 of it as integer) as three letters) & " " & first 4 of it)) of first 8 of (value “InstallDate” of it as string)) > 7*day)) of key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall” of registry))

(imported comment written by SystemAdmin)

Thanks Lee, it works great! Darned plurality!