Where exactly in resource explorer are you looking?
History table for "Installed Software"
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.
3 answers
Sort by: Most helpful
-
Jason Sandys 31,286 Reputation points Microsoft Employee
2020-09-08T00:18:49.55+00:00 -
AllenLiu-MSFT 43,946 Reputation points Microsoft Vendor
2020-09-08T02:21:58.017+00:00 @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. -
Garth 5,801 Reputation points
2020-09-08T11:28:58.59+00:00 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.