Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic SYNERGY (steve huntington)
Decrease font size
Increase font size
Topic Title: Open /Close report
Topic Summary: how to find out ...
Created On: 15-May-2005 10:06
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 15-May-2005 10:06
User is offline View Users Profile Print this message


ran eilam

Posts: 1
Joined: 10-Jan-2005

i want to know how to find out and change if needed the CR that are defined open and the one who defined closed as i want to create a graff that show total, open and closed

this is a graph of type trend analesys
Report this to a Moderator Report this to a Moderator
 17-May-2005 12:26
User is offline View Users Profile Print this message


Philipp Weißmann

Posts: 28
Joined: 12-Oct-2004

If I am in need for such a analysis, I usually write a small python script.
With python its fairly easy to do such a thing.
First lets get all changerequest
ccm query "type='problem'" -f %objectname -u
save that it into an array.
then lets get some attributes for each one:
...status
ccm attr -s crstatus objectname
...creation time
ccm attr -s create_time objectname
...completion time (if available - check status first)
ccm attr -s conclusion_date objectname

afterwards you have an objectlist of changerequest you can now sort by creation time and conclusion_date and status.

now just count (lets say you want a list since 01.01.2005) - count all entrys that have a creation_time > 01.01.2005 then for all entrys that have a creation time > 02.01.2005 and so on... For object that are in the state concluded you can read the conclusion date

Then you have perfect values for you graph!

Just put these values in an Excel Sheet or use a nice python graph generator and you have a nice clean solution.
Have fun with it,

Philipp Weißmann
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic SYNERGY forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 15:34.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.