Kaseya Community

Home » Discussion Forums » Service Desk » Accessing KSubscribers views from Service Desk Sub-Procedures

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

Similar Posts

Service Desk - Error when Delete Sub Procedures

by
on Mar 12, 2015
  • Not Answered

Using Managed Variables in Service Desk Sub-Procedures

by
on Jun 29, 2012
  • Not Answered

Service Desk - Procedure - Variable Accessible??

by
on Aug 11, 2011
  • Suggested Answer

Database view variables in Service desk procedures

by
on Oct 17, 2013

Service Desk View Variables

by
on Mar 28, 2012
  • Not Answered
Details
  • 4 Replies
  • 2 Subscribers
  • Postedover 8 years ago

Accessing KSubscribers views from Service Desk Sub-Procedures

  • Simon Burbidge
    Posted by
    on Jul 31, 2012 10:29 AM

    I'm currently having difficulties in getting anything out of "Execute SQL Select Query" from a SQL view in sub-procedures.

    I'd like to check when the machine was last rebooted - the [ksubscribers].[dbo].[vAgents_AgentStatus] view seems to show this information, but I get nothing whenever I put "vAgents_AgentStatus" in a sub-procedure.

    On a similar note - how is everyone debugging/troubleshooting these scripts? There seems to be very little way of discovering why procedure steps are failing... (and by little, I mean even less than with Standard Agent Procedures).
  • Paul Haaker
    Posted by
    on Jul 31, 2012 10:40 AM

    Hi Simon

    Can you post the actual SQL Query line and I'll have a look tomorrow as some of my appointments seem to have been postponed  :-)

    I've found it very finicky re being case sensitive , and the online help has the wrong case used in some of the examples

    For debugging you should be getting a message in your Info Centre Inbox , but you can also enable Application logging via the System menu

    Cheers

    Paul
  • Paul Haaker
    Posted by
    on Jul 31, 2012 11:07 AM

    Something like this I presume ?

    select reboottime from [ksubscribers].[dbo].[vAgents_AgentStatus] where Expr2 = '[$Machine$]' + '.' + '[$MachineGroup$]'
  • Simon Burbidge
    Posted by
    on Aug 1, 2012 1:19 AM

    What I'm currently trying to use is:

    SELECT rebootTime from vAgents_AgentStatus WHERE agentGuidStr=[$AgentGuid$]

    The column headers are in the case that they appear in the DB.

    So, do you think I should be using:

    SELECT rebootTime from [ksubscribers].[dbo].[vAgents_AgentStatus] WHERE agentGuidStr=[$AgentGuid$]
  • Simon Burbidge
    Posted by
    on Aug 10, 2012 3:35 AM

    This is what worked in the end:

    I set the variable "lastReboot" to the results of the following query:

    SELECT rebootTime from [ksubscribers].[dbo].[vAgents_AgentStatus] WHERE agentGuidStr=[$AgentGuid$]

    Then, I set the variable "dateDiff" with the results of this query that finds the difference between the date/time of the last reboot, and the date/time the ticket was created:

    SET DATEFORMAT dmy; SELECT DATEDIFF(n, '[=lastReboot=]', '[$CreateDateTime$]')

    A negative result means that the system has been rebooted more recently than the ticket was created - the "Reboot Required" ticket can therefore be closed.