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

    gstam

      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

      SELECT

      count(*) as 'count',
      [EPOLeafNode].[AgentVersion],
      [EPOLeafNode].[AgentVersion],
      [branchnode.nodename]

      FROM

      [EPOLeafNode],
      [branchnode.nodename]

      group by
      [EPOLeafNode].[AgentVersion]
      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.