System information

Applies to: ✅ Azure Data Explorer

This section summarizes commands that are available to Database Admins and Database Monitors to explore usage, track operations, and investigate ingestion failures. For more information on security roles, see Kusto role-based access control.

• .show journal - displays history of the metadata operations.
• .show operations - displays administrative operations both running and completed, since Admin node was last elected.
• .show queries - displays information on completed and running queries.
• .show commands - displays information on completed commands and their resources utilization.
• .show commands-and-queries - displays information on completed commands and queries, and their resources utilization.
• .show ingestion failures - displays information on failures encountered during data ingestion.
• .show table details - displays information on table size and other table statistics.
• .show table data statistics - displays table data statistics per column.