Forum Discussion

rockypabillore's avatar
rockypabillore
Brass Contributor
May 22, 2019

Any reason is to why filters "computer" only shows 50 entries?

Hi All,

 

I'm doing a log query to to figure out which computers have usagetrailing.. but it only grabs the top 50 devices. as shown here:

 

Any settings or configurations I have to specify?

  • Hi,

     

    We show only up to 50 values in the facets to reduce the metadata fetch time and to save system resources. You can see all values by using query like: DHAppReliability | distinct Computer

     

    BTW: We are working these days on replacing the existing facets experience but it would take time till it will be done.

     

    Thanks,

    Meir :->

  • It just shows 50 when you press the filter button (I suspect to keep the interface tidy); the query will actually run across all computers .

    To see, replace your last line with this:

    | summarize dcount(Computer)

Resources