I did try to search on forums to see if i can find a way to remove duplicates from the report that i am generating in my altiris ns 6, as i'm not that proficient in SQL, wanted a minimal way to edit my exisitng query to see if it can be done..but was unable to find much in the forums...
here is sql query that i'm running -
SELECT distinct T1.[_ResourceGuid] AS 'GUID', T1.[Name] AS 'Computer Name', T3.[Serial number] AS 'Serial number', T1.[Last Logon User] AS 'User', T1.[OS Name] AS 'OS', T2.[Name] AS 'Software', T3.[Status] as 'Status', T4.[Exchange Display Name] as 'Display Name', T2.[Version] as 'Version'
FROM ([Inv_AeX_AC_Identification] T1
JOIN [Inv_AeX_OS_Add_Remove_Programs] T2
ON T1.[_ResourceGuid] = T2.[_ResourceGuid]
JOIN [vAsset] T3
on T1.[_ResourceGuid] = T3.[_ResourceGuid]
JOIN [Inv_AeX_EU_Contact_Detail] T4
on T1.[_ResourceGuid] = T4.[_ResourceGuid]
where ((T2.[name] like '%Java%'
and T2.[name] not like 'Java Auto Updater'
and T2.[Version] not like '')
--and T3.[Serial number] like '456ZF3J'
ORDER BY T1.[Name] ASC
i went through couple of posts where they spoke about using "distinct" in a specfic way, so that i can get unique results, i've learnt that the above statement would give me multiple results with reference to "GUID, Serial Number, User etc"
would appreciate if there is some way i can get rid of duplicates without much edition...