cancel
Showing results for 
Search instead for 
Did you mean: 
epo909
Level 9
Report Inappropriate Content
Message 1 of 4

API: Unknown column:Branch for table:EPOMasterCatalog

Jump to solution

Hi,

I have a web application that needs to query ePO via API. I need to fetch the current DAT in the repository so I've assembled the following query:

target=EPOMasterCatalog&select=(select EPOMasterCatalog.ProductVersion)&where=(where (and (eq EPOMasterCatalog.ProductName "DAT") (eq EPOMasterCatalog.Branch "Current")))

When executing the query the server returns:

Error 0 :

Unknown column:Branch for table:EPOMasterCatalog

This is odd since EPOMasterCatalog does have a Branch column...

I need to specify the brach otherwise the query return 2 dat versions from branches 'current' and 'previous'.

I've also checked the API documentation and this seems the proper way to define a where with teh 'and' clause.

Anyone have any ideas why this is failing?

Thanks in advance.

RD

1 Solution

Accepted Solutions
Highlighted
McAfee Employee JoeBidgood
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: API: Unknown column:Branch for table:EPOMasterCatalog

Jump to solution

Hi...

You're correct in your assumption - not all columns are exposed to the query builder and API commands, and it appears that ePOMasterCatalog.Branch is one of the ones that is not. If you run the core.listTables command you'll get a list of the available columns, and the results of this for ePOMasterCatalog shows that Branch is not listed - but ProductVersion and ProductName are, which is why the other two queries work as expected.

So at the moment this would appear to be as designed: if you'd like to see this feature added to the API command set, please submit a PER and hopefully it will be implemented in a future version of ePO.

Thanks -

Joe

3 Replies
yeayu
Level 7
Report Inappropriate Content
Message 2 of 4

Re: API: Unknown column:Branch for table:EPOMasterCatalog

Jump to solution

Hello,

I am exactly facing the same issue... did you find an answer or even a workaround?

Thanks in advance

Re: API: Unknown column:Branch for table:EPOMasterCatalog

Jump to solution

Does anyone have any insight into this? I have the exact same issue.


It seems to work depending on the column being requested. ProductName works.
select EPOMasterCatalog.ProductVersion)&where=(where (like EPOMasterCatalog.ProductName "Linux Engine")

But Branch does not.
select EPOMasterCatalog.ProductVersion)&where=(where (like EPOMasterCatalog.Branch "Evaluation")

Highlighted
McAfee Employee JoeBidgood
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: API: Unknown column:Branch for table:EPOMasterCatalog

Jump to solution

Hi...

You're correct in your assumption - not all columns are exposed to the query builder and API commands, and it appears that ePOMasterCatalog.Branch is one of the ones that is not. If you run the core.listTables command you'll get a list of the available columns, and the results of this for ePOMasterCatalog shows that Branch is not listed - but ProductVersion and ProductName are, which is why the other two queries work as expected.

So at the moment this would appear to be as designed: if you'd like to see this feature added to the API command set, please submit a PER and hopefully it will be implemented in a future version of ePO.

Thanks -

Joe

More McAfee Tools to Help You
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • Visit: Business Service Portal
  • More: Search Knowledge Articles
  • ePolicy Orchestrator Support

    • Download the new ePolicy Orchestrator (ePO) Support Center Extension which simplifies ePO management and provides support resources directly in the console. Learn more about ePO Support Center