[mssms] Adding last logged on user to query

[Brian McDonald]

Hello everyone,


I need some help adding the last logged on user to the following query. Can 
someone offer a little assist with adding this to the below? I've tried a few 
things but can't seem to get it to work.


Thank you,


Brian

SELECT     arp.DisplayName0 AS [Application Name], arp.Version0 AS [App 
Version], v_GS_COMPUTER_SYSTEM.Name0 AS [Machine Name],
                      v_GS_COMPUTER_SYSTEM.Manufacturer0 AS [Manufacturer 
Name], v_GS_COMPUTER_SYSTEM.Model0 AS [Machine Model]
FROM         v_Add_Remove_Programs AS arp INNER JOIN
                      v_GS_COMPUTER_SYSTEM ON arp.ResourceID = 
v_GS_COMPUTER_SYSTEM.ResourceID

WHERE     (arp.DisplayName0 LIKE '%Project%')

AND DisplayName0 NOT Like '%Hotfix%'

AND DisplayName0 NOT LIKE '%Security Update%'

AND DisplayName0 NOT LIKE '%Update for%'

AND DisplayName0 NOT LIKE '%SQL Server%'

AND DisplayName0 NOT LIKE '%Service Pack%'

AND DisplayName0 NOT LIKE '%CleanProject%'

AND DisplayName0 NOT LIKE '%VisualStudio%'

AND DisplayName0 NOT LIKE '%Project MUI%'

AND DisplayName0 NOT LIKE '%Project and Item%'

AND DisplayName0 NOT LIKE '%Cloud Deployment%'

AND DisplayName0 NOT LIKE '%EasyMP%'

AND DisplayName0 NOT LIKE '%Visual Studio%'

AND DisplayName0 NOT LIKE '%PrintProjects%'