Lets Query SQL
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.
Now Available Version 1.0.1
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’)
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..
Is there a way to make the sql query read-only?
How do I get access to the SQL query analyzer in the control center?