Hi,
I haven't had my coffee yet, but how about that:
SELECT gr.request_id
, gr.group_name
, gr.group_id
, us.group_list
, us.computed_grp_list
FROM aradmin.group_x gr, ARADMIN.user_x us
WHERE (us.group_list LIKE CONCAT(CONCAT('%',gr.group_id),'%')
OR us.computed_grp_list LIKE CONCAT(CONCAT('%',gr.group_id),'%'))
AND us.login_name = :LOGINID;
Regards,
Michael
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Sayali Mahajan
Sent: Thursday, February 28, 2013 7:41 AM
To: [email protected]
Subject: RequestID of Remedy Group
**
Hi,
Is there a query/table to get the RequestIDs of all groups connected to a
Remedy User?
Any help will be appreciated. Thanks in advance.
Regards,
Sayali
_ARSlist: "Where the Answers Are" and have been for 20 years_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister
Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender),
Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina
Herrmann, Martin Krebs.
Aufsichtsrat: Ben Tellings (Vorsitzender)
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.
This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in
error) please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
