Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

Query tuning help by highlighting or coloring indexed fields in query rule editor

I came across many queries in Collections and found that IT-Pros use sometime fileds in their (collection) queries which are not indexed - which has a negative effect on query and collection performance. I would wish that we display the indexed values in bold or colour so you will be aware of the data which gives you better performance. In a second step we may be able to provide an alternative field if available in another attribute class.

27 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Marco Cibis (MS) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Dustin Hedges commented  ·   ·  Flag as inappropriate

        I would love to see this added into Management Insights if it cannot be done directly within the query editor.

      • Jeff Carreon commented  ·   ·  Flag as inappropriate

        This would really help large organizations with large hierarchies for scalability. Most admin console users are NOT aware of indexed vs non-indexed fields. Therefore, performance suffers when many collections are created with non-indexed fields. Please have a way for admins to easily make distinctions between indexed and non-indexed tables.

      Feedback and Knowledge Base