I attached a screenshot of how it looks so far. I can't get the two columns from v_R_User to display. I've tried all combinations of Joins I can think of, but I'm missing something obvious. Here is my code:
select v_R_System.Netbios_Name0 as [Computer Name],
v_R_System.User_Name0 as [User Name],
v_R_User.Full_User_Name0 as 'Full Name',
v_R_User.manager0 as [Manager],
v_GS_SoftwareFile.FileName,
v_GS_SoftwareFile.FileVersion as [Internet Explorer Version],
v_R_System.AD_Site_Name0 as [Site Code]
FROM v_R_User
FULL JOIN v_R_System ON v_R_User.ResourceID = v_R_System.ResourceID
INNER JOIN v_GS_SoftwareFile ON v_GS_SoftwareFile.ResourceID = v_R_System.ResourceID
INNER JOIN V_RA_SYSTEM_IPAddresses ON V_RA_SYSTEM_IPAddresses.ResourceID = v_R_System.ResourceID
INNER JOIN v_GS_OPERATING_SYSTEM ON v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID
WHERE FileName = 'iexplore.exe'
Order by v_R_System.Netbios_Name0
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
I attached a screenshot of how it looks so far. I can't get the two columns from v_R_User to display. I've tried all combinations of Joins I can think of, but I'm missing something obvious. Here is my code:
Share this post
Link to post
Share on other sites