Kaseya Community

Kaseya Reporting

  • Anyone out there been able to build useful reports using the DB views?

    Legacy Forum Name: Kaseya Reporting,
    Legacy Posted By Username: rvines@axcelltech.com
  • report.jpg
    rvines@axcelltech.com
    Anyone out there been able to build useful reports using the DB views?


    Yep...

    Example of our custom report is attached. Software used for reporting is SQL reporting services 2005.

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: rudi
  • Hi Rudi

    Really great job, the report looks superb.

    Well done

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: PeterS
  • How much time do you have invested in creating that report?


    rudi
    Yep...

    Example of our custom report is attached. Software used for reporting is SQL reporting services 2005.


    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: rvines@axcelltech.com
  • rvines@axcelltech.com
    How much time do you have invested in creating that report?


    It was not an easy task, there is quite a lot of logic behind it. I also had to use kaseya tables (views didn't provide all info i needed) and do some reverse engineering . With basic testing and all major development i think it took me around 5 days.

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: rudi
  • hey rudi - nice work - is your report template up for sale?

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: stuart
  • Rudi,

    How has the database changes affect your report?

    God Bless,
    Marty

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: Missing Link
  • Missing Link
    Rudi,

    How has the database changes affect your report?

    God Bless,
    Marty


    well, change from names to GUID did cause some problems and i had to change some procedures. That was the only problem, for now Smile .

    rudi

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: rudi
  • rudi
    Yep...

    Example of our custom report is attached. Software used for reporting is SQL reporting services 2005.



    Any possible way I can purchase your report?

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: richie3333
  • was this report available to download?

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: newcmi
  • Sorry, you are not going to get any reply on this one, both Rudi and I used to work for Networking Plus, and manage the Kaseya system, we have both since left.

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: sam.taylor
  • GpReport.zip
    Hi,

    We also have been working on doing some SQL reports for the better graphical reports.

    Here is the example of what we have achieved Cool

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: mnagra
  • reporting sample.jpg
    Yep. The beauty of the Kaseya Views is you can do whatever you want with the data.

    I've got a custom report to replace in a few clicks what my boss would spend an entire day on for a new client. This is done in Access using an ODBC link to the K-server.

    Some custom highlighting, such as detected server OS, virtual machine, low disk space, empty RAM slots, etc...

    Legacy Forum Name: MSP General Discussion,
    Legacy Posted By Username: dwujcik