look at each row for one of the computer names showing up twice. see what COLUMN has different values. eliminate that column
On Tue, Dec 24, 2013 at 7:21 PM, Hotmail <[email protected]> wrote: > 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.] > > > >
