This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Thx ill try it in the morning and let you know.
The sender of this message is responsible for its content and addressing. Any actions not conforming to Petrobras System internal policies are forbidden.
----- Original Message -----
From: "Shannon Rotz" [shannonrotz@yahoo.ca]
Sent: 04/25/2012 04:00 PM MST
To: <MAXIMO@yahoogroups.com>
Subject: RE: [MAXIMO List] Re: Inbox and Assignments
Whoops, sorry! That should be:
select * from wfassignment where wfid <> 0 and assignstatus = 'ACTIVE' and assigncode = ‘{your user’s person id}’
and wfid in (select wfid from wfinstance where active = 0)
If you want to zero in on just the one person. Although it might be interesting to run the original statement anyway.
Shannon
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of Shannon Rotz
Sent: April-25-12 3:31 PM
To: MAXIMO@yahoogroups.com
Subject: RE: [MAXIMO List] Re: Inbox and Assignments
Hi George: he could have more than 1 assignment for the same workflow set, I suppose (although he shouldn’t). Just for curiosity, try this query against the database:
select * from wfassignment where wfid <> 0 and assignstatus = 'ACTIVE'
and wfid in (select wfid from wfinstance where active = 0)
You shouldn’t get any results. If you do, the user has some “left over’ assignments for workflow threads that are now inactive. If that happens, it actually might make your cleanup job easier, though!
Shannon
From: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> [mailto:MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> ] On Behalf Of ggutierrez@pasadenarefining.com <mailto:ggutierrez%40pasadenarefining.com>
Sent: April-25-12 11:55 AM
To: MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com>
Subject: Re: [MAXIMO List] Re: Inbox and Assignments
I went Go To --> Configuration --> Workflow --> Workflow Administration and
I'm only showing 2871 records that are active?
The end user still shows 9500 in their inbox.
Thank You,
George Gutierrez Jr.
Maximo Administration
Pasadena Refining Systems
713.920.3908 Direct
832.473.5330 Cell
U1O2 - Chave
"Travis Herron"
<therron@pcci.edu <mailto:therron%40pcci.edu> <mailto:therron%40pcci.edu> >
Sent by: To
MAXIMO@yahoogroups.c <mailto:MAXIMO%40yahoogroups.c> <mailto:MAXIMO%40yahoogroups.c> MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com>
om cc
Subject
04/25/2012 10:08 AM [MAXIMO List] Re: Inbox and
Assignments
Please respond to
MAXIMO@yahoogroups.c <mailto:MAXIMO%40yahoogroups.c> <mailto:MAXIMO%40yahoogroups.c>
om
Go To --> Configuration --> Workflow --> Workflow Administration
Then search by Assigned Person Code (his Maximo user ID).
Then you can reassign them or stop the workflow. Unfortunately that's going
to be a one-record-at-a-time procedure (unless you want to try something
from the backend).
Travis Herron
--- In MAXIMO@yahoogroups.com <mailto:MAXIMO%40yahoogroups.com> <mailto:MAXIMO%40yahoogroups.com> , "George" <ggutierrez@...> wrote:
>
> Hello everyone,
> I have a user who has 9500 items in their inbox/assignments. How do I go
about to view what they are and how can I remove them from the inbox?
>
> Hope this is an easy fix.
>
> Maximo 6.2.1
> Weblogic
> SQL Server 2005
>
> thx,
> mrggutz
>