This is an extension of the original code base redesigned and optimized for better performance and greater metric integrity with the help of Kyle. Queries have been updated an extensive code overhaul completed. There's likely many, many files not in use that will be cleaned out over time in the js and css directories. This will be the intermediate solution while Admiral Spooner is completing the modular EPiCENTER solution.
Issues - Report any issues here.
- PHP v5 or higher
- Apache v2 or higher
- LabTech 2013 or higher
- MySQL views, tables, events, procedure below
- LabTech EDF's included in dbSetup.sql script
You need the appropriate table structure in place for data to be returned. Please run the dbSetup.sql script first to create the required database infrastructure.
Please contact me with questions/concerns on the SQL below
- Create four views named "v_plugin_lthc_xxxx"
- Create four tables named "plugin_lthc_xxxx"
- Create one stored procedure named "sp_plugin_UpdateScores"
- Create three scheduled events named "ev_lthcUpdate_xxxx"
- Enable global event scheduler (Please edit your my.ini!)
- Add "event_scheduler=ON" to your my.ini otherwise scores will not be updated via the events on a daily/weekly/monthly schedule
- Default location for your my.ini is "%programfiles%\MySQL\my.ini"
- Three additional EDF's on the Agent Scope tab of Clients
- Ten additional EDF's on the Health Scores Web tab of Clients
- Eight additional EDF's on the Health Scores Web tab of Computers
- Note that all data population is dependant on "Managed IT - Active" EDF being set to enabled
- Update your branding in config/branding.php to configure your company name, logo, links, etc.
- Update your database settings in config/dbconnect.php to allow connection to the LabTech database.
- Update the EDF's with your team and client specialist information.
This software is provided without any warranty of any kind. Please use at your own discretion and you're highly advised to not make it publicly available. Consider the code vulnerable as no authentication is provided. Use at your own risk!