If you've created a custom view that you are using for the report centre and it is not working on the report, throwing errors like: "Error loading report data" or "Error loading datasource" or maybe any error relating to permissions, then you should make sure that the name of your custom view is prefixed with a v_ otherwise you [...]
Another useful SQL snippet to post today, used to identify machines where commands are stuck executing. This usually is an indication of a problem with the LabTech service on the machine, but could also mean something more underlying is broken on the client. SELECT commands.computerid, v_computers.computer_name, v_computers.client_name, Count(*) AS NumOfCommands FROM commands LEFT JOIN v_computers ON commands.computerid = v_computers.computerid WHERE status = 2 GROUP BY computerid ORDER BY numofcommands DESC