LabTech Plugin: Operators Dashboard
Posted on December 22, 2014
This dashboard (available from the View menu within LT), will allow you to see the statistics that are important. Additionally, you can add custom SQL queries to get additional statistics, and they are available dynamically without making any changes to the plug-in. Clicking any of the values will allow you to see the agents/tickets/alerts that make up the list so that you can take appropriate action. The blocks refresh every 5 minutes.
The zip file contains the DLL plugin as well as an SQL file. The SQL file includes 15 pre-configured blocks. They are optional, but we believe they are a good starting point. If you come up with new blocks, feel free to share them here!
Version 2.2 Changes:
-Fixed an issue with automatic update attempting to update daily, even if no new version is available
Version 2.2 Changes:
Version 2.1 Changes:
Version 2.0 Changes:
-Ability to use \n within titles to separate words to the next line (this was already available but not mentioned)
-Multiple dashboards – 10 to be exact – that can be automatically rotated (30 seconds-2 minutes) or manually selected
-Option to assign shapes to widgets: square (default), circle, triangle, hexagon and octagon
-Improved script menu (it now lists all scripts properly)
-Renamed the database table to be more in line with LT developer best practices
Version 1.8 Changes:
-Export to Excel no longer requires Excel. It will also export to a file rather than simply opening Excel.
Version 1.7 Changes:
-Officially skipped v1.6
-Updated config screen to allow simpler management of widgets
-Enabled importing/exporting widgets from/to a file
-Corrected an issue with widgets not showing up for LT10 users
-Fixed enabling/disabling widgets
Version 1.5 Changes:
-Corrected an issue with saving changes in configuration
-Corrected an issue with the refresh menu item on the dashboard
Version 1.4 Changes:
-Fixed issue with enabling/disabling blocks in cofigurationt not working (for real this time)
-Changed the way blocks are refreshed, so it’s more fluid with less delay
Version 1.3 Changes
-Bug fix that caused queries not to save properly when disabling one or more queries under the config tab
-Added right-click menu refresh to dashboard main screen
Version 1.2 Changes
-Improved performance/reliability of block queries.
-Configuration tab: Switching from one row to another will cause the row ValueQuery to be tested. If it’s good, it’s green, otherwise it’s red.
-Configuration tab: Double-clicking a color cell will bring up a dialog to allow you to choose a color.
-Configuration tab: Save function is significantly improved/faster.
-Configuration tab: When editing a cell, you will receive an error if there is a double quote used. Only single quotes (as well as escaped single quotes) should be used.
-Removed default permissions allowing anyone access update/create/delete from the plugin table for anyone that uses the plugin. I would recommend revoking permissions for users you don’t want to have access.
revoke update,create,delete on plugin_operators_dashboard from Case_Sensitive_Username
Version 1.1 changes:
-Button to check for updates under config
-Prompt to refresh the blocks when saving changes under config
-Right-click to run a script with a prompt for parameters to include
-Remembers window size when you close it and re-opens to the same size
-Export list of results to Excel
-Moved the config column descriptions to tool tip text for cleanliness