3 Replies Latest reply on Jan 8, 2015 3:43 AM by murali.cherukuri

Looking for some help on creating a query

debora.chapdelaine Aug 25, 2014 2:01 PM

Hello all...

I need a query that will return a list of all open process for all groups an analyst is a member of. Is this possible?

Thanks in advance!

Debora

1. Re: Looking for some help on creating a query

dmshimself Aug 25, 2014 5:46 PM (in response to debora.chapdelaine)

I'd take a look through here. There are two methods highlighted in this thread. The one produced by Tom works well and works using a slightly hacked query. The one produced by me further down in the thread is a variant of this and can be produced without such a hack.

All Incidents (Requests and IPC) for All My Groups
Like Show 0 Likes(0)

Actions
2. Re: Looking for some help on creating a query

debora.chapdelaine Aug 26, 2014 12:19 PM (in response to dmshimself)

This worked like a charm and saved me alot of work and headaches! Thank you!

Debora
Like Show 0 Likes(0)

Actions
3. Re: Looking for some help on creating a query

murali.cherukuri Jan 8, 2015 3:43 AM (in response to debora.chapdelaine)

This could be achieved by selecting the below criteria.

When creating a query with criteria, the conditions Is Within My Groups is
now available in the LANDesk Serive Desk 7.7.3. This is the one which everyone is looking and got added in the LDSD 7.7.3.

incident.current assignment.group = Is Within My Groups
Like Show 0 Likes(0)

Actions