select distinct P.DisplayName0 as ProductName,
P.InstallDate0 as InstallDate,
S.Netbios_Name0 as ComputerName,
S.User_Name0 as LastUser,
S.Operating_System_Name_and0 as OperatingSystem,
S.Last_Logon_Timestamp0 as LastSeen
from [dbo].[v_Add_Remove_Programs] as P,
[dbo].[v_R_System] as S
where
S.ResourceID = P.ResourceID
and
(P.DisplayName0 like 'Microsoft Visual Studio %Premium%'
or P.DisplayName0 like 'Microsoft Visual Studio %Ultimate%'
or P.DisplayName0 like 'Microsoft Visual Studio %Professional%'
or P.DisplayName0 like 'Microsoft Visual Studio %Express%' )
and P.InstallDate0 is not null
order by S.Netbios_Name0
