Information technology service management records in a service level target database table
Information technology service management records in a service level target database table may include aggregating, at a predetermined elapsed time, a plurality of actions performed on each of a plurality of ITSM records since a prior update of an SLT database. Service level target tracking may further include identifying a portion of the plurality of aggregated actions that are applicable to an SLT database table entry corresponding to an ITSM record of the plurality of ITSM records. Service level target tracking may also include compressing, in a single operation, the portion of the plurality of aggregated actions.
1. A system for service level target (SLT) tracking comprising:
a processor; and
a non-transitory storage medium comprising instructions executable by the processor to:
aggregate, at a predetermined elapsed time since a prior update of an SLT database table comprising a plurality of entries, a plurality of actions performed on a plurality of information technology service management (ITSM) records since the prior update of the SLT database table, each entry of the SLT database comprising a first field to indicate a SLT state associated with a unique ITSM record, wherein each ITSM record is an electronic ticket created in response to a unique request to perform an information technology (IT) service task, wherein the plurality of ITSM records are distinct from the SLT database table, wherein at least two actions of the plurality of actions are dissimilar and each of the plurality of actions have a common outcome, and within the aggregated plurality of actions, the at least two dissimilar actions are each translated into a single action type that characterizes actions having the common outcome;
identify a portion of the aggregated plurality of actions, the identified portion comprising multiple actions that previously updated a first ITSM record of the plurality of ITSM records since the prior update of the SLT database table;
determine, using a state machine comprising a plurality of SLT states, an updated SLT state associated with the first ITSM record based on the multiple actions that previously updated the first ITSM record;
determine a single database operation to be performed in a first entry in the SLT database table based on the updated SLT state, wherein the first entry in the SLT database table is associated with the first ITSM record; and
perform the single database operation to update the first entry in the SLT database table to indicate the updated SLT state associated with the first ITSM record.
2. The system of claim 1 , wherein the state machine defines transitions between the plurality of SLT states based on at least some of the plurality of actions performed on the plurality of ITSM records.
3. The system of claim 1 , wherein the identified portion of the aggregated plurality of actions includes a create action that generated the first ITSM record.
4. The system of claim 1 , wherein the identified portion of the aggregated plurality of actions includes a start action that initiated a measurement of an elapsed-duration of work on the first ITSM record.
5. The system of claim 1 , wherein the identified portion of the aggregated plurality of actions includes a stop action that stopped a measurement of an elapsed-duration of work on the first ITSM record.
6. The system of claim 1 , wherein the identified portion of the aggregated plurality of actions includes a suspend action that suspended a measurement of an elapsed-duration of work on the first ITSM record.
7. The system of claim 6 , wherein the identified portion of the aggregated plurality of actions includes an unsuspended action that resumed the measurement of the elapsed-duration of the work on the first ITSM record.
8. The system of claim 1 , wherein the identified portion of the aggregated plurality of actions includes a restart action that reinitiates a measurement of an elapsed-duration of work on the first ITSM record from a zero time measurement.
9. A non-transitory computer readable medium storing instructions executable by a processing resource to:
identify, at a predetermined elapsed time since a prior update of a service level target (SLT) database table comprising a plurality of entries, a portion of a plurality of aggregated actions performed on a plurality of information technology service management (ITSM) records since the prior update of the SLT database table, wherein the identified portion of the plurality of aggregated actions comprises multiple actions that previously updated a first ITSM record of the plurality of ITSM records since the prior update of the SLT database table, each entry of the SLT database table comprising a first field to indicate a SLT state associated with a unique ITSM record, wherein each ITSM record is an electronic ticket created in response to a unique request to perform an information technology (IT) service task, wherein the plurality of ITSM records are distinct from the SLT database table, wherein at least two actions of the plurality of aggregated actions are dissimilar and each of the plurality of aggregated actions have a common outcome, and within the plurality of aggregated actions, the at least two dissimilar actions are each translated into a single action type that characterizes actions having the common outcome;
determine, using a state machine comprising a plurality of SLT states, an updated SLT state associated with the first ITSM record based on the multiple actions that previously updated the first ITSM record;
determine a single database operation to be performed in a first entry in the SLT database table based on the updated SLT state, wherein the first entry 1 s associated with the first ITSM record; and
perform the single database operation to update the first entry in the SLT database table to indicate the updated SLT state associated with the first ITSM record.
10. The non-transitory computer readable medium of claim 9 , wherein the state machine defines transitions between the plurality of SLT states based on at least some of the plurality of aggregated actions performed on the plurality of ITSM records.
11. The non-transitory computer readable medium of claim 9 , wherein the identified portion of the plurality of aggregated actions includes a stop action that stopped a measurement of an elapsed-duration of work on the first ITSM record.
12. The non-transitory computer readable medium of claim 11 , wherein the identified portion of the plurality of aggregated actions includes an unsuspend action that resumed the measurement of the elapsed-duration of the work on the first ITSM record.
13. The non-transitory computer readable medium of claim 9 , wherein the single database operation updates an elapsed duration period specified in the first entry of the SLT database table.
14. A method for service level target (SLT) tracking comprising:
aggregating, at a predetermined elapsed time since a prior update of an SLT database table comprising a plurality of entries, a plurality of actions performed on a plurality of information technology service management (ITSM) records since the prior update of the SLT database table, each entry of the SLT database comprising a first field to indicate a SLT state associated with a unique ITSM record, wherein each ITSM record is an electronic ticket created in response to a unique request to perform an information technology (IT) service task, wherein the plurality of ITSM records are distinct from the SLT database table, wherein at least two actions of the plurality of actions are dissimilar and each of the plurality of actions have a common outcome, and within the aggregated plurality of actions the at least two dissimilar actions are each translated into a single action type that characterizes actions having the common outcome;
identifying a portion of the aggregated plurality of actions, the identified portion of the aggregated plurality of actions comprising multiple actions that previously updated a first ITSM record of the plurality of ITSM records since the prior update of the SLT database table;
determining, using a state machine comprising a plurality of SLT states, an updated SLT state associated with the first ITSM record based on the multiple actions that previously updated the first ITSM record;
determining a single database operation to be performed in a first entry in the SLT database table based on the updated SLT state, wherein the first entry in the SLT database table is associated with the first ITSM record; and
performing the single database operation to update the first entry in the SLT database table to indicate the updated SLT state associated with the first ITSM record.
15. The method of claim 14 , wherein performing the single database operation updates an elapsed duration period specified in the first entry of the SLT database table.
16. The method of claim 15 , wherein performing the single database operation updates a target duration period specified in the first entry of the SLT database table.
17. The method of claim 14 , wherein a single database command is composed in a database query language.
18. The method of claim 17 , wherein the state machine defines transitions between the plurality of SLT states based on at least some of the plurality of actions performed on the plurality of ITSM records.
19. The system of claim 1 , wherein the single database operation updates an elapsed duration period specified in the first entry of the SLT database table.
20. The system of claim 1 , wherein the single database operation updates a target duration period specified in the first entry of the SLT database table.