Download Microsoft Query For Mac
Microsoft access mac free download - Microsoft Virtual PC for Mac 7.0.3 Update, Microsoft Virtual PC for Mac Update, Parallels Desktop for Mac, and many more programs. Microsoft Query X for. Enable Power Query Excel add-in for Mac/Apple/iOS. You are giving your consent to Microsoft for the Power BI newsletter program to provide you the exclusive news, surveys, tips and advice and other information for getting the most out of Power BI. Whether you are on the go or need to create rich, interactive reports, Power BI. Jul 30, 2017 Download the (free) Docker Community Edition for Mac (unless you’ve already got it installed on your system). This will enable you to run SQL Server from within a Docker container. To download, visit the Docker CE for Mac download page and click Get Docker. Software Download. Software Download. Software Download. Our website provides a free download of Microsoft Query 1.0 for Mac. The program belongs to Business Tools. The most popular version among Microsoft Query for Mac users is 1.0. The actual developer of this free software for Mac is Microsoft Corporation. The unique ID for this app's bundle is com.microsoft.Query.
Here I’ll show you how to get SQL Server up and running on your Mac in less than half an hour. And the best part is, you’ll have SQL Server running locally without needing any virtualization software.
Prior to SQL Server 2017, if you wanted to run SQL Server on your Mac, you first had to create a virtual machine (using VirtualBox, Parallels Desktop, VMware Fusion, or Bootcamp), then install Windows onto that VM, then finally SQL Server. This is still a valid option depending on your requirements (here’s how to install SQL Server on a Mac with VirtualBox if you’d like to try that method).
Starting with SQL Server 2017, you can now install SQL Server directly on to a Linux machine. And because macOS is Unix based (and Linux is Unix based), you can run SQL Server for Linux on your Mac. The way to do this is to run SQL Server on Docker.
So let’s go ahead and install Docker. Then we’ll download and install SQL Server.
Microsoft Mac Software
Install Docker
Download the (free) Docker Community Edition for Mac (unless you’ve already got it installed on your system). This will enable you to run SQL Server from within a Docker container.
To download, visit the Docker CE for Mac download page and click Get Docker.
To install, double-click on the .dmg file and then drag the Docker.app icon to your Application folder.
What is Docker?
Docker is a platform that enables software to run in its own isolated environment. SQL Server (from 2017) can be run on Docker in its own isolated container. Once Docker is installed, you simply download — or “pull” — the SQL Server on Linux Docker Image to your Mac, then run it as a Docker container. This container is an isolated environment that contains everything SQL Server needs to run.
Launch Docker
Launch Docker the same way you’d launch any other application (eg, via the Applications folder, the Launchpad, etc).
When you open Docker, you might be prompted for your password so that Docker can install its networking components and links to the Docker apps. Go ahead and provide your password, as Docker needs this to run.
Increase the Memory
By default, Docker will have 2GB of memory allocated to it. SQL Server needs at least 3.25GB. To be safe, increase it to 4GB if you can.
To do this:
- Select Preferences from the little Docker icon in the top menu
- Slide the memory slider up to at least 4GB
- Click Apply & Restart
Download SQL Server
Now that Docker is installed and its memory has been increased, we can download and install SQL Server for Linux.
Open a Terminal window and run the following command.
This downloads the latest SQL Server 2019 for Linux Docker image to your computer.
You can also check for the latest container version on the Docker website if you wish.
Update: When I first wrote this article, I used the following image:
Which downloaded SQL Server 2017. Therefore, the examples below reflect that version.
Launch the Docker Image
Run the following command to launch an instance of the Docker image you just downloaded:
But of course, use your own name and password. Also, if you downloaded a different Docker image, replace
microsoft/mssql-server-linuxwith the one you downloaded.Here’s an explanation of the parameters:
-d- This optional parameter launches the Docker container in daemon mode. This means that it runs in the background and doesn’t need its own Terminal window open. You can omit this parameter to have the container run in its own Terminal window.
--name sql_server_demo- Another optional parameter. This parameter allows you to name the container. This can be handy when stopping and starting your container from the Terminal.
-e 'ACCEPT_EULA=Y'- The
Yshows that you agree with the EULA (End User Licence Agreement). This is required in order to have SQL Server for Linux run on your Mac. -e 'SA_PASSWORD=reallyStrongPwd123'- Required parameter that sets the
sadatabase password. -p 1433:1433- This maps the local port 1433 to port 1433 on the container. This is the default TCP port that SQL Server uses to listen for connections.
microsoft/mssql-server-linux- This tells Docker which image to use. If you downloaded a different one, use it instead.
Password Strength
If you get the following error at this step, try again, but with a stronger password.
I received this error when using
reallyStrongPwdas the password (but of course, it’s not a really strong password!). I was able to overcome this by adding some numbers to the end. However, if it wasn’t just a demo I’d definitely make it stronger than a few dictionary words and numbers.Check the Docker container (optional)
You can type the following command to check that the Docker container is running.
If it’s up and running, it should return something like this:
Install sql-cli (unless already installed)
Run the following command to install the sql-cli command line tool. This tool allows you to run queries and other commands against your SQL Server instance.
This assumes you have NodeJs installed. If you don’t, download it from Nodejs.org first. Installing NodeJs will automatically install npm which is what we use in this command to install sql-cli.
Permissions Error?
If you get an error, and part of it reads something like
Please try running this command again as root/Administrator
, try again, but this time prependsudoto your command:Connect to SQL Server
Now that sql-cli is installed, we can start working with SQL Server via the Terminal window on our Mac.
Connect to SQL Server using the
mssqlcommand, followed by the username and password parameters.Mac and microsoft silverlight. You should see something like this:
Alternative to microsoft word editor for mac. This means you’ve successfully connected to your instance of SQL Server.
Run a Quick Test
Run a quick test to check that SQL Server is up and running and you can query it.
For example, you can run the following command to see which version of SQL Server your running:
If it’s running, you should see something like this (but of course, this will depend on which version you’re running):
If you see a message like this, congratulations — SQL Server is now up and running on your Mac!
A SQL Server GUI for your Mac – Azure Data Studio
Azure Data Studio (formerly SQL Operations Studio) is a free GUI management tool that you can use to manage SQL Server on your Mac. You can use it to create and manage databases, write queries, backup and restore databases, and more.
Azure Data Studio is available on Windows, Mac and Linux.
Here are some articles/tutorials I’ve written for Azure Data Studio:
Another Free SQL Server GUI – DBeaver
Another SQL Server GUI tool that you can use on your Mac (and Windows/Linux/Solaris) is DBeaver.
DBeaver is a free, open source database management tool that can be used on most database management systems (such as MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, Microsoft Access, Teradata, Firebird, Derby, and more).
DBeaver using the “Dark” theme.
I wrote a little introduction to DBeaver, or you can go straight to the DBeaver download page and try it out with your new SQL Server installation.
Limitations of SQL Server for Linux/Mac
SQL Server 2017 for Linux does have some limitations (at least, in its initial release). The Linux release doesn’t include many of the extra services that are available in the Windows release, such as Analysis Services, Reporting Services, etc. Here’s a list of what’s available and what’s not on SQL Server 2017 for Linux.
Another limitation is that SQL Server Management Studio is not available on Mac or Linux. SSMS a full-blown GUI management for SQL Server, and it provides many more features than Azure Data Studio and DBeaver (at least at the time of writing). You can still use SSMS on a Windows machine to connect to SQL Server on a Linux or Mac machine, but you just can’t install it locally on the Linux or Mac machine.
If you need any of the features not supported in SQL Server for Linux, you’ll need SQL Server for Windows. However, you can still run SQL Server for Windows on your Mac by using virtualization software. Here’s how to install SQL Server for Windows on a Mac using VirtualBox.
-->Kusto.Explorer is a rich desktop application that allows you to explore your data using Kusto query language.
Getting the tool
Install the Kusto.Explorer tool
Alternatively, access your Kusto cluster with your browser at:https://<your_cluster>.kusto.windows.net. Replace <your_cluster> with your Azure Data Explorer cluster name.
Using Chrome and Kusto.Explorer
If you use Chrome as your default browser, make sure to install the ClickOnce extension for Chrome:
Overview of the user experience
Kusto Explorer window has several UI parts:
- Script panel
- Results panel
Keyboard shortcuts
You might find that using keyboard shortcuts enables you to perform operations faster than with the mouse. Take a look at this list of Kusto.Explorer keyboard shortcuts.
Menu panel
Kusto.Explorer Menu panel includes the following tabs:
Home tab
The Home tab shows the most recently used functions, divided into sections:
Query section
| Menu | Behavior |
|---|---|
| Mode dropdown |
|
| New Tab | Opens a new tab for querying Kusto |
Share section
| Menu | Behavior |
|---|---|
| Data To Clipboard | Exports Query and data set to a clipboard. If a chart is presented, it exports the chart as bitmap |
| Result To Clipboard | Exports the data set to a clipboard. If a chart is presented, it exports the chart as bitmap |
| Query to Clipboard | Exports the Query to a clipboard |
Visualizations section
| Menu | Behavior |
|---|---|
| Area chart | Displays an area chart in which the X-axis is the first column (must be numeric) and all numeric columns are mapped to different series (Y-axis) |
| Column Chart | Displays a column chart where all numeric columns are mapped to different series (Y-axis) and the text column before numeric is the X-axis (can be controlled in the UI) |
| Bar Chart | Displays a bar chart where all numeric columns are mapped to different series (X-axis) and the text column before numeric is the Y-axis (can be controlled in the UI) |
| Stacked Area chart | Displays a stacked area chart in which the X-axis is the first column (must be numeric) and all numeric columns are mapped to different series (Y-axis) |
| Timeline Chart | Displays a time chart in which the X-axis is the first column (must be datetime) and all numeric columns are mapped to different series (Y-axis). |
| Line Chart | Displays a line chart in which the X-axis is the first column (must be numeric) and all numeric columns are mapped to different series (Y-axis). |
| Anomaly Chart | Similar to timechart, but finds anomalies in time series data, using the machine learning anomalies algorithm. For anomaly detection, Kusto.Explorer uses the series_decompose_anomalies function.(*) |
| Pie Chart | Displays a pie chart in which the color-axis is the first column and the theta-axis (must be a measure, converted to percent) is the second column. |
| Ladder Chart | Displays a ladder chart in which the X-axis is the last two columns (must be datetime) and the Y-axis is a composite of the other columns. |
| Scatter Chart | Displays a point graph in which the X-axis is the first column (must be numeric) and all numeric columns are mapped to different series (Y-axis). |
| Pivot Chart | Displaya a pivot table and pivot chart that gives the full flexibility of selecting data, columns, rows and various chart types. |
| Time Pivot | Interactive navigation over the events time-line (pivoting on time axis) |
(*) Anomaly Chart:The algorithm expects timeseries data, which consists of two columns:
- Time in fixed interval buckets
- Numeric value for anomaly detectionTo produce this in Kusto.Explorer, summarize by the time field and specify the time bucket bin.
View section
| Menu | Behavior |
|---|---|
| Full View Mode | Maximizes the work space by hiding the ribbon menu and Connection Panel |
| Hide Empty Columns | Removes empty columns from the data grid |
| Collapse Singular Columns | Collapses columns with singular values |
| Explore Column Values | Shows column values distribution |
| Increase Font | Increases the font size of the query tab and of the results data grid |
| Decrease Font | Decreases the font size of the query tab and of the results data grid |
(*) Data View Settings:Kusto.Explorer keeps track of what settings are used per unique set of columns. So when columns are reordered or removed, the data view is saved and will be reusedwhenever the data with the same columns is retrieved. To reset the view to its defaults, in the View tab, select Reset View.
File tab
| Menu | Behavior |
|---|---|
| ---------Query Script--------- | |
| New Tab | Opens a new tab window for querying Kusto |
| Open File | Loads data from a *.kql file to the active script panel |
| Save To File | Saves the content of the active script panel to *.kql file |
| Close Tab | Closes the current tab window |
| ---------Save Data--------- | |
| To CSV | Exports data to a CSV (comma-separated-values) file |
| To JSON | Exports data to a JSON formatted file |
| To Excel | Exports data to an XLSX (Excel) file |
| To Text | Exports data to a TXT (text) file |
| To CSL Script | Exports Query to a script file |
| To Results | Exports Query and data to a Results (QRES) file |
| ---------Load Data--------- | |
| From Results | Loads Query and data from a Results (QRES) file |
| ---------Clipboard--------- | |
| Data To Clipboard | Exports Query and data set to a clipboard. If a chart is presented, it exports the chart as a bitmap |
| Result To Clipboard | Exports data set to a clipboard. If a chart is presented, it exports the chart as a bitmap |
| Query to Clipboard | Exports the Query to clipboard |
| ---------Results--------- | |
| Clear results cache | Clears cached results of previously executed queries |
Connections Tab
| Menu | Behavior |
|---|---|
| ---------Groups--------- | |
| Add group | Adds a new Kusto Server group |
| Rename group | Renames the existing Kusto Server group |
| Remove group | Removes the existing Kusto Server group |
| ---------Clusters--------- | |
| Import connections | Imports connections from a file specifying connections |
| Export connections | Exports connections to a file |
| Add connection | Adds a new Kusto Server connection |
| Edit connection | Opens a dialog for Kusto Server connection properties editing |
| Remove connection | Removes the existing connection to Kusto Server |
| Refresh | Refreshes properties of a Kusto server connection |
| ---------Identity Providers--------- | |
| Inspect Connection Principal | Shows currents active user details |
| Sign-out From AAD | Signs-out the current user from the connection to AAD |
| ---------Data Scope--------- | |
| Caching scope |
|
| DateTime Column | Name of column which may be used for time pre-filter |
| Time Filter | Value of time pre-filter |
View Tab
| Menu | Behavior |
|---|---|
| ---------Appearance--------- | |
| Full View Mode | Maximizes the work space by hiding the ribbon menu and Connection Panel |
| Increase Font | Increases the font size of the query tab and of the results data grid |
| Decrease Font | Decreases the font size of the query tab and of the results data grid |
| Reset Layout | Resets the layout of the tool's docking controls and windows |
| ---------Data View--------- | |
| Reset View | Resets data view settings (*) |
| Explore Column Values | Shows column values distribution |
| Focus on query statistics | Changes the focus to query statistics instead of query results upon query completion |
| Hide Duplicates | Toggles removal of the duplicate rows from the query results |
| Hide Empty Columns | Toggles removal of empty columns from the query results |
| Collapse Singular Columns | Toggles collapsing columns with singular value |
| ---------Data Filtering--------- | |
| Filter Rows in Search | Toggles the option to show only matching rows in query results search (Ctrl+F) |
| ---------Visualizations--------- | |
| Visualizations | See Visualizations, above. |
(*) Data View Settings: Kusto.Explorer keeps track of what settings are used per unique set of columns. So when columns are reordered or removed, the data view is saved and will be reused whenever the data with the same columns is retrieved. To reset the view to its defaults, in the View tab, select Reset View.
Tools Tab
| Menu | Behavior |
|---|---|
| ---------IntelliSense--------- | |
| Enable IntelliSense | Enables and disables IntelliSense on the Script Panel |
| ---------Analyze--------- | |
| Query Analyzer | Launches the Query Analyzer tool |
| Query Checker | Analyzes the current query and outputs a set of applicable improvement recommendations |
| Calculator | Launches the calculator |
| ---------Analytics--------- | |
| Analytical Reports | Opens a dashboard with multiple pre-built reports for data analysis |
| ---------Translate--------- | |
| Query to Power BI | Translates a query to a format suitable for using in Power BI |
| ---------Options--------- | |
| Reset Options | Sets application settings to default values |
| Options | Opens a tool for configuring application settings. Details |
Management Tab
| Menu | Behavior |
|---|---|
| ---------Authorized Principals--------- | |
| Manage Cluster Authorized Principals | Enables managing a cluster's principals for authorized users |
| Manage Database Authorized Principals | Enables managing a database's principals for authorized users |
| Manage Table Authorized Principals | Enables managing a table's principals for authorized users |
| Manage Function Authorized Principals | Enables managing a function's principals for authorized users |
Help Tab
| Menu | Behavior |
|---|---|
| ---------Documentation--------- | |
| Help | Opens a link to the Kusto online documentation |
| What's new | Opens a document that lists all Kusto.Explorer changes |
| Report Issue | Opens a dialog with two options:
|
| Suggest Feature | Opens a link to the Kusto feedback forum |
| Check Updates | Checks if there are updates to your version of Kusto.Explorer |
Connections panel
The left pane of Kusto.Explorer shows all the cluster connections that the clientis configured with. For each cluster it shows the databases, tables, and attributes (columns)that they store. The Connections panel enables you to select items (which sets an implicit contextfor the search/query in the main panel), or double-click items to copy the name to thesearch/query panel.
If the actual schema is large (such as a database with hundreds of tables), it's possible to search the schema by pressing CTRL+F and entering asubstring (case-insensitive) of the entity name you're looking for.
Kusto.Explorer supports controlling the Connection panel from the query window.This is very useful for scripts. For example, starting a script file with a commandthat instructs Kusto.Explorer to connect to the cluster/database whose data is beingqueried by the script is possible by using the following syntax. As usual, you'll have to run each line using F5 or similar:
Controlling the user identity used for connecting to Kusto
When adding a new connection, the default security model used isAAD-Federated security, in which authentication is done through theAzure Active Directory using the default AAD user experience.
In some cases, you might need finer control over the authentication parametersthan is available in AAD. If so, it's possible to expand the'Advanced: Connection Strings' edit box and provide a validKusto connection string value.
For example, users who have presence inmultiple AAD tenants sometimes need to use a particular 'projection'of their identities to a specific AAD tenant. This can be done byproviding a connection string such as the one below (replace words IN CAPITAL with specific values):
What is unique is that AAD_TENANT_OF_CLUSTER is a domain nameor AAD tenant ID (a GUID) of the AAD tenant in which the cluster is hosted(usually the organization domain name who owns the cluster, such ascontoso.com), and USER_DOMAIN is the identity of the user invited into that tenant (for example, joe@fabrikam.com).
Note
The domain name of the user is not necessarily the same as that of the tenant hosting the cluster.
Table row colors
Kusto.Explorer tries to 'guess' the severity or verbosity level of each row in the results pane and color it accordingly. It does this by matching the distinct values of each column with a set of known patterns ('Warning', 'Error', and so on).
To modify the output color scheme, or turn this behavior off, from the Tools menu, select Options > Results Viewer > Verbosity color scheme.
Search++ Mode
- In the Home tab, in the Query dropdown, select 'Search++'.
- Select Multiple tables and then, under Choose tables, define which tables to search.
- In the edit box enter your search phrase and select Go
- A heat-map of the table/time-slot grid shows which term appears and where they appear
- Select a cell in the grid and select View Details to show the relevant entries
Query Mode
Microsoft Office Mac Download Free
Kusto.Explorer has a powerful script mode which enables you to write, edit and run ad-hoc queries. The script mode comes with syntax highlighting and IntelliSense, so you can quickly ramp-up to Kusto CSL language.
Basic Queries
If you have have table Logs, you can start exploring them by entering:
When your cursor is positioned on this line it's colored gray. Pressing 'F5' runs the query.
Here are some more example queries:
Importing a local file into a Kusto table
Kusto.Explorer provides a convenient way to upload a files from your machine to a Kusto table.
Make sure you created the table with a schema which matches your file(for example, using the .create table command)
Make sure the file extension is appropriate to the contents of the file. For example:
- If your file contains comma-separated-values, make sure your file has a .csv extension.
- If your file contains tab-separated-values, make sure your file has a .tsv extension.
Right-click the target database in the Connections panel, and select Refresh, so that your table appears.
Right-click the target table in the Connections panel, and select Import data from local files.
Select the file(s) to upload and select Open.
The progress bar displays the progress, and a dialog displays when the operation completes
Query the data in your table (double-click the table in the Connections panel).
Managing Authorized Principals
Kusto.Explorer provides a convenient way to manage cluster, database, table, or function authorized principals.
Note
Only admins can add or drop authorized principals in their own scope.
Right-click the target entity in the Connections panel, and select Manage Authorized Principals. (You can also do this from the Management Menu.)
To add a new authorized principal, select Add principal, provide the principal details, and confirm the action.
To drop an existing authorized principal, select Drop principal and confirm the action.
Sharing queries and results by email
Kusto.Explorer provides a convenient way to share queries and query results by email. Select Export to Clipboard, and Kusto.Explorer will copy the following items to the clipboard:
- Your query
- The query results (table or chart)
- The connection details for the Kusto cluster and database
- A link that will re-run the query automatically
Here's how it works:
Run a query in Kusto.Explorer
Select Export to Clipboard (or press
Ctrl+Shift+C)Open, for example, a new Outlook message.
Paste the contents of the clipboard to the Outlook message.
Client-side query parametrization
Warning
There are two types of query parametrization techniques in Kusto:
Language-integrated query parametrization is implemented as partof the query engine and meant to be used by applications that query the service programmatically.
Client-side query parametrization, described below, is a feature of the Kusto.Explorer application only. It's equivalent to using string-replace operations on the queries before sending them to be executed by the service. The syntax described below is not part of the query language itself, and can't be used when sending queries to the service by means other than Kusto.Explorer.
If you plan to use same value in multiple queries or in multiple tabs, it's going to be difficult to change it. However, Kusto.Explorer supports Query parameters. Parameters are denoted by {} brackets. For example: {parameter1}
The script editor highlights query parameters:
You can easily define and edit existing query parameters:
The script editor also has IntelliSense for query parameters that are already defined:
There can be multiple sets of parameters (listed in the Parameters Set combo box).Use the Add new and Delete current to manipulate the list of Parameter sets.
Query parameters are shared among tabs, so that they can be easily reused.
Deep-linking queries
Overview
You can create a URI that, when opened in a browser, Kusto.Explorer will start locally and run a specific query on a specified Kusto database.
Limitations
Download Microsoft Query For Mac Download
The queries are limited to ~2000 characters due to Internet Explorer limitations (the limitation is approximate because it's dependent on the cluster and Database name length)https://support.microsoft.com/kb/208427To reduce chances you will reach the character limit, see Getting Shorter Links, below.
The format of the URI is:https://
For example: https://help.kusto.windows.net/Samples?query=StormEvents+%7c+limit+10
This URI will open Kusto.Explorer, connect to the help Kusto cluster, and run the specified query on the Samples database. If there is an instance of Kusto.Explorer already running, the running instance will open a new tab and run the query in it.)
Security note: For security reasons, deep-linking is disabled for control commands.
Creating a deep-link
The easiest way to create a deep-link is to author your query in Kusto.Explorer and then useExport to Clipboard to copy the query (including the deep link and results) to the clipboard. You can then share it by email.
When copied to an email, the deep link is displayed in small fonts; for example:
https://help.kusto.windows.net:443/Samples [Click to run query]
The first link opens Kusto.Explorer and sets the cluster and database context appropriately.The second link (Click to run query) is the deep link. If you move to the link to an email messageand press CTRL-K, you can see the actual URL:
Deep-links and parametrized queries
You can use Parametrized Queries with deep-linking.
- Create a query to be formed as a Parametrized Query (for example,
KustoLogs where Timestamp > ago({Period}) count) - Provide a parameter for every Query Parameter in the URIIn this case:
Getting shorter links
Queries can become long. To reduce the chance the query exceeds the maximum length use theString Kusto.Data.Common.CslCommandGenerator.EncodeQueryAsBase64Url(string query) methodavailable in Kusto Client Library. This method produces a more compact version of the query. The shorter format is also recognized by Kusto.Explorer.
The query is made more compact by applying next transformation:
Kusto.Explorer command-line arguments
Kusto.Explorer supports several command-line arguments in the following syntax (the order matters):
[LocalScriptFile] [QueryString]
Where:
- LocalScriptFile is the name of a script file on the local machine which musthave the extension
.kql. If such a file exists, Kusto.Explorer automaticallyloads this file when it starts up. - QueryString is a string formatted using HTTP query string formatting. This method provides additional properties, as described in the table below.
For example, to start Kusto.Explorer with a script file called c:tempscript.kqland configured to communicate with cluster help, database Samples, use thefollowing command:
| Argument | Description |
|---|---|
| Query to execute | |
query | The query to execute (base64-encoded). If empty, use querysrc. |
querysrc | The URL of a file or blob holding the query to execute (if query is empty). |
| Connection to the Kusto cluster | |
uri | The connection string of the Kusto cluster to connect to. |
name | The display name of the connection to the Kusto cluster. |
| Connection group | |
path | The URL of a connection group file to download (URL-encoded). |
group | The name of the connection group. |
filename | The local file holding the connection group. |
Kusto.Explorer connection files
Kusto.Explorer keeps its connections settings in the %LOCALAPPDATA%Kusto.Explorer folder.A list of Connection Groups is kept inside %LOCALAPPDATA%Kusto.ExplorerUserConnectionGroups.xml,and each Connection Group is kept inside a dedicated file under %LOCALAPPDATA%Kusto.ExplorerConnections.
Format of connection group files
The file location is %LOCALAPPDATA%Kusto.ExplorerUserConnectionGroups.xml.
This is an XML serialization of an array of the ServerGroupDescription objects with the following properties:
Example:
Format of connection list files
File location is: %LOCALAPPDATA%Kusto.ExplorerConnections.
This is an XML serialization of an array of the ServerDescriptionBase objects with the following properties:
Example:
Resetting Kusto.Explorer
If you need to, you can completely reset Kusto.Explorer. Use the following procedure to progressively reset Kusto.Explorer deployed on your computer, until it's completely removed and must be installed from scratch.
In Windows, open Change or remove a programs (also known as Programs and Features).
Select every item whose name starts with
Kusto.Explorer.Select Uninstall.
If this fails to uninstall the application (a known issue sometimes withClickOnce applications), see this stack overflow article which explains how to do it.
Delete the folder
%LOCALAPPDATA%Kusto.Explorer. This removes all connections, history, and so on.Delete the folder
%APPDATA%Kusto. This removes the Kusto.Explorer token cache. You will need to re-authenticate to all clusters.
It's also possible to revert to a specific version of Kusto.Explorer:
- Run
appwiz.cpl. - Select Kusto.Explorer and select Uninstall/Change.
- Select Restore the application to its previous state.
Troubleshooting
Kusto.Explorer fails to start
Kusto.Explorer shows error dialog during or after start-up
Symptom:
At start-up, Kusto.Explorer shows an InvalidOperationException error.
Possible solution:
This error may suggest that the operating system became corrupted or is missing some of the essential modules.To check missing or corrupted system files, follow the steps described here:
https://support.microsoft.com/help/929833/use-the-system-file-checker-tool-to-repair-missing-or-corrupted-system
Kusto.Explorer always downloads even when there are no updates
Symptom:
Every time you open Kusto.Explorer, you are prompted to install a new verison. Kusto.Explorer downloads the entire package, without actually updating the already-installed version.
Possible solution:
This could be a result of corruption in your local ClickOnce store. You can clear the local ClickOnce store, by running the following command, in an elevated command prompt.
Important
- If there are any other instances of ClickOnce applications or of
dfsvc.exe, terminate them before running this command. - Any ClickOnce apps will reinstall automatically the next time you run them, as long as you have access to the original install location stored in the app shortcut. App shortcuts won't be deleted.
Try installing Kusto.Explorer again from one of the installation mirrors.
ClickOnce error: Cannot Start Application
Symptoms:
- The program fails to start and displays an error containing:
External component has thrown an exception - The program fails to start and displays an error containing:
Value does not fall within the expected range - The program fails to start and displays an error containing:
The application binding data format is invalid. - The program fails to start and displays an error containing:
Exception from HRESULT: 0x800736B2
You can explore the error details by clicking Details in the following error dialog:
Proposed solution steps:
Uninstall the Kusto.Explorer application using
Programs and Features(appwiz.cpl).Try running
CleanOnlineAppCache, and then try installing Kusto.Explorer again. From an elevated command-prompt:Install Kusto.Explorer again from one of the installation mirrors.
If it still fails, delete the local ClickOnce store. Any ClickOnce apps will reinstall automatically the next time you run them, as long as you have access to the original install location stored in the app shortcut. App shortcuts would not be deleted.
From an elevated command-prompt:
If it still fails, remove temp deployment files and rename the Kusto.Explorer local AppData folder.
From an elevated command-prompt:
Install Kusto.Explorer again from one of the installation mirrors
To restore your connections from Kusto.Explorer.bak, from an elevated command-prompt:
If it still fails, enable verbose ClickOnce logging by creating a LogVerbosityLevel string value of 1 under:
HKEY_CURRENT_USERSoftwareClassesSoftwareMicrosoftWindowsCurrentVersionDeployment, repro it again, and send the verbose output to KEBugReport@microsoft.com.
ClickOnce error: Your administrator has blocked this application because it potentially poses a security risk to your computer
Symptom:
Program fails to install with either of the following errors:
Your administrator has blocked this application because it potentially poses a security risk to your computer.Your security settings do not allow this application to be installed on your computer.
Solution:
- This could be due to another application overriding the default ClickOnce trust prompt behavior. You can view your default configuration settings, compare them to the actual ones on your machine, and reset them as necessary, as explained in this how-to article.
Cleanup application data
Sometimes, when previous troubleshooting steps didn't help with getting Kusto.Explorer to start, cleaning data stored locally may help.
Data stored by Kusto.Explorer application can be found here: C:Users[your alias]AppDataLocalKusto.Explorer.
Note
Cleaning the data will lead to loss of opened tabs (Recovery folder), saved connections (Connections folder), and application settings (UserSettings folder).