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.
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
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, "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
>
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>
Sent by: To
MAXIMO@yahoogroups.c MAXIMO@yahoogroups.com
om cc
Subject
04/25/2012 10:08 AM [MAXIMO List] Re: Inbox and
Assignments
Please respond to
MAXIMO@yahoogroups.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, "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
>
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@yahoogroups.com] On Behalf Of ggutierrez@pasadenarefining.com
Sent: April-25-12 11:55 AM
To: MAXIMO@yahoogroups.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> >
Sent by: To
MAXIMO@yahoogroups.c <mailto:MAXIMO%40yahoogroups.c> MAXIMO@yahoogroups.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>
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> , "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
>
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
>
That worked like a charm thanks for the help.
Thank You,
George Gutierrez Jr.
Maximo Administration
Pasadena Refining Systems
713.920.3908 Direct
832.473.5330 Cell
U1O2 - Chave
"Shannon Rotz"
<shannonrotz@yahoo.c
a> To
Sent by: <MAXIMO@yahoogroups.com>
MAXIMO@yahoogroups.c cc
om
Subject
RE: [MAXIMO List] Re: Inbox and
04/25/2012 06:00 PM Assignments
Please respond to
MAXIMO@yahoogroups.c
om
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
>