Kaseya Community

Hi,

Just wanted to share a report which may help with Service Desk Billing.

The attached SQL and Report will show all Service Desk tickets that enter the closed stage within the last day.

All you should need to do to get this report running is create the view in SQL Management Studio and replace the UnbilledRevenueByCustomer_portrait.rdl and UnbilledRevenueByCustomer_landscape.rdl files in \Kaseya\xml\Reporting\RDL\2008\ServiceBilling\ with the new ones attached.

You can then access the report in the Info Center, Reports, Service Billing, Unbilled Revenue By Customer

I have only done limited testing on this report so I can't guarantee it will work for everyone (or anyone else) but maybe it will.

Below is a sample of the output report

org Name	ref	machine	summary	resolution Note	closed datetime	Billable Minutes
Demo Org	CSN002620	desktop1	Test Ticket	Closing Ticket as an Example	11/06/2012 11:00	4

Brad

[edited by: Brad Hawkins at 3:40 PM (GMT -8) on Nov 6, 2012] Attaching new report and SQL.

SQL Query to get Scheduled Reports schedule information

Need report to out all data including timestamps for activity filtered by ticket (ticket#/id).

Kaseya Executive Summary in my PSA Client Portal

Need help creating a report to pull workstation names without a specific application installed

Summary uptime report for logged in usage

Billable Time Per Ticket Report