LabTech Vitals Dashboard

On April 16, 2014, in Projects, by Cubert aka (Cube Dweller)

Today we release the next round for the Squidworks Labtech Vitals Dashboard.

The Labtech Vitals Dashboard is a set of web pages that query the local Labtech MySql database and provides visual widgets of important data on the main display of the Labtech Support Console. We currently have 17 different widgets with 10 of them having detail views.

To install the Dashboard you will need to download and install PHP 5 for windows at PHP.net on your Labtech server. Afterwards download the SWVDB zip package and unzip to c:\inetpub\wwwroot\SWVDB. Go into this directory and find the header.php file and open it with notepad. You will need to edit the LT server address, Username and password for the LT database access to work.

Once completed you should be able to browse http://your.labtech.server/SWVDB/ and get the dashboard. Now to have the dashboard auto load in the console for everyone who uses support console go to your LT config dashboard -> Config -> Control Center and set the Initial URL Value to your tested URL from above.

Get the dashboard ->  Download SWVDB here

 

Should look like this:

SWVDB-setup

Widgets:

Systems Missing AntiVirus application

SWVDB-missingAV

 

 

 

Agents missing patches

SWVDB-missingpatch

 

 

 

 

Agents Online

SWVDB-oflinesystems

 

 

 

Offline Servers Alarms

SWVDB-offlineservers

 

 

 

 

 

 

Dell Appassure 5 Backup Core Monitor

SWVDB-appassurebackups

 

 

 

ESX Hardware Health Monitor

SWVDB-ESXHardwareHealth

 

 

 

Hitman Pro Monitor

SWVDB-hitmanpro

 

 

 

Agent Monitors

SWVDBnopatch

 

 

 

 

 

ESX Monitor Details Page (Failed/Missing/All)

SWVDB-esx details

 

 

 

 

 

 

 

 

 

 

Dell Appassure Monitor Details (Completed and Failed)

SWVDB-appassure-details

 

 

 

 

 

 

Some widgets may not function correctly if you are not using the source data tables and extra monitor scripting I’ve made available like the Squidworks ESXi Health Monitor for Labtech located at ESX Health Monitor, The Dell Appassure Backups/Failures also requires my Appassure Backup Scripting to populate the database with data. You must edit the index.php page in notepad and uncomment the 5 function calls noted in index.php for ESX and Appassure counters to function. They have been commented out so that you do not get errors if tables are missing. Install both ESX and Appassure packages before uncommenting code block.

 

 

Enjoy

Cubert  😎

Tagged with:
 

14 Responses to “LabTech Vitals Dashboard”

  1. Ian Murphy says:

    It would be a good idea to indicate which PHP options you require as the php installation asks questions I have no idea how I should be answering.

  2. Eric says:

    Hello The AppAssure Scripts are not available the page comes back 404 not found.

    Could you provide them?
    and could you tell me how to implement them as well?

    We are just starting with lab tech and AppAssure and any help would be appreacated

  3. I have not officially released the Appassure Scripts yet. I will get those out in my next post.

  4. Ian Murphy says:

    To avoid more problems/requests of this type maybe it would be a good idea to check if the appassure stuff is installed and just return nothing if its not. Its going to be pretty likely other people will install this without having (or needing) appassure scripts.

  5. Travis Phipps says:

    First off, THIS IS AWESOME! Thanks for sharing.
    Several years ago I worked as a PHP developer for 4-5 years. So I’m very comfortable (but very rusty) getting around in PHP. Something I noticed in the code was that you were connecting to the database multiple times (once per function call) and the page load times on my system were anywhere from 12 to 20 seconds. So I hacked on the code a bit and changed it to use a single DB connection and pass that into each function, then do a mysql_close() in the footer.php file. Now my page load times are consistently just over 1 second.

    I’d be happy to share some of my tweaks back with you and others. Would you consider hosting this on github or similar to allow others to contribute to the code for everyone’s benefit?

  6. I agree with Ian, a little more help on how to install/config PHP for us non-PHP guys would be helpful. I’m not sure what I should be doing, but would love to see this tool in action. Thanks.

  7. Ewan says:

    Been playing around with your instruction for a few minutes and I can’t get the page to open correctly. PHP 5 is been installed, SWVDB file is in the wwwroot directory. But when I browse http://your.labtech.server/SWVDB/, I only get a list of files in the Directory:

    [To Parent Directory]
    11/28/2013 4:04 AM 4703 alerts.php
    4/16/2014 10:26 AM 1947 appassure.php
    2/8/2014 4:21 AM 1192 AV.php
    4/17/2014 11:47 PM 3255 ESXDetail.php
    10/7/2013 5:58 AM 39 footer.php
    5/1/2014 9:54 AM 810 header.php
    10/9/2013 11:35 AM 3528 hitmanpro.php
    4/17/2014 11:49 PM 5863 index.php
    10/8/2013 1:35 AM 2112 Install.txt.txt
    4/17/2014 11:44 PM 54622 labtech.php
    10/7/2013 5:30 AM 21173 logo.png
    10/23/2013 1:01 AM 2057 missinghotfix.php
    10/3/2013 1:33 PM 1089 red-arrow.gif
    10/9/2013 11:59 AM 1013 style.css
    10/3/2013 7:26 AM 6372 virus-alarm.png

    Am I missing some setting here?

  8. Travis Phipps,

    That would be great, If you would like to collaborate and setup a repo to store the updates then sure lets get people in making tweaks and additions.

    Jeffery,

    No problem’s
    I would make a how-to for you but there are so many on the web already that I will just link you to a few.

    #1 http://www.howtogeek.com/50432/how-to-install-php-on-iis-7-for-windows-server-2008/

    #2 https://www.youtube.com/watch?v=9o7wNd4wO0U

    #3 http://php.iis.net/

    Evan,
    Looks like Windows is not setup yet to push *.php files to the php interpreter. Make sure ISAPI is pointing .php to C:\php\php.exe or where ever you installed it to. Next make sure there is a “default page” set to use index.php as a page type.

    if you go here does page load anyway?(calling index page in URL)
    http://your.labtech.server/SWVDB/index.php

    if you get an error then PHP is not setup correctly in Windows IIS.

    Take a look at the links above and make sure PHP is working on your site.

  9. Thanks for the information. I have PHP installed successfully and ran the test which produces a proper PHP Information page (all based on the first link you provided on installation of PHP). Now when opening https://my.rmm.com/swvdb after modifying the labtech.php I get a blank page. Did I miss something?

    I’m running PHP Versions 5.2.28 if that matters. Thanks.

    Jeff

  10. I meant to say edited the header.php

  11. Travis Phipps says:

    So this is my first attempt at Github. Hope I started this off right.
    https://github.com/tlphipps/LabTech_Vitals_Dashboard

    For now it’s just a fresh copy of the original files as provided by Cubert above. Once I get some time I’ll merge in my updates for optimizing the DB connections.

    If you have any PHP coding skills or heck, even if you don’t, feel free to jump in and let’s see what we can come up with together!

  12. Ben says:

    Just a special note, you dont want this php file sitting on public IIS, plus direct access to your LT DB. If you dont want to enable Basic auth, you can do IP restriction filtering on the sub-folder only in IIS. Works great w/o dealing with passwords. We work alot from multiple locations, so that helped alot on the WAN.

  13. Phall says:

    Spin a nix vm and run on sandboxes nic with apache web server.
    My question is where is the updated .php file? And also, any chance on a refresh using Dashing?

  14. Ok…so this is my second and third attempt to get this installed and working and no luck. I’ve got PHP 5.5.18 installed to C:\PHP, copied my php-production.ini file to c:\windows as php.ini, modified as specified, copied the SWVDB folder to c:\inetpub\wwwroot as specified, changed the header.php file, installed FastCGI and configured as specified, and still cannot get this to work.

    I keep receiving HTTP Error 500.0 – Internal Server Error
    C:\PHP\php-cgi.exe – The FastCGI process exited unexpectedly.

    I have reviewed a dozen times, followed all the suggestions and nothing. Anyone have any suggestions on how to get this resolved?
    Thanks.

Leave a Reply