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_Name0as[ComputerName],
v_R_System.User_Name0as[UserName],
v_R_User.Full_User_Name0as'Full Name',
v_R_User.manager0 as[Manager],
v_GS_SoftwareFile.FileName,
v_GS_SoftwareFile.FileVersionas[InternetExplorerVersion],
v_R_System.AD_Site_Name0 as[SiteCode]
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'Orderby 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