-->

• Microsoft Edge Explorer For Mac
• Explorer For Mac
• Internet Explorer Download
• Microsoft Explorer Download
• Microsoft Internet Explorer For Mac High Sierra

Kusto.Explorer is a rich desktop application that allows you to explore your data using Kusto query language.

Internet Explorer for Mac (also referred to as Internet Explorer for Macintosh, Internet Explorer Macintosh Edition, Internet Explorer:mac or IE:mac) is an unsupported inactive proprietary web browser developed by Microsoft for the Macintosh platform. Initial versions were developed from the same code base as Internet Explorer for Windows. Internet explorer for mac I can download free software to run IE on Mac. I am happy to pay for software, what is the best software to use to run Internet Explorer on Mac os x lion? With the help of Android Emulators, you can run Explorer CCTV for Windows 10, 8, 7 and Explorer CCTV for Mac. Below you can see some details of Explorer CCTV App and a guide to download Explorer CCTV for Laptop Devices. Explorer CCTV App Details. Control your Qvis ‘Explorer’ range DVR remotely using your mobile smart device.

Getting the tool

Installation is simple as accessing your Kusto cluster with Internet Explorer at:https://your_cluster.kusto.windows.net

Alternatively, you can obtain a Kusto.Explorer tool from this URL: https://aka.ms/Kusto.Explorer

Using Chrome and Kusto.Explorer

If you are using Chrome as your default browser - make sure to install the ClickOnce extension for Chrome:

Overview of user experience

Kusto Explorer window has several UI parts:

1. Script panel
2. Results panel

Keyboard shortcuts

Please study this list of Kusto.Explorer keyboard shortcutsto truly become a Kusto.Explorer ninja master.

Menu Panel

Kusto.Explorer Menu panel has several tabs:

Home Tab

Home Tab accumulates most recently used functionality, splitted by menus:

Query Menu

Menu	Behavior
New Tab Window	Opens a new tab window for querying Kusto
Mode: Query	Switches Query Window into a script mode: commands can be loaded and saved as scripts (default)
Mode: Search	Single query mode: each command being entered is processed immediately and presents a result in the Result Window
Mode: Search++	Allows searching for a term using Search syntax across one or more tables. See more at using Search++ Mode
Caching scope: Hot Data	Execute queries only on hot data cache
Caching scope: All Data	Execute queries on all available data (default)
DateTime Column	Name of column which may be used for time pre-filter
Time Filter	Value of time pre-filter

Share Menu

Menu	Behavior
Data To Clipboard	Exports Query and data set to a clipboard. In case chart is presented - exports the chart as bitmap
Result To Clipboard	Exports data set to a clipboard. In case chart is presented - exports the chart as bitmap
Query to Clipboard	Exports Query to clipboard

Visualizations Menu


Menu	Behavior
Area chart	Display an area chart in which the x-axis is the first column (must be a numeric) and all numeric columns are mapped to different series (Y-axis)
Column Chart	Display 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	Display 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	Display a stacked area chart in which the x-axis is the first column (must be a numeric) and all numeric columns are mapped to different series (Y-axis)
Time Chart	Display a time chart in which the x-axis is the first column (must be a datetime) and all numeric columns are mapped to different series (Y-axis).
Line Chart	Display a line chart in which the x-axis is the first column (must be a numeric) and all numeric columns are mapped to different series (Y-axis).
Anomaly Chart	Similar to timechart - while finding anomalies in time series data using machine learning anomalies algorithm. For anomaly detection, Kusto.Explorer uses series_decompose_anomalies function.(*)
Pie Chart	Display a pie chart in which the color-axis is the first column and the theta-axis (must be a measure, converted to percents) is the second column.
Ladder Chart	Display a ladder chart in which the x-axis is the last two columns (must be a datetime) and the y-axis is a composite of the other columns.
Scatter Chart	Display a point graph in which the x-axis is the first column (must be a numeric) and all numeric columns are mapped to different series (Y-axis).
Pivot Chart	Display a pivot table + pivot chart that gives the full flexibility of selecting data, columns, rows and various different chart types.
Time Pivot	Interactive navigation over the events time-line (pivoting on time axis)

(*) Anomaly Chart:The algorithm is expecting time series data which consists of 2 columns:

1. Time in fixed interval buckets
2. Numeric value for anomaly detectionTo produce that in Kusto.Explorer, you should summarize by the time field and specify the time bucket bin.

View Menu

Menu	Behavior
Full View Mode	Maximizes the work space by hiding ribbon menu and Connection Panel
Increase Font	Increases fonts of the query tab and of the results data grid
Decrease Font	Decreases fonts of the query tab and of the results data grid
Hide Empty Columns	Removes empty columns from the data grid
Collapse Singular Columns	Collapses columns with singular value
Explore Column Values	Shows column values distribution

(*) Data View Settings:Kusto.Explorer keeps track of what settings are used per unique set of the columns,so when columns are reordered/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,use Reset View menu item.

Please consider upgrading to a more recent version of Internet Explorer, or trying another browser such as Firefox, Safari, or Google Chrome.(Please remember to honor your company's IT policies before installing new software!). Attention, Internet Explorer UserAnnouncement: Jive has discontinued support for Internet Explorer 7 and below.In order to provide the best platform for continued innovation, Jive no longer supports Internet Explorer 7.Jive will not function with this version of Internet Explorer.

File Tab

Menu	Behavior
---------Query Script---------
New Tab Window	Opens a new tab window for querying Kusto
Open File	Loads data from provided *.csl file to active script panel
Save To File	Saves content of active script panel to *.csl file
Query Srcipt	Close Tab	Closes current tab window
---------Save Data---------
To CSV	Exports data to CSV (comma-separated-values) file
To JSON	Exports data to JSON formatted file
To Excel	Exports data to XLSX (Excel) file
To Text	Exports data to TXT (text) file
To CSL Script	Exports Query to a script file
To Results	Exports Query and data to Results (QRES) file
---------Load Data---------
From Results	Loads Query and data from Results (QRES) file
---------Clipboard---------
Data To Clipboard	Exports Query and data set to a clipboard. In case chart is presented - exports the chart as bitmap
Result To Clipboard	Exports data set to a clipboard. In case chart is presented - exports the chart as bitmap
Query to Clipboard	Exports Query to clipboard
---------Results---------
Clear results cache	Clears cached results of previously executed queries

Connections Tab

Menu	Behavior
---------Groups---------
Add gourp	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 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 Kusto server connection
---------Identity Providers---------
Inspect Connection Principal	Shows currents active user details
Sign-out From AAD	Signs-out current user from connection to AAD

View Tab

Menu	Behavior
---------Appearance---------
Full View Mode	Maximizes the work space by hiding ribbon menu and Connection Panel
Increase Font	Increases fonts of the query tab and of the results data grid
Decrease Font	Decreases fonts of the query tab and of the results data grid
Reset Layout	Resets 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 of showing only matching rows in query results search(Ctrl+F)

(*) Data View Settings: Kusto.Explorer keeps track of what settings are used per unique set of the columns, so when columns are reordered/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, use Reset View menu item.

Tools Tab

Menu	Behavior
---------IntelliSense---------
Enable IntelliSense	Enables/Disables IntelliSense on Script Panel)
---------Analyze---------
Query Analyzer	Launches Query Analyzer tool
Calculator	Launches Calculator
---------Analytics---------
Analytical Reports	Opens dashboard with multiple pre-built reports for data analysis
---------Translate---------
Query to Power BI	Translates query to format suitable for using in Power BI
---------Options---------
Reset Options	Sets application settings to default values
Options	Opens tool for application settings edit

Management Tab

Menu	Behavior
---------Authorized Principals---------
Manage Cluster Authorized Principals	When in context of a cluster, enables managing its principals for authorized users
Manage Database Authorized Principals	When in context of a database, enables managing its principals for authorized users
Manage Table Authorized Principals	When in context of table, enables managing its principals for authorized users
Manage Function Authorized Principals	When in context of a function, enables managing its 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
Get support	Opens a link to the support-ticket web page
Suggest Feature	Opens a link to the Kusto feedback forum
Report Issue	Opens html file with the details that should be send with the issue report

Connections Panel

The left pane of Kusto.Explorer shows all the cluster connections that the clientis configured with, and for each cluster -- the databases, tables, and attributes (columns)that they store. The pane allows one 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 is possible to search the schema by typing CTRL+F and asubstring (case-insensitive) of the entity name being looked-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 beingqueries by the script is possible by using the following syntax (note that,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 throughAzure Active Directory using the default AAD user experience.

In some cases, one needs finer control over the authentication parametersthan is available by AAD. In such cases, it is 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 like so (words IN CAPITAL are to bereplaced by specific values):

Here, the unique thing 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 who has beeninvited into that tenant (e.g., joe@fabrikam.com). Note that the domainname of the user is not necessarily the same as that of the tenant hostingthe cluster.

Search++ Mode

1. In the ribbon's Home, in the dropdown, choose 'Search++'
2. Choose 'Multiple tables' and then under 'Choose tables' you can define which tables to search
3. In the edit box write your search phrase and hit 'Go'
4. You will get a heat-map of table/time-slot grid showing which term appears where
5. Select a cell in the grid and click 'View Details' to show the relevant entries

Query Mode

Kusto.Explorer has powerful script mode - that allows you write, edit and run ad-hoc queries.It comes with syntax highlighting and IntelliSense - so you can ramp-up to Kusto CSLlanguage very fast.

Basic Queries

Assume you have table Logs. You can start exploring it by typing next:

When your cursor is positioned on this line - it is colored in gray - and pressing 'F5' willrun the query.

Some more 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.

First, make sure you have created the table with a schema which matches your file(e.g. using the .create table command)

Second, make sure the contents of your file match its extension. E.g.:

• If your file contains comma-separated-values, make sure your file is named 'MyFile.csv'.
• If your file contains tab-separated-values, make sure your file is named 'MyFile.tsv'.

Once the above are verified, follow these steps:

1. Right-click on the target database in the Connections panel, and select Refresh, so that your table appears.

2. Right-click on the target table in the Connections panel, and select Import data from local files.

3. Choose the file(s) you wish to be uploaded and select Open.

4. Follow the progress, until operation completes

5. Query the data in your table (double-click on the table in the Connections panel).

Managing Authorized Principals

Kusto.Explorer provides a convenient way to manage cluster, database, table or function authorized principals.

Please note that only admins can add or drop authorized principals in their own scope.

1. Right-click on the target entity in the Connections panel, and select Manage Authorized Principals(also available via the Management Menu).

2. In case you want to add a new authorized principal, select Add principal, provide the principal details and confirm the action.

3. In case you want to drop an existing authorized principal, select Drop principal and confirm the action.

Sharing Queries and Results over Email

Kusto.Explorer provides a convenient way to share queries and query results over email -- Simply click 'Export to Clipboard', and the tool will copy to the clipboard:

1. Your query
2. The query results (table or chart)
3. The connection details for the Kusto cluster and database
4. A link that will re-run the query automatically

Here's how it works:

1. Run some query in Kusto.Explorer
2. Click 'Export to Clipboard' (or use Ctrl+Shift+C keystroke)

3. Switch to (for example) an Outlook Message:

4. Hit 'Paste:':

Client-Side Query Parametrization

Warning

There are two typed of query parametrization techniques in Kusto:Language-integrated query parametrization is implemented as partof the query engine and meant to be used by applications thatquery the service programmatically.

Client-side query parametrization, described below, is a featureof the Kusto.Explorer application only. It is equivalent to doingstring-replace operations on the queries the user writes before sendingthem to be executed by the service. The syntax described below is notpart of the query language itself, and cannot be used when sendingqueries to the service by means other than Kusto.Explorer.

If you plan to use same value in multiple queries or in multiple tabs, it is going tobe hard to change it. Luckily, Kusto.Explorer supports having Query parameters. Parametersare denoted with {} brackets. For example: {parameter1}

Script editor highlights query parameters:

You can easily define/edit existing Query parameters:

Script editor also has IntelliSense for Query parameters that are already defined:

There can be multiple 'sets' of parameters (listed in Parameters Set combo box).Buttons, 'Add new' and 'Delete current' manipulate list of Parameters 'sets'.

Note that Query parameters are shared among tabs, so that they can be easily reused.

Deep-linking queries

Overview

It is possible to create a URI that, when opened in a browser, will have Kusto.Explorerstart locally and run a specified query on the specified Kusto database.

Limitations

The queries are limited to ~2000 chars due to IE limitation (the limitation is approximate because it is dependent on the cluster and Database name length)https://support.microsoft.com/kb/208427To reduce chances you will hit this limitation - see the Getting Shorter Links paragraph on this page.

The format of the URI is this:https://.kusto.windows.net/?query=

For example: https://help.kusto.windows.net/Samples?query=StormEvents+%7c+limit+10

This URI will open new Kusto.Explorer, connect to the help Kusto cluster, and run the specified query on the specified database (whose name is Samples). (Unless there is an instance of Kusto.Explorer already running, in which case 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 Easy Way

The easiest way to create a deep-link is to author your query in Kusto.Explorer, and then usethe Export to Clipboard button to copy the query (plus the deep link and results) to the clipboard,ready for sharing via Outlook:

When pasted to Outlook (or a similar app), the deep link is 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/database context appropriately.The second link ('Click to run query') is the deep link. If you move to the link in Outlookand press CTRL-K, you can see the actual URL:

Deep-link and Parametrized Queries

It is possible to use Parametrized Queries with deep-linking.First, make a query to be formed as Parametrized Query (e.g. KustoLogs where Timestamp > ago({Period}) count)Second, provide a parameter for every Query Parameter in the URIIn this casehttps://mycluster.kusto.windows.net/MyDatabase?web=0&query=KustoLogs+%7c+where+Timestamp+>+ago({Period})+%7c+count&Period=1h

Getting Shorter Links

Queries may become longer - and in order to reduce the chance query exceeds maximum length - youcan useString Kusto.Data.Common.CslCommandGenerator.EncodeQueryAsBase64Url(string query) methodavailable in Kusto Client Library that will produce a more compact version of the query and thisformat is also recognized by Kusto.Explorer

How does making compact query work?The query is made more compact by applying next transformation:

Kusto.Explorer command-line arguments

Kusto.Explorer supports accepting several command-line arguments in the following syntax (order matters):

[LocalScriptFile] [QueryString]

Where:

• LocalScriptFile is the name of a script file on the local machine which musthave the extension .csl. If such file exists, Kusto.Explorer will automaticallyload this file when it starts up.
• QueryString is a string formatted using the HTTP query string formatting,which provides additional properties as described in the table below.

For example, to start Kusto.Explorer with a script file called c:tempscript.csland 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/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 under %LOCALAPPDATA%Kusto.Explorer folder.List of Connection Groups is kept inside %LOCALAPPDATA%Kusto.ExplorerUserConnectionGroups.xml,and each Connection Group is kept inside dedicated file under %LOCALAPPDATA%Kusto.ExplorerConnections.

Format of Connection Group file

File location is at %LOCALAPPDATA%Kusto.ExplorerUserConnectionGroups.xml:

This is an XML serialization of an array of the ServerGroupDescription objects with next properties:

Example of Connection Group file

Format of Connection list file

File location is under %LOCALAPPDATA%Kusto.ExplorerConnections:

This is an XML serialization of an array of the ServerDescriptionBase objects with next properties:

Example of Connection list file

Resetting Kusto.Explorer

In some cases you might need to completely reset Kusto.Explorer. The following procedure can be used to progressively reset Kusto.Explorer deployed on your computer, until it is completely removed and must be installed from scratch.

1. Open Change or remove a program (also known as Programs and Features),then select every item whose name starts with Kusto.Explorer and hit Uninstall.

   If this fails to uninstall the application (a known issue sometimes withClickOnce applications), please see this.

2. Delete the folder %LOCALAPPDATA%Kusto.Explorer. (NOTE: This removed all connections that you might have, history, etc.)

3. Delete the folder %APPDATA%Kusto. (NOTE: This removes the Kusto.Explorer token cache; you will need to re-authenticate to all cluster.)

It is also possible to 'go back' to a specific version of Kusto.Explorer:

1. Run appwiz.cpl
2. Select Kusto.Explorer and hit Uninstall/Change
3. Select Restore the application to its previous state

Troubleshooting

Kusto.Explorer fails to start

Kusto.Explorer shows error dialog during or after start-up

Symptoms:

• Kusto.Explorer shows error dialog at start-up with error containing: InvalidOperationException

Possible solution:

This error may suggest that OS system became corrupted or missing some of the essential modules.To check missing or corrupted system files - use 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

Symptoms:

• Each time you open Kusto.Explorer it asks you to install a new verison and 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.

  • Notes:
    1. If there are any instances of other ClickOnce applications or of dfsvc.exe, terminate them before running this command.
    2. 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 will not be deleted.

• Then, try installing Kusto.Explorer again from one of the installation mirrors

ClickOnce error: Cannot Start Application

Symptoms:

• Program fails to start with error containing: External component has thrown an exception
• Program fails to start with error containing: Value does not fall within the expected range
• Program fails to start with error containing: The application binding data format is invalid.
• Program fails to start with error containing: Exception from HRESULT: 0x800736B2

The error details may be explored by clicking Details in the following error dialog:

Proposed solution steps:

1. Uninstall Kusto.Explorer application using Programs and Features (appwiz.cpl)

2. First just try running CleanOnlineAppCache, then try the install again. From elevated CMD:

   rundll32 %windir%system32dfshim.dll CleanOnlineAppCache

Try installing again from one of the installation mirrors

3. 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 elevated CMD:

Try installing again from one of the installation mirrors

4. If it still fails, remove temp deployment files and rename the Kusto.Explorer local AppData folder.

From elevated CMD:

Microsoft Edge Explorer For Mac

Try installing again from one of the installation mirrors

5. To restore your connections from Kusto.Explorer.bak, from elevated CMD, run:

   copy %LOCALAPPDATA%Kusto.Explorer.bakUser*.xml %LOCALAPPDATA%Kusto.Explorer

6. 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 toKEBugReport@microsoft.com.

ClickOnce error: Your administrator has blocked this application because it potentially poses a security risk to your computer

Explorer For Mac

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:

1. This could be due to another application overriding the default ClickOnce trust prompt behavior.

2. You can view your default configuration settings, compare them to the actual ones on your machine, and reset them as necessary, as explained here.

Internet Explorer Download

Cleanup application data

Sometimes, when previous troubleshooting steps didn't help with getting Kusto.Explorer to start, cleaning data that is stored locally may help.

Microsoft Explorer Download

Data stored by Kusto.Explorer application can be found here: C:Users[your alias]AppDataLocalKusto.Explorer.

Microsoft Internet Explorer For Mac High Sierra

Please, pay attention that cleaning the data will lead to the loss of opened tabs (Recovery folder), saved connections (Connections folder), application settings (UserSettings folder).