1 Reply Latest reply on Aug 31, 2015 8:52 AM by Mroche

    sql query  for the Reports

    Rookie

      Can Anyone provide me a sql query for the Reports as i Need  to generate the Weekly/Monthly reports for the  Tickets opened(Incident or Request) for 5+ days (10/20/30/40), per group, per day, per Analyst

        • 1. Re: sql query  for the Reports
          Mroche SupportEmployee

          Some out of the box Crystal Reports are provided with ServiceDesk that you could modify to retrieve the data you require.  The reports are located in your Service Desk Installation folder under c:\program files (x86)\Landesk\ServiceDesk\Reports\Landesk language.