WUA: No installation date

Share your tips or issues concerning the WAPT Console or WAPT Agent here
Forum Rules
Community Forum Rules
* English support on www.reddit.com/r/wapt
* French community support is available on this forum
* Please prefix the topic title with [RESOLVED] if it is resolved.
* Please do not edit a topic that is tagged [RESOLVED]. Open a new topic referencing the old one.
* Specify the installed WAPT version, full version, and build number (2.2.1.11957 / 2.2.2.12337 / etc.) as well as the Enterprise/Discovery edition.
* Versions 1.8.2 and earlier are no longer supported. The only questions accepted regarding version 1.8.2 are related to upgrading to a supported version (2.1, 2.2, etc.).
* Specify the server OS (Linux/Windows) and version (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specify the OS of the administration/package creation machine and the machine with the problematic agent, if applicable (Windows 7/10/11/Debian 11/etc.).
* Avoid asking multiple questions when opening a topic, otherwise it may be ignored. If there are multiple topics, open separate topics, preferably one after the other and not all at the same time (i.e., do not spam the forum).
* Include code snippets, screenshots, and other images directly in the post. Links to Pastebin, Bitly, and other third-party sites will be systematically removed.
* As with any community forum, support is provided voluntarily by members. If you require commercial support, you can contact Tranquil IT's sales department at 02.40.97.57.55
Answer
User avatar
t.heroult
Messages: 307
Registration: December 8, 2020 - 10:13 AM

December 14, 2023 - 2:56 PM

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
Server: WAPT Enterprise 2.6.1.17786 on Debian
Consoles: Windows 10 & 11
Infrastructure: Windows

Did you know? When parrotfish undergo smoltification, their osmoregulation mechanism is reversed!
User avatar
sfonteneau
WAPT Expert
Messages: 2318
Registered: July 10, 2014 - 11:52 PM
Contact :

December 14, 2023 - 4:57 PM

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.
User avatar
sfonteneau
WAPT Expert
Messages: 2318
Registered: July 10, 2014 - 11:52 PM
Contact :

December 18, 2023 - 12:23

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.
Attachments
Capture.PNG
Capture.PNG (30.95 KB) Viewed 4315 times
User avatar
t.heroult
Messages: 307
Registration: December 8, 2020 - 10:13 AM

December 20, 2023 - 9:31 AM

Great, it's cool that things are moving forward!
Thanks for the feedback, Simon.
Server: WAPT Enterprise 2.6.1.17786 on Debian
Consoles: Windows 10 & 11
Infrastructure: Windows

Did you know? When parrotfish undergo smoltification, their osmoregulation mechanism is reversed!
User avatar
dcardon
WAPT Expert
Messages: 1932
Registration: June 18, 2014 - 09:58
Location: Saint Sébastien sur Loire
Contact :

December 20, 2023 - 10:45 AM

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
Denis Cardon - Tranquil IT
Share your experiences on WAPT! Send us your blog and article URLs in the "Your Opinion of the forum, and we'll feature them on the WAPT
User avatar
t.heroult
Messages: 307
Registration: December 8, 2020 - 10:13 AM

December 20, 2023 - 4:33 PM

That seems like a good idea to me, Denis!
Server: WAPT Enterprise 2.6.1.17786 on Debian
Consoles: Windows 10 & 11
Infrastructure: Windows

Did you know? When parrotfish undergo smoltification, their osmoregulation mechanism is reversed!
User avatar
sfonteneau
WAPT Expert
Messages: 2318
Registered: July 10, 2014 - 11:52 PM
Contact :

December 21, 2023 - 10:00 AM

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.
Answer