SELECT
c.Name0,
a.DisplayName0FROM
v_GS_ADD_REMOVE_PROGRAMS a,
v_R_System cWHERE a.ResourceID = c.ResourceID
AND a.DisplayName0 like ‘%Adobe acrobat%‘GROUP BY
c.Name0,
a.DisplayName0ORDER BY c.name0
SELECT
c.Name0,
a.DisplayName0FROM
v_GS_ADD_REMOVE_PROGRAMS a,
v_R_System cWHERE a.ResourceID = c.ResourceID
AND a.DisplayName0 like ‘%Adobe acrobat%‘GROUP BY
c.Name0,
a.DisplayName0ORDER BY c.name0
is it possible to get the user for the computer?
yes,it is possible to get user for the computer and can get it from v_r_system or v_r_user.
Thanks
Eswar