Skip navigation
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
This discussion is archived
1478 Views 6 Replies Latest reply: Nov 19, 2012 4:03 PM by mischaboender RSS
gstam Newcomer 23 posts since
Nov 9, 2012
Currently Being Moderated

Nov 16, 2012 2:44 PM

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

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.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 5 points
  • Helpful Answers - 3 points