Kaseya Community

Reporting in Kaseya 6.3

  • Sorry this is in the wrong forum, clicking new post only lets me see 5 categories and then at the bottom it says 'and 41 more' but I can't click to see the 41 more.. .

     

    I am trying to add a report in Kaseya for Antivirus (KAV) status but I'm not getting anywhere. Any time I try to add a data object relating to KAV I get this error.

    I tried to look at the online training, but it only covers Kaseya 6.2 and not 6.3.

    It is unfortunate that the new reporting function only ships with 13 reports covering less than half the categories.

    I am assuming I'm doing something wrong here but not sure where to go from here.

    There was an error generating your report. Please refer to item 272510602545231 for additional diagnostic information. There was an error during the render phase of the report generation. There was an error generating the document Copy of COMPUTER HARDWARE AUDIT REPORT There was an error generating the document Copy of COMPUTER HARDWARE AUDIT REPORT System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'ds7115e03843d7458db26dbe666aeb0777'. ---> System.Data.SqlClient.SqlException: Invalid column name 'agentGuid'. at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds) at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds) at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds) System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'ds7115e03843d7458db26dbe666aeb0777'. ---> System.Data.SqlClient.SqlException: Invalid column name 'agentGuid'. at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl

     

  • I found out how to get it in the right forum, had to navigate to that forum.

    Please ignore this thread.