2 Replies Latest reply on Sep 11, 2009 9:58 AM by mrpg

    custom queries with 4.x similar to 3.6.x

    mrpg
      Hello folks,

      Is it possible to construct custom queries in 4.x as you were able to in 3.6.x? You could write your own SQL queries and save them under queries.

      I need to put together a report that list unmanaged systems but limits the results to 20. That possible?
        • 1. RE: custom queries with 4.x similar to 3.6.x
          tonyb99
          no but you can apply the sql query against the database itself
          • 2. RE: custom queries with 4.x similar to 3.6.x
            mrpg
            My situation is that I'm trying to deploy the agent to a large number of clients and using ePO to get this done has been horrendous. I have a unmanged query linked to a deploy task but I get loads of "expired" installs and errors about credentials failing or share does not exist but with those same credentials I map fine to admin$ of the respective client. I'd rather script the deploy but the powers that be do not. It seems if i select a few at a time the chances of successful deploys are better.

            So I want to find a way to limit the unmanaged query that feeds the deploy task.