Merry Christmas Community Members. J
In Spite of using Select Distinct the result comes up with same computer name multiple times (depending on the number of users who had logged in) How can I get Unique Computer Name in the output? Select DISTINCT V_R_SYSTEM.Name0 AS [Computer Name] , v_Add_Remove_Programs.DisplayName0 AS [Software Name] ,v_Add_Remove_Programs.Version0 AS [Version] ,v_Add_Remove_Programs.InstallDate0 AS [Installation Date],v_GS_SYSTEM_CONSOLE_USER.SystemConsoleUser0 AS [User], ROW_NUMBER () over (order by "DisplayName0") AS [No.] from v_R_System INNER JOIN v_GS_SYSTEM_CONSOLE_USER ON v_R_System.ResourceID = v_GS_SYSTEM_CONSOLE_USER.ResourceID left join v_Add_Remove_Programs on v_Add_Remove_Programs.ResourceID=V_R_SYSTEM.ResourceID left join v_ClientCollectionMembers on v_ClientCollectionMembers.ResourceID=V_R_SYSTEM.ResourceID where v_ClientCollectionMembers.CollectionID= @CollectionID and v_Add_Remove_Programs.DisplayName0='Symantec Endpoint Protection' order by [NO.]
