cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
davisoli
Level 8
Report Inappropriate Content
Message 1 of 4

ePO Database Schema Questions

Jump to solution

Hello,

I have a few questions regarding the ePO and Solidcore database schemas.

We are developing for a customer a technical add-on (TA) from McAfee ePO to Splunk, reading hardware and software asset database tables from ePO and Solidcore. It will read from the following tables: 

For hardware, we are pulling from:

  EPOComputerProperties,

  EPOLeafNode,

  EPOExtendedComputerProperties

 

For software, we are pulling from:

  SCOR_VW_CPE_APPS_SYSTEM,

  SCOR_VW_HOST_BINARY_ASSOC,

  SCOR_VW_INVENTORY,

  EPOLeafNode,

  EPOComputerProperties

First question - customer has McAfee ePO 5.10 Update 9, and we are running 5.10.0 (build 5.10.0.2428) in our dev environment. Have these database tables changed their names and/or locations between these updates of McAfee ePO? 

Second question - customer is running McAfee ePO on Windows Server 2012 RS and SQL Server 2016. We are planning to deploy test environment of ePO on Windows Server 2019 and SQL Server 2019. Does this affect the database table schema at all between these OS and database versions if we deploy McAfee ePO 5.10 Update 9? 

McAfee ePolicy Orchestrator 

2 Solutions

Accepted Solutions
cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 4

Re: ePO Database Schema Questions

Jump to solution

This is for the epo db schema - https://kc.mcafee.com/corporate/index?page=content&id=KB54753

This is for solidcore schema - https://kc.mcafee.com/agent/index?page=content&id=KB90401

Changing sql versions should not change the db schema as far as table/column names, etc.

That being said, the easiest way to find where data resides is to create a query in epo for the data you want to pull and save it.  Once the query is saved, select it, then go to actions, view sql.  That will tell you exactly what tables and columns are in place.

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

cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: ePO Database Schema Questions

Jump to solution

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

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

3 Replies
cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 4

Re: ePO Database Schema Questions

Jump to solution

This is for the epo db schema - https://kc.mcafee.com/corporate/index?page=content&id=KB54753

This is for solidcore schema - https://kc.mcafee.com/agent/index?page=content&id=KB90401

Changing sql versions should not change the db schema as far as table/column names, etc.

That being said, the easiest way to find where data resides is to create a query in epo for the data you want to pull and save it.  Once the query is saved, select it, then go to actions, view sql.  That will tell you exactly what tables and columns are in place.

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

davisoli
Level 8
Report Inappropriate Content
Message 3 of 4

Re: ePO Database Schema Questions

Jump to solution
I tried to look at the epo db schema linked below, "This content is retired and no longer available" https://kc.mcafee.com/corporate/index?page=content&id=KB54753. Is the epo db schema for the current version available elsewhere?
cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: ePO Database Schema Questions

Jump to solution

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

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