How to get "used" lifecycles from a TcE instance

[Uday Takbhate]

Hello Guru's,

A customer environment has several Life Cycles defined. However they
only use some of them.
I want to extract report on all the Life Cycles "really" used in day-2-
day activities.

Is there a way to extract this data?

Best Regards,
Uday Takbhate

[Chris Bleill]

use sql to select distinct "GENFLOWNAME" on the PROCHIST table in operational database

Thanks,

Chris

> --
> You received this message because you are subscribed to the Google Groups "Teamcenter Enterprise Customization" group.
> To post to this group, send email to teamcenter-enterp...@googlegroups.com.
> To unsubscribe from this group, send email to teamcenter-enterprise-c...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/teamcenter-enterprise-customization?hl=en.
>

[Patton, Toby P CTR, Code 1235.2]

Hi,

First off let me say that my Team Center version is quite old, so buyer beware.

If you are comfortable with directly querying your database using database tools you could try the following SQL (my database is Oracle). This should show what processes are still active.

select distinct processname, processrev, timestampin
from prochist
where timestampout is null
order by processname, processrev

Then you can use omf to access the workflow administration browser to see what processes may no longer be in use.

Thank You,
Toby Patton
"A frequent problem with communication is the assumption it has been achieved" - source unknown

Hello Guru's,

Best Regards,
Uday Takbhate

--

[sriniva...@yahoo.com]

Did you try the life cycle metrics reports in omf?

Sent from my iPad

[Patton, Toby P CTR, Code 1235.2]

Hi,

Bare in mind that my version of Team Center is more than 10 years old. That said, I have never seen any life cycle metrics reports. Maybe I just don't know where top look.

[N Cohen]

Hi,

Do sql query on ProcHist table , get  processname  and  timestampout  from it.

Best Regards,

Nissim Cohen

2012/1/12 Patton, Toby P CTR, Code 1235.2 <toby.pa...@navy.mil>

[aniket tambat]

Hi uday..
How r u?
I think this can be done by querying from prochist table by specifying some intervals of time stamp in and time stamp out...
Regards,
Aniket

On 14 Jan 2012 05:30, "N Cohen" <haa...@gmail.com> wrote:

Hi,

Do sql query on ProcHist table , get  processname  and  timestampout  from it.

Best Regards,

Nissim Cohen

2012/1/12 Patton, Toby P CTR, Code 1235.2 <toby.pa...@navy.mil>

>
> Hi,
>
> Bare in mind that my version of Team Center is more than 10 years old. That said, I hav...

--
You received this message because you are subscribed to the Google Groups "Teamcenter Enterprise...

[Uday Takbhate]

Thank you all for the replies.

I tried the variations of the SQL query as suggested in the thread.
Using that I get all the unique LC names which has signoff history.
This output includes the sub LC's also which are getting triggered
through breakdown processes.

Is there a way to find only "top level" LC names?

Regards,
Uday Takbhate

On Jan 14, 12:52 am, aniket tambat <tambat.ani...@gmail.com> wrote:
> Hi uday..
> How r u?
> I think this can be done by querying from prochist table by specifying some
> intervals of time stamp in and time stamp out...
> Regards,
> Aniket
>

> On 14 Jan 2012 05:30, "N Cohen" <haak...@gmail.com> wrote:
>
> Hi,
>
> Do sql query on ProcHist table , get  processname  and  timestampout  from
> it.
>
> Best Regards,
>
> Nissim Cohen
>

> 2012/1/12 Patton, Toby P CTR, Code 1235.2 <toby.patton....@navy.mil>

[Chris Bleill]

Select where ProcHistLevel = '1'.

Chris