Jump to content
Deflect

LabTech Data Dictionary

Recommended Posts

At some point in your career with LabTech you'll be forced to work directly with the database. Normally the go-to recommendation are Chris Taylor's docs at: http://labtechconsulting.com/LT-DB/index.html  however that schema hadn't been updated since 2015 with many large and small changes over the years. Also comments had been truncated leaving many cut off mid sentence?

I have two updated versions available. One is a downloadable chm file made in the same style as the official ConnectWise Manage data dictionary. I also have an online version that's nearly identical.

I recommend the chm as it has a few notable advantages. The search in the chm file can do a full search across *everything* and . That includes the code for the trigger/view/procs, etc.  Not only that but you can also pin to your favorites anything frequently used that persists. Both feature vector graphs to visually show relationships as well as the underlying code though!

I also included all core LabTech plugins so it'd be the most complete reference doc.

image.png.50286e6f1cac601c8072e0e1cb7c598f.png

Everything is drillable so you can easily explore how different objects relate to each other.

image.png.208fa522f35f85126855026ff10f3bfb.png

If you have a good writeup for any descriptions I can roll it into an updated release. Hopefully one day everything will be documented!

image.png.a9c0cb27ef4d21001fb8661d55066680.png

image.png.566315d1ad06c77b2394ceac185629e3.png

View the code for functions, procedures, views

image.png.9cf72307bc16f703093f78817be7225e.png

Example viewing a trigger after clicking on one of our related dependencies.

2019-04-17_10-47-29.png.1903d3638aa1b208f7b39bbbc06a9792.png

 

Pin frequently used Tables/Views to your favorites tab!

936939653_Pinfrequentlyusedtables-views.png.27df1d36c4736efcfa0a7b7016ac334a.png

 


I'll be updating them if anyone has any feedback or comments I can add in. Feel free to shoot me a message on here or on the LTG Slack "smeyer"


Online: LabTech Data Dictionary

Offline Docs:  LabTech 2019.4.chm  *New and improved*  You may have to unblock the file after downloading! 
 

Older Releases:
Online v12 P8 Data Dictionary

 

Edited by Deflect
Updated to the latest version! Also added a note about unblocking the file after downloading. Thanks mikejudd and Gavsto from months ago!
  • Like 3
  • Thanks 5

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...