Plug-in narrownarrow plugin

T | evaluate narrow()

Il narrow plug-in "trasforma" un'ampia tabella in una tabella con solo tre colonne: numero di riga, tipo di colonna e valore di colonna (come string ).The narrow plugin "unpivots" a wide table into a table with just three columns: Row number, column type, and column value (as string).

Il narrow plug-in è progettato principalmente per scopi di visualizzazione, in quanto consente di visualizzare comodamente le tabelle estese senza dover scorrere orizzontalmente.The narrow plugin is designed mainly for display purposes, as it allows wide tables to be displayed comfortably without the need of horizontal scrolling.

SintassiSyntax

T | evaluate narrow()

EsempioExamples

Nell'esempio seguente viene illustrato un modo semplice per leggere l'output del .show diagnostics comando di controllo kusto.The following example shows an easy way to read the output of the Kusto .show diagnostics control command.

.show diagnostics
 | evaluate narrow()

I risultati di .show diagnostics se stesso sono una tabella con una sola riga e 33 colonne.The results of .show diagnostics itself is a table with a single row and 33 columns. Usando il narrow plug-in viene ruotato l'output in un modo simile al seguente:By using the narrow plugin we "rotate" the output to something like this:

RigaRow ColonnaColumn valoreValue
00 IntegritàIsHealthy TrueTrue
00 IsRebalanceRequiredIsRebalanceRequired FalseFalse
00 IsScaleOutRequiredIsScaleOutRequired FalseFalse
00 MachinesTotalMachinesTotal 22
00 MachinesOfflineMachinesOffline 00
00 NodeLastRestartedOnNodeLastRestartedOn 2017-03-14 10:59:18.92630232017-03-14 10:59:18.9263023
00 AdminLastElectedOnAdminLastElectedOn 2017-03-14 10:58:41.67419342017-03-14 10:58:41.6741934
00 ClusterWarmDataCapacityFactorClusterWarmDataCapacityFactor 0.1305528476733330.130552847673333
00 ExtentsTotalExtentsTotal 136136
00 DiskColdAllocationPercentageDiskColdAllocationPercentage 55
00 InstancesTargetBasedOnDataCapacityInstancesTargetBasedOnDataCapacity 22
00 TotalOriginalDataSizeTotalOriginalDataSize 51676280705167628070
00 TotalExtentSizeTotalExtentSize 17791652301779165230
00 IngestionsLoadFactorIngestionsLoadFactor 00
00 IngestionsInProgressIngestionsInProgress 00
00 IngestionsSuccessRateIngestionsSuccessRate 100100
00 MergesInProgressMergesInProgress 00
00 BuildVersionBuildVersion 1.0.6281.198821.0.6281.19882
00 BuildTimeBuildTime 2017-03-13 11:02:44.00000002017-03-13 11:02:44.0000000
00 ClusterDataCapacityFactorClusterDataCapacityFactor 0.1305528476733330.130552847673333
00 IsDataWarmingRequiredIsDataWarmingRequired FalseFalse
00 RebalanceLastRunOnRebalanceLastRunOn 2017-03-21 09:14:53.85234552017-03-21 09:14:53.8523455
00 DataWarmingLastRunOnDataWarmingLastRunOn 2017-03-21 09:19:54.14388002017-03-21 09:19:54.1438800
00 MergesSuccessRateMergesSuccessRate 100100
00 NotHealthyReasonNotHealthyReason null[null]
00 IsAttentionRequiredIsAttentionRequired FalseFalse
00 AttentionRequiredReasonAttentionRequiredReason null[null]
00 ProductVersionProductVersion KustoRelease_2017.03.13.2KustoRelease_2017.03.13.2
00 FailedIngestOperationsFailedIngestOperations 00
00 FailedMergeOperationsFailedMergeOperations 00
00 MaxExtentsInSingleTableMaxExtentsInSingleTable 6464
00 TableWithMaxExtentsTableWithMaxExtents KustoMonitoringPersistentDatabase.KustoMonitoringTableKustoMonitoringPersistentDatabase.KustoMonitoringTable
00 WarmExtentSizeWarmExtentSize 17791652301779165230