Kaseya Community

Home » Discussion Forums » Service Desk » time a ticket was on a stage

Learn more about how AuthAnvil can protect and enhance your Kaseya experience

Similar Posts

How to get the Ticket's Description Field into a variable in Stage Entry procedure?

by
on May 23, 2011

Stage Entry/Exit

by
on Oct 18, 2012

kaseya agentMon in "Stopping" mode

by
on Feb 19, 2014

Service Automation - Service Desks

by
on May 2, 2012

Ticket De-Duplication (Event ID 6008, 1001, 41)

by
on Feb 11, 2013
  • Verified Answer
Details
  • 20 Replies
  • 3 Subscribers
  • Postedover 6 years ago

time a ticket was on a stage

This question is not answered
Clairo Dorneles
Posted by
on Apr 30, 2013 12:13 PM 
Hello Community!

Assumed implementation of SD Kaseya and need know if it is possible to know the time a ticket was on a stage?
All Replies
  • Clairo Dorneles
    Posted by
    on May 16, 2013 9:31 PM

    Hi Paul

    Kaseya 6.2 and SD 1.3.

    Ok. 

    I had already created three two datetime type and a string to get the value!
  • Clairo Dorneles
    Posted by
    on May 17, 2013 7:36 PM

    Paul,

    I did the following test on the "Change Procedure", enter the following commands:

    <?xml version="1.0" encoding="utf-8"?>
    <ScriptExport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.kaseya.com/vsa/2008/12/Scripting">
      <Procedure name="Mudanca" treePres="15" id="48106846800062319792904803" folderId="51881614423121235561692251">
        <Body description="">
          <If isDisabled="false" description="">
            <Condition name="TestCustomField">
              <Parameter xsi:type="StringParameter" name="PropertyName" value="StartTime" />
              <Parameter xsi:type="ListParameter" name="Condition" value="Exists" />
              <Parameter xsi:type="StringParameter" name="Value" value="" />
            </Condition>
            <Then>
              <Statement isDisabled="false" description="Execute the given command as if it were typed in at a command prompt." name="ExecuteShellCommandEx" continueOnFail="false" osType="">
                <Parameter xsi:type="StringParameter" name="Command" value="echo %date%" />
                <Parameter xsi:type="BooleanParameter" name="WaitForCompletion" value="false" />
                <Parameter xsi:type="BooleanParameter" name="RedirectToLog" value="false" />
                <Parameter xsi:type="StringParameter" name="OutputFile" value="" />
                <Parameter xsi:type="StringParameter" name="OutputVariable" value="currentdate" />
              </Statement>
              <Statement isDisabled="false" description="Execute the given command as if it were typed in at a command prompt." name="ExecuteShellCommandEx" continueOnFail="false" osType="">
                <Parameter xsi:type="StringParameter" name="Command" value=" time /t" />
                <Parameter xsi:type="BooleanParameter" name="WaitForCompletion" value="false" />
                <Parameter xsi:type="BooleanParameter" name="RedirectToLog" value="false" />
                <Parameter xsi:type="StringParameter" name="OutputFile" value="" />
                <Parameter xsi:type="StringParameter" name="OutputVariable" value="currenttime" />
              </Statement>
              <Statement isDisabled="false" description="Assigns a value to a custom field of the ticket." name="AssignCustomProperty" continueOnFail="false" osType="">
                <Parameter xsi:type="StringParameter" name="PropertyName" value="EndTime" />
                <Parameter xsi:type="StringParameter" name="Value" value="[=currentdate=] [=currenttime=]" />
              </Statement>
              <Statement isDisabled="false" description="Create a named script variable and assign a value." name="GetVariable" continueOnFail="false" osType="">
                <Parameter xsi:type="StringParameter" name="VariableName" value="end" />
                <Parameter xsi:type="ListParameter" name="VariableType" value="ConstantValue" />
                <Parameter xsi:type="StringParameter" name="SourceContent" value="[$EndTime$]" />
              </Statement>
              <Statement isDisabled="false" description="Create a named script variable and assign a value." name="GetVariable" continueOnFail="false" osType="">
                <Parameter xsi:type="StringParameter" name="VariableName" value="start" />
                <Parameter xsi:type="ListParameter" name="VariableType" value="ConstantValue" />
                <Parameter xsi:type="StringParameter" name="SourceContent" value="[$StartTime$]" />
              </Statement>
              <Statement isDisabled="false" description="Execute a SQL command that returns data." name="ExecuteSqlQuery" continueOnFail="false" osType="">
                <Parameter xsi:type="StringParameter" name="Sql" value="select DATEDIFF (d, '[=start=]' ,  '[=end=]' )" />
                <Parameter xsi:type="StringParameter" name="VariableName" value="[=result=]" />
              </Statement>
              <Statement isDisabled="false" description="Assigns a value to a custom field of the ticket." name="AssignCustomProperty" continueOnFail="false" osType="">
                <Parameter xsi:type="StringParameter" name="PropertyName" value="Duracao" />
                <Parameter xsi:type="StringParameter" name="Value" value="[=result=]" />
              </Statement>
            </Then>
          </If>
        </Body>
      </Procedure>
    </ScriptExport>

    The error is happening that appears in the picture below.
  • Paul Haaker
    Posted by
    on May 17, 2013 9:16 PM

    Can you post examples of what the field value are

    I wonder if Echo %date%  output is in the wrong format for the datediff SQL command

    What version of SQL are you using

    If you google the error it sounds like a common issue

    social.msdn.microsoft.com/.../78d3989a-8975-4930-998d-1eb907966f57

    And do you have any other SQL commands that work ok
  • Clairo Dorneles
    Posted by
    on May 17, 2013 9:35 PM

    Paul,

    This was my first time using sql commands to get data in Kaseya! There is some stuff about how the Kaseya and SQL work together!

    That command to get the date returned with error, I found the% date% to get the date.

    when I do a datediff in sql, I use single quotes in the variables I noticed that the command that you do not you put me enivou, returning this error:

    Error processing procedure sbo_treePresNoteProcedures_List Mudanca

    Error processing Kaseya.Scripting.Statements.ThenToken

    Error executing SQL command 'select DATEDIFF (' d ', 12/05/2013 15:14:17, 17/05/2013 15:22:00)'

    Incorrect syntax near '15 '.
  • Paul Haaker
    Posted by
    on May 17, 2013 9:58 PM

    But doesn't Echo %Date% output the result as "Fri 17/05/2013"

    I'm pretty sure Datediff needs the date to be in the format as just "17/05/2013"  ie without the 'Fri" at the start