cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Need ePO SQL schema

Jump to solution

Hello Team,

we are trying to retrieve assignment path column from the ePO SQL instance for our reporting needs.

Requesting you to provide the Table and the exact name of that is used to fetch the assignment path.

1 Solution

Accepted Solutions
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 10 of 10

Re: Need ePO SQL schema

Jump to solution

Disregard that.  I created a simple query that shows system name and assignment path.  It is getting that info from branchnode table.

select [EPOLeafNode].[NodeName], [EPOBranchNode].[NodeTextPath2], [EPOLeafNode].[AutoID] from [EPOLeafNode] left join [EPOBranchNode] on [EPOLeafNode].[ParentID] = [EPOBranchNode].[AutoID] order by [EPOLeafNode].[NodeName] asc

Creating a query in epo first is a simple way to find out where epo pulls the info from.

 

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

View solution in original post

9 Replies
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 10

Re: Need ePO SQL schema

Jump to solution

Hello Abhijith

Here are the links to our ePO schemas:

5.9
https://kc.mcafee.com/agent/index?page=content&id=KB89939


5.10
https://kc.mcafee.com/agent/index?page=content&id=KB91051

Please note that those articles are registered

that will be EPOLeafNodeMT 

"AssignmentPath" nvarchar 4096 Full policy assignment path.

Regards

Alejandro

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 3 of 10

Re: Need ePO SQL schema

Jump to solution

Hello @Abhijith 

Thanks for your post.

You can refer the below KB for Database schema

https://kc.mcafee.com/corporate/index?page=content&id=KB91051&locale=en_US

https://kc.mcafee.com/corporate/index?page=content&id=KB89939&locale=en_US

to access the above KB articles you need to login in Service Portal.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Re: Need ePO SQL schema

Jump to solution

Hello Team McAfee,

Thanks for the shared links.

I really appreciate posting the solution real quick.

As there are really many database tables in the document and I am particularly looking for the table which contains the assignment path of the systems in them.

Please let us know if there is a specific table for the same.

Thanks and regards

 

 

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 5 of 10

Re: Need ePO SQL schema

Jump to solution

That will be EPOLeafNodeMT 

"AssignmentPath" nvarchar 4096 Full policy assignment path.

Re: Need ePO SQL schema

Jump to solution

The output value is shown as null.

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 7 of 10

Re: Need ePO SQL schema

Jump to solution

What exact query are you running that you are getting those results?

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Re: Need ePO SQL schema

Jump to solution

Hello,

 

We are fetching  system name , ENS version, AMcore content version and Assignment path from ePO DB in to a single report that has information of other competencies and its details.

 

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 9 of 10

Re: Need ePO SQL schema

Jump to solution

Go to that query, select it, then go to actions, view sql and paste it here.  That won't contain any sensitive information.  

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 10 of 10

Re: Need ePO SQL schema

Jump to solution

Disregard that.  I created a simple query that shows system name and assignment path.  It is getting that info from branchnode table.

select [EPOLeafNode].[NodeName], [EPOBranchNode].[NodeTextPath2], [EPOLeafNode].[AutoID] from [EPOLeafNode] left join [EPOBranchNode] on [EPOLeafNode].[ParentID] = [EPOBranchNode].[AutoID] order by [EPOLeafNode].[NodeName] asc

Creating a query in epo first is a simple way to find out where epo pulls the info from.

 

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

View solution in original post

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community