Data, Reporting,
and Integration Services
for ConnectWise
Our smart, custom solutions are designed for your unique business processes and workflows.
Services
Merge and Convert
Full database merge and data conversion
We’re experts at getting data in and out of ConnectWise, seamlessly.
About
News & Blog
Passing Parameters via URL with Report Writer
I’ve had a couple of folks ask for help recently with creating custom URLs to go directly into a report. For example, you may have a workflow rule that sends the account manager an email for an expiring agreement. You want that email to attach a link to an agreement report for the same client. […]
Convert UTC Fields to Local Time
When querying the ConnectWise database, sometimes the only date field you’ll have available is UTC meaning the time returned is not user-aware and you’ll need to adjust it. Or, you may want a report to show standardized time, no matter what timezone the end user is in. To calculate the desired local time from a […]
Report all active Types/SubTypes/Items
I put together a quick SQL query a couple of weeks ago to share my list of ConnectWise Manage types/subtypes/items with a client. Yesterday, someone asked for the same thing in the CW forums so I thought I’d put together a quick blog post for anyone else out there searching for a way to build […]