6 Replies Latest reply: Nov 19, 2012 4:03 PM by mischaboender RSS

    How to run a T-SQL query in ePO 4.6? I miss query repository


      In years past I worked with ePO 3.x exetensively and built many custom queries which I placed in the query repository.


      I would like to do the same with 4.6. I could probably use SQL Query Analyzer as I used to but I don't have access to it, so I am stuck doing it through the ePO console. I see the usefulness of the query builder, but I would prefer to drop my own queries into the console.


      I'm not refering to importing XML, I'm talking about queries like


      count(*) as 'count',



      group by
      order by
      'count' desc, [EPOLeafNode].[AgentVersion] asc


      Is there any way to do this?


      Hmmm, maybe not... https://kc.mcafee.com/corporate/index?page=content&id=KB67406 describes using Query Analyzer instead of natively through ePO. I'd think McAfee would prefer to use its own tool when possible.