ORDER BY A.DisplayName0 Prompt for creation computer: SELECT A.DisplayName0,A.InstallDate0, A.Version0,A.Publisher0įROM v_GS_ADD_REMOVE_PROGRAMS A, v_GS_COMPUTER_SYSTEM BĪND A.DisplayName0 NOT LIKE ‘Hotfix for %’ĪND A.DisplayName0 NOT LIKE ‘Security Update for %’ĪND A.DisplayName0 NOT LIKE ‘Update for Microsoft %’ĪND A.DisplayName0 NOT LIKE ‘Update for Office %’ĪND A.DisplayName0 NOT LIKE ‘Update for Outlook %’ĪND A.DisplayName0 NOT LIKE ‘Update for Windows %’ĪND A.DisplayName0 NOT LIKE ‘Windows XP Hotfix%’ĪND Name0 = BY A.DisplayName0,A.InstallDate0,A.Version0, A.Publisher0 Report to List all add and remove programs on Particular computer excludes software updates ? You can also add the prompt value to ask for application name as well.

Report to list all the computers which have particular software/application installed ?ĪND a.DisplayName0 like '%Adobe acrobat%' Below listed the basic reports to display computers with particular add and remove application installed on computers.

Instaling Solitaire JD