Application installation report with product code

select Name0, netbios_name0,user_name0,ProdID0 ,Displayname0, installdate0,publisher0,version0 from v_r_system
inner join v_Add_Remove_Programs
on v_Add_Remove_Programs.ResourceID=v_R_System.ResourceID

where ProdID0 = 'XXXXXXXXXXXX'

-------------------------------------------------------------------------

Select *from v_Add_Remove_Programs
where ProdID0 = 'XXXXXXXXX' and Version0 = 'XXXXXXXX'
--------------------------------------------------------------------------------

SQL Query For Windows Media Player Versions:
--------------------------------------------------

SQL Query:

Select Distinct

v_R_System.Name0,

v_GS_SoftwareFile.FileName,

v_GS_SoftwareFile.FileDescription,

v_GS_SoftwareFile.FileVersion

From v_R_System

Join v_GS_SoftwareFile on v_R_System.ResourceID = v_GS_SoftwareFile.ResourceID

Where FileName = ‘wmplayer.exe’