BMC Communities Banner
Up to Discussions in Incident and Problem Process Management

This Question is Answered

2 "helpful" answers available (5 pts)
17 Replies Last post: Nov 9, 2009 10:27 AM by abdulrahman hejazi   1 2 Previous Next
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated

Nov 2, 2009 11:49 AM

Roslution Time

Dears,

 

i am trying to calculate Roslution Time (the time  between  open a tiket and solve it).

 

i  used this process (Application-Bus-Time2-Diff ) but  i get error message ( the startdate and end date is in wrong format)

 

is there ant way to do this  calculation.

 

thanks

Tags: roslution, time
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated
1. Nov 3, 2009 12:22 AM in response to: abdulrahman hejazi
Re: Roslution Time

I get this error also

 

 

ARERR [4568] The start or end time provided for the command is not valid

Report Abuse
Sonal Expert
Sonal
348 posts since
Dec 2, 2008
Currently Being Moderated
2. Nov 3, 2009 12:32 AM in response to: abdulrahman hejazi
Re: Roslution Time

Abdul,

 

Are you using the following syntax:

 

Application-Bus-Time-Diff  "<StartTime>" "<EndTime>"  "<HolidayScheduleName>" "<WorkdayScheduleName>"

 

The Start Time and EndT ime parameters are required in this command. Other fields are optional and will default if not provided.

 

I think you're just missing some double quotes in the command.

 

Hope that Helps!!

Sonal

Report Abuse
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated
3. Nov 3, 2009 12:50 AM in response to: Sonal
Re: Roslution Time

Yes i use it and there is no missing any double quotes.

 

is there any way to calculate the diffrent between RoslutionRoslution date and create date.

Report Abuse
Sonal Expert
Sonal
348 posts since
Dec 2, 2008
Currently Being Moderated
4. Nov 3, 2009 1:25 AM in response to: abdulrahman hejazi
Re: Roslution Time

If you want to take Business Time into account, then Application-Bus-Time-Diff is the only option,I know.

 

Otherwise you could use Resolution Date - Reported Date.

 

Can you post the exact run process here so that we can help.Are you using a Filter or an Active Link?

Report Abuse
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated
5. Nov 3, 2009 1:46 AM in response to: Sonal
Re: Roslution Time

this is the  run process:

 

$PROCESS$ @@:Application-Bus-Time-Diff "Modified Date""Create Date"

 

i use is on set field action on active link.

 

when i try it on run process i get on the logs Success  but i don't know where i get the result.

Report Abuse
Sonal Expert
Sonal
348 posts since
Dec 2, 2008
Currently Being Moderated
6. Nov 3, 2009 1:58 AM in response to: abdulrahman hejazi
Re: Roslution Time

Abdul,

 

Don't you think the run process should be something like:   $PROCESS$ @@:Application-Bus-Time-Diff "Create Date" "Modified Date"

 

As the syntax is: Application-Bus-Time-Diff  "<StartTime>" "<EndTime>"  and you are specifying create date as end time and modified date as start time. Also, don't forget to give the space as it is missing in your reply.

 

Set Fields in an Active Link will give you the desired results.

 

HTH,

Sonal

Report Abuse
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated
7. Nov 3, 2009 2:13 AM in response to: Sonal
Re: Roslution Time

could you please give me the write syntax depend on my last replay or example .

Report Abuse
Sonal Expert
Sonal
348 posts since
Dec 2, 2008
Currently Being Moderated
8. Nov 3, 2009 2:18 AM in response to: abdulrahman hejazi
Re: Roslution Time

$PROCESS$ @@:Application-Bus-Time2-Diff "Create Date" "Modified Date"

Report Abuse
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated
9. Nov 3, 2009 2:20 AM in response to: Sonal
Re: Roslution Time

can i use it on  run peocess or on set field process?

Report Abuse
Sonal Expert
Sonal
348 posts since
Dec 2, 2008
Currently Being Moderated
10. Nov 3, 2009 2:23 AM in response to: abdulrahman hejazi
Re: Roslution Time

Take a Time Field, use a set field action and set the calculated result in the time field.

Report Abuse
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated
11. Nov 3, 2009 2:28 AM in response to: Sonal
Re: Roslution Time

i get this error

 

ARERR [4568] The start or end time provided for the command is not valid
Set fields active link running a process failed (ARERR 1603)

Report Abuse
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated
12. Nov 3, 2009 2:47 AM in response to: abdulrahman hejazi
Re: Roslution Time

when i used run process and after check the logs

 

6: Run Process
<ACTL>             @@: 36\8\TestTime\6\3\0\1257236525\1\0\\0\\
<ACTL>             Run Process on server
<ACTL>               Server: 10.6.94.41
<ACTL>               Process: Application-Bus-Time2-Diff "Create Date" "Modified Date"
<ACTL>                  Success

 

i need to know where i can find the result on the server( i need the result on field)

Report Abuse
Sonal Expert
Sonal
348 posts since
Dec 2, 2008
Currently Being Moderated
13. Nov 3, 2009 3:39 AM in response to: abdulrahman hejazi
Re: Roslution Time

Abdul,

 

Using a Run Process action will not help in seeing the result in the field. You will have to create a Set Field Action for this.

 

Try This: Create an Integer Field ( as the difference will be in seconds).

 

Use Set Field as : $PROCESS$ @@: Application-Bus-Time2-Diff "$Create Date$" "$Modified Date$" and set it to that Integer Field.

 

NOTE: We forgot the $ sign in the syntax before.

 

HTH,

Sonal

Report Abuse
abdulrahman hejazi Participant
abdulrahman hejazi
30 posts since
Nov 2, 2009
Currently Being Moderated
14. Nov 3, 2009 4:24 AM in response to: Sonal
Re: Roslution Time

it is work now

 

and i used this function and get the same result

 

CURRSETDATE($Modified Date$, $DATE$) - CURRSETDATE($Create Date$, $DATE$)

 

 

also i need to convert the secound to HH:MM:SS?

Report Abuse
1 2 Previous Next

Advertisement

More Like This

  • Retrieving data ...