1
I have a query I need to modify and can't seem to get it right, maybe someone can help. I hope
SELECT DISTINCT vrs.Netbios_Name0, vgarp.DisplayName0
FROM v_R_System vrs INNER JOIN
v_GS_ADD_REMOVE_PROGRAMS vgarp ON vrs.ResourceID = vgarp.ResourceID
WHERE (vgarp.DisplayName0 LIKE 'Adobe Acrobat 6% St%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 6% Pro%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 7.0 St%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 7.0 Pro%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 5%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 4%') OR
(vgarp.DisplayName0 LIKE 'Adobe Acrobat 3.%')
ORDER BY vrs.Netbios_Name0
Above is the query i have what I need to do is take the Netbios_Name0 results and grab all records that show up more than once. However only a portion of the Name will be the same. For example if a computer shows up as test-dt and test-lt that is a match and I need that to get that data. I hope someone understands this and can help me out.
