History table for "Installed Software"

Question

Hello Gurus,

I used "v_HS_INSTALLED_SOFTWARE" and "INSTALLED_SOFTWARE_HIST" but I am not getting the exact data which I see in Device Resource Explorer in console.
In console I can see a lot software installed in history but in above table, I see only a few.

Any leads are appreciated.

Answer 1

Where exactly in resource explorer are you looking?

Answer 2

@muditbahedia
Thank you for posting in Microsoft Q&A forum.
For my experience, the Resource Explorer only show the currently installed software.
But the table v_HS_INSTALLED_SOFTWARE shows the history software which means these softwares existed before but have now been removed. And the v_GS_INSTALLED_SOFTWARE shows the currently installed software, so what you see from Resource Explorer should match the table v_GS_INSTALLED_SOFTWARE.
The few software you see should have been replaced by current version of the software.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

First off it is not supported to query the tables directly, only query the views.
Secondly, what exactly is missing that you see in resource explorer that you don't see within the view? Post a screenshot.