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 .

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

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

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

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