LabTech Plugin – SQL Query Analyzer

On April 29, 2015, in Projects, by Cubert aka (Cube Dweller)

   Lets Query SQLsql_query-128

 

 

 

So you think your a SQL ninja? Well here is your sword!

The new SQL Query Analyzer for LabTech allows you to run SQL queries against the LabTech database directly from your LabTech control center consoles. This allows LabTech Cloud MSPs to directly query their SQL instances without the need for SQLYog or direct access to the database.

 

!!!Warning!!!
The Surgeon General has issues a warning that using this tool could cause major loss of data if not used by skilled SQL admins. Please be careful when using this tool.

Capture

 

 

 

Now Available Version 1.0.1 

download

 

 

 

 

 

 

 

4 Responses to “LabTech Plugin – SQL Query Analyzer”

  1. Robert says:

    hmm would like to use this but getting cannot find table 0 error when doing a simple

    INSERT INTO ani_power_profiles
    VALUES
    (‘1d77c431-8167-48c8-aca3-0d1260bfdf2b’,’Extended Battery Life Max run-time’)

  2. You will find that your insert worked but since it returned no data that the error you get is that the data table has a 0 index.

    to get around error until we put out an update is to add a select statement to any insert, delete or update query

    like so:

    INSERT INTO ani_power_profiles
    VALUES
    (‘1d77c431-8167-48c8-aca3-0d1260bfdf2b’,’Extended Battery Life Max run-time’); Select * from ani_power_profiles

    by adding a “;” semicolon and a generic select statement you will get a return and the queries will execute.

    When we first put this out we didn’t really expect anything but viewing data so did not put in any error checking for a zero output. and thus the error you see..

  3. Ted Stephens says:

    Is there a way to make the sql query read-only?

  4. John says:

    How do I get access to the SQL query analyzer in the control center?

Leave a Reply