Particular ( Machine wise ) machine software installed report

Particular ( Machine wise )  machine software installed report :-


SELECT DISTINCT
  v_R_System.Netbios_Name0 AS "Machine Name",
  v_r_system.User_Name0,
  ARP.DisplayName0 AS"Product Name",
  ARP.Version0 AS"Version" ,
  ARP.InstallDate0 AS"Installation Date",
  ARP.ProdID0 AS"Product ID",
 ARP.Publisher0 AS"Publisher",
v_r_system.Last_Logon_Timestamp0
FROM  v_R_System
  JOIN v_GS_ADD_REMOVE_PROGRAMS ARP on v_R_System.ResourceID = ARP.ResourceID
  JOIN v_FullCollectionMembership on v_R_System.ResourceID = v_FullCollectionMembership.ResourceID
 
                WHERE
  v_R_System.Netbios_Name0 IN ('USWSTLUSX37806')  
AND ARP.DisplayName0 NOT LIKE 'Hotfix for %'
AND ARP.DisplayName0 NOT LIKE 'Security Update for %'
AND ARP.DisplayName0 NOT LIKE 'Update for Microsoft %'
AND ARP.DisplayName0 NOT LIKE 'Update for Office %'
AND ARP.DisplayName0 NOT LIKE 'Update for Outlook %'
AND ARP.DisplayName0 NOT LIKE 'Update for Windows %'
AND ARP.DisplayName0 NOT LIKE 'Windows XP Hotfix%'
AND ARP.DisplayName0 NOT LIKE 'Hotfix%'
ORDER BY v_R_System.Netbios_Name0