SQL Query To Return Add OR Remove Programs Installed On A Specified Machine

SQL Query To Return Add OR Remove Programs Installed On A Specified Machine

SQL Query:

Select

P.DisplayName0,

P.ProdId0,

P.Publisher0,

P.Version0

From v_Add_Remove_Programs P

Join v_R_System S on P.ResourceId = S.ResourceId

Where Name0 = ‘MachineName’



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