1 Reply Latest reply on Nov 20, 2018 7:03 AM by Casity.chris

    Same query different result (filter not visible)

    MartinaLunardi Rookie

      Our customer has two queries done by two different people with the same Conditions listed in Properties field, but the queries return two different results.


      Inspecting query we find out that one query have a filter (done by one user and not published).

      The issue are:

      - we have to inspect SQL conditions to discover the difference

      - a LANDESK Administrator cannot see this group, however the role


      Do you have any suggestion to discover that query is filtered without checking SQL conditions or could be possible to improve this feature?

        • 1. Re: Same query different result (filter not visible)
          Casity.chris SupportEmployee

          Hello MartinaLunardi,


          The best way would be to open properties of the query and click the "Filters..." box. This should show you what groups this query is filtered for.


          If you were going to filter the query, your best bet would be to keep track of these via naming conventions. For example, if you have a group called "HelpDesk" and you wanted to query those machines, you could build your query and name it like "Adobe installed (HelpDesk)" so that you know it is filtered to only the "HelpDesk" group machines.


          Admins typically have access to all groups (Aside from the "My" groups for individual users) and should be able to manage each one. If you are using Teams or Tenant Manager and the admin cannot see all those Team groups, you may need to upgrade as there was a problem in earlier versions with this.


          Unfortunately, the above is going to be your best bet. You can find this information is SQL but it is not in its own column so querying for it is not easy. You will see something like this at the end of your query under the "Filter" column in the Query table of your DB:


          "Computer":"Group"."ID" IN (91)


          This tells you what group the query is filtered for, which you can match the ID up with the CustomGroup_Idn in the CustomGroup table to find what group this is filtered for.


          I hope this helps.


          Best Regards,


          Chris Casity