topic Which McAfee EPO server database you are using for SQL query required by McAfee addon in DB Connect app in All Apps and Add-ons https://community.splunk.com/t5/All-Apps-and-Add-ons/Which-McAfee-EPO-server-database-you-are-using-for-SQL-query/m-p/470316#M57795 <P>After ePO is upgraded to the latest version, a new SQL database is created in addition to the existing ePO database (<STRONG>ePO_Servername</STRONG>) with the format: <STRONG>ePO_Servername_Events</STRONG> .</P> <P>I am getting the results of the SQL query successfully when I chose <STRONG>ePO_servername</STRONG> database as it seems to have all the tables required for join operation as below.<BR /> • EPOEvents<BR /> • EPOLeafNode <BR /> • EPOProdPropsView_VIRUSCAN <BR /> • EPOComputerProperties <BR /> • EPOEventFilterDesc</P> <P>However, the DBA says I should use <STRONG>ePO_servername_Events</STRONG> database, but when I use this DB, all I get is the <STRONG>EPOEvents</STRONG> table.</P> <P>I am sure there might be few here who have had to go through this same problem. Can you please share which DB you chose or how you made this work ?</P> <P>Thanks in advance. </P> Wed, 30 Sep 2020 05:36:34 GMT damode 2020-09-30T05:36:34Z Which McAfee EPO server database you are using for SQL query required by McAfee addon in DB Connect app https://community.splunk.com/t5/All-Apps-and-Add-ons/Which-McAfee-EPO-server-database-you-are-using-for-SQL-query/m-p/470316#M57795 <P>After ePO is upgraded to the latest version, a new SQL database is created in addition to the existing ePO database (<STRONG>ePO_Servername</STRONG>) with the format: <STRONG>ePO_Servername_Events</STRONG> .</P> <P>I am getting the results of the SQL query successfully when I chose <STRONG>ePO_servername</STRONG> database as it seems to have all the tables required for join operation as below.<BR /> • EPOEvents<BR /> • EPOLeafNode <BR /> • EPOProdPropsView_VIRUSCAN <BR /> • EPOComputerProperties <BR /> • EPOEventFilterDesc</P> <P>However, the DBA says I should use <STRONG>ePO_servername_Events</STRONG> database, but when I use this DB, all I get is the <STRONG>EPOEvents</STRONG> table.</P> <P>I am sure there might be few here who have had to go through this same problem. Can you please share which DB you chose or how you made this work ?</P> <P>Thanks in advance. </P> Wed, 30 Sep 2020 05:36:34 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Which-McAfee-EPO-server-database-you-are-using-for-SQL-query/m-p/470316#M57795 damode 2020-09-30T05:36:34Z