Dear. I would like to know how I can get the information that is saved in the activity tab. This information is not stored in the database but internally in the application. In which folder or files you could search.
Hello,
The iTop objects history are saved in iTop objects and as such can be queried inside iTop in OQL. As Jeffrey said they are stored in CMDBChange objects, having attached CMDBChangeOp for each fields (almost each field types has its CMDBChangeOp children class containing the appropriate data).
It's hard to tell more without knowing what you want to do ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
What I want is to consult the reassignments that a ticket has had (Group or people to whom the ticket was reassigned). It is possible to get to that detail?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, but you'll need to read it from the database. It's stored there in a structure way, but there's no nice built-in way to show the information. You'll need to take care of this.
A Combodo's extension OLA per Team does record and count time spend by each team while handling a ticket.
It does not do it by parsing the history/activity panel. It just record in a new object class between Ticket and Team, when a team has started to work on a given ticket (and how much time, but you don't care). You may do the same in an iTop extension. You may want that new Link class to allow duplicate if your idea is just to record when a Ticket was assigned to a given team, knowing that it can occur multiple times for the same team on a given Ticket.
The link creation would be a Ticket method called on a transition or multiple transitions.
Then add an AttributeLinkedSetIndirect on the Ticket class, to display in assignment date order, the teams to whom that Ticket was assigned.
Last edit: Vincent @ Combodo 2023-02-13
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Dear. I would like to know how I can get the information that is saved in the activity tab. This information is not stored in the database but internally in the application. In which folder or files you could search.
It is actually stored in the database as CMDBChangeOp (which comes with some subclasses).
In this table you can consult the reassignments i.e. the people or groups to which they were reassigned or only save the last value?
searched in this table but only find the dates, times, user and statuses.
Hello,
The iTop objects history are saved in iTop objects and as such can be queried inside iTop in OQL. As Jeffrey said they are stored in CMDBChange objects, having attached CMDBChangeOp for each fields (almost each field types has its CMDBChangeOp children class containing the appropriate data).
It's hard to tell more without knowing what you want to do ?
What I want is to consult the reassignments that a ticket has had (Group or people to whom the ticket was reassigned). It is possible to get to that detail?
Yes, but you'll need to read it from the database. It's stored there in a structure way, but there's no nice built-in way to show the information. You'll need to take care of this.
It's something which you could build upon https://github.com/jbostoen/itop-jb-report-generator/ or start from scratch.
A Combodo's extension OLA per Team does record and count time spend by each team while handling a ticket.
It does not do it by parsing the history/activity panel. It just record in a new object class between Ticket and Team, when a team has started to work on a given ticket (and how much time, but you don't care). You may do the same in an iTop extension. You may want that new Link class to allow duplicate if your idea is just to record when a Ticket was assigned to a given team, knowing that it can occur multiple times for the same team on a given Ticket.
The link creation would be a Ticket method called on a transition or multiple transitions.
Then add an AttributeLinkedSetIndirect on the Ticket class, to display in assignment date order, the teams to whom that Ticket was assigned.
Last edit: Vincent @ Combodo 2023-02-13