Page 1 of 1
WUA: No installation date
Published: Dec 14, 2023 - 2:56 PM
by t.heroult
Hello,
I already pointed this out a long time ago, and although I was assured it would be fixed, the problem persists.
In the WAPT console,
under the Inventory tab, the installation dates of WUA updates are almost never recorded. It's impossible to know when an update was applied.
Under the Windows Updates tab, the download dates of updates are also not recorded.
Sincerely,
Tom
Re: WUA: No installation date
Published: Dec 14, 2023 - 4:57 PM
by sfonteneau
t.heroult wrote: ↑Dec 14, 2023 - 2:56 PM
Inventory tab: WUA update installation dates are almost never recorded. It's impossible to know when an update was applied.
I'll look into a solution; I have a few ideas. Windows Update doesn't always return a history, so we don't have the date. Does WMI sometimes return other information? I'll see
t.heroult wrote: ↑Dec 14, 2023 - 2:56 PM
Windows Updates tab: Update download dates are also not recorded.
Actually, the column doesn't really make much sense; I think we'll just remove it to avoid confusion.
Explanation: a kb (update_id) is not a single file, it is a set of files.
And some files can be used by multiple update_ids (kb). So putting a date on each file would make sense, but putting a date on the kb line doesn't.
Re: WUA: No installation date
Published: Dec 18, 2023 - 12:23
by sfonteneau
Just so you know, I've made some progress. With WMI, I can retrieve all the dates for the cab systems.
However, for all other products, it seems impossible... I'll keep looking, but it looks complicated.
Re: WUA: No installation date
Published: Dec 20, 2023 - 09:31
by t.heroult
Great, it's cool that things are moving forward!
Thanks for the feedback, Simon.
Re: WUA: No installation date
Published: Dec 20, 2023 - 10:45 AM
by dcardon
Hello Thomas and Simon,
indeed, Windows doesn't seem to store the installation dates for all products. The WAPT agent knows when it performed the installation, so we could store the information in waptdb.sqlite and try to fill in the missing data in the Windows history.
Denis
Re: WUA: No installation date
Published: Dec 20, 2023 - 4:33 PM
by t.heroult
That seems like a good idea to me, Denis!
Re: WUA: No installation date
Published: Dec 21, 2023 - 10:00 AM
by sfonteneau
Hmm, yeah...
Basically, we won't be able to use the product cabs that were already installed when the machine was formatted.
The same goes if the product cab was installed manually via an MSU, for example.
So I don't know if it's worth doing that.