Job Properties
3 min
there are a number of properties that are also calculated and stored for each job in activate job properties property name description reportgroup this is the report group that the job will be reported under this defaults to the top level task name under //tasks for example, 'distribution lists', 'passwords' etc a special reportgroup of 'none' can be used to exclude the job from analytics ticketcount the total number of service desk tickets created by this request and all sub requests cost (savings) the total cost savings for this request defaults the =//job/costperjob requestcount the total number of items requested in the request (ie the number of dl's, services etc requested) totalminutes the total number of business minutes that this request took or is taking endtime starttime or now starttime if the request is still active totalapprovalminutes the total number of business minutes that the request was waiting on approvals this value is only reported if sla approval > 0 if the sla approval is 0 then it is assumed that approvals are not to be counted the value is calculated by the total wait times in an approval step less any time spent on a 'more info' request slaminutes the is maximum total of the sla approval and sla fullfilment minutes for the request and all parent requests updating properties these values are updated automatically as the requests are submitted and updated however, if you wish to change reportinggroups or other values and want to have these apply to existing requests then a script is available at //tasks/analytics/background/scripts/updatejobstatistics that can be run to re update existing jobs with the new values running requests the totalapprovalminutes and totalminutes are updated each time the job is updated via activate however, if the job is suspended these values will not change therefore the following line must be included in the overnight maintenance task // update reporting information innovation activate actions jobactionuser updatetotaltimes(datetime minvalue); this will update the totalapprovalminutes and totalminutes to the appropirate value when the script is run