Join v_GS_Installed_Software with v_configurationitems or v_UpdateInfo in SQL

Question

I'm working with the v_GS_Installed_Software table to check the installed software on various machines. I want to join this table with v_configurationitems or v_UpdateInfo to access additional columns like IsLatest, IsExpired, IsSuperseded, and others.

The challenge I'm facing is that while the v_configurationitems and v_UpdateInfo tables contain the CI_ID column, the v_GS_Installed_Software table only has a ResourceID column.

I thought of using the v_UpdateComplianceStatus table to join on CI_ID and then use ResourceID from that table to join with v_GS_Installed_Software. However, this approach doesn't work as expected.

Is there a straightforward way to achieve this join, or is there an alternative method to access the desired columns?