Log_Agent's Group stored query

[Legacy User]

I am trying to develop a stored query to list the incidents created by members of a specific group.

 

I've tried this:

(log_agent.analyst.[member]member_list.group IN (\'ServiceDesk\') AND type = \'I\') results in a bad where clause.

 

And this:

type = 'I' AND (log_agent.[member]member_list.group.id IN U'347121C59DB6B140A9961713A2F3E1BA')

(and yes that is the correct UUID)

 

Results in zero.  Being the point of contact, a majority of incidents are created by the ServiceDesk.

 

Thanks in advance!

[David Ng]

Celso,

 

Please see this tech doc:

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec532604.aspx

 

The following where clause may be considered:

log_agent.[member]member_list.group IN U\'12D91967B6A3344EB69087A240A1F5BD\')

[Grant Bruneau]

David-Ng beat me to it!

 

Here's another way to do it using group names.

log_agent.group_list.group.last_name = \'Service Desk Administration\' AND type = \'I\'

[System]

Hi CelsoA - Did David-Ng's response help answer your question? If so please mark as Correct Answer. Thanks!