I recently had to provide this information, which I did via SQL....
MS-SQL version:
select group_name, full_name
from group_x
join user_x on (group_list like '%' + cast(group_id as varchar(50)) + ';%')
group by group_name, full_name
Regards,from group_x
join user_x on (group_list like '%' + cast(group_id as varchar(50)) + ';%')
group by group_name, full_name
Oracle version:
select group_name,
full_name
from group_x, user_x
where group_list like '%' || ltrim(rtrim(to_char(group_id))) || '%'
from group_x, user_x
where group_list like '%' || ltrim(rtrim(to_char(group_id))) || '%'
order by group_name,
full_name
Gareth
On 16/10/06, Harold Link <
[EMAIL PROTECTED]> wrote:
**
Listers,
I need a way to run a report [or populate a form] that contains a record
for each user in each group. This would be similar to the data contained
in the SHR:Assignments form in the Service Desk module, but alas, the
large company I am working for does not have the module in place. They are
using a form called Group Membership but the records are out of sync with
the User form.
For example, a sample ID in User form shows Group List as
500;1188;499;501;511;5169;510;453; [GroupIDs] but the Group Membership
shows 504;1188;500;.
This company has over 1200 groups and 6000 Remedy users, so doing this
manually is out of the picture.
Main goal was to have a table in an administrator utility form that
displays the groups that the user belongs to. The admins [these are
helpdesk and Remedy admins that only have permissions to add/modify users
and groups] would use the table to add and remove groups.
Current work around is running filters against the Group List field that
adds or removes a Group ID and this works fine for now. But would still
like to develop the table concept. I have used this in the QM module but
my current data is out of sync as mentioned above.
Hope this isn't too long....
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125_______________________This posting was submitted with HTML in it___
