cancel
Showing results for 
Search instead for 
Did you mean: 
Reliable Contributor vnaidu
Reliable Contributor
Report Inappropriate Content
Message 1 of 4

On Access Scan from SQL Database

Jump to solution

Hi,

In the SQL Database which table holds the On Access Scan default, low and high risk process including the file and folder exclusions, I would like to export them to an excel sheet. Can some one help?

 

Regards,

Venu
2 Solutions

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

Re: On Access Scan from SQL Database

Jump to solution

You can go to the epo console and export the policies.  In the exported xml file, you can get that data from there.  The problem with getting it from sql is that there are too many related tables and it is not in an easily understandable with context as it is just raw data.  When you export the policies, it is a list of all your policies for that product.  To eliminate the unnecessary data from other policies, you can export just an individual on access default and high/low risk policy to view the data you want.

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?

Reliable Contributor vnaidu
Reliable Contributor
Report Inappropriate Content
Message 3 of 4

Re: On Access Scan from SQL Database

Jump to solution

@cdinet For now, I have exported the XML file and removed the unwanted data and got the total processes, however it was kind a hectic as I had 705 policies. Any ways, I had completed that already. But also thought of pulling the same data from SQL. No problems as I got the entire list.

Thank you for the time Cdinet...

 

Regards,

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

Re: On Access Scan from SQL Database

Jump to solution

You can go to the epo console and export the policies.  In the exported xml file, you can get that data from there.  The problem with getting it from sql is that there are too many related tables and it is not in an easily understandable with context as it is just raw data.  When you export the policies, it is a list of all your policies for that product.  To eliminate the unnecessary data from other policies, you can export just an individual on access default and high/low risk policy to view the data you want.

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?

Reliable Contributor vnaidu
Reliable Contributor
Report Inappropriate Content
Message 3 of 4

Re: On Access Scan from SQL Database

Jump to solution

@cdinet For now, I have exported the XML file and removed the unwanted data and got the total processes, however it was kind a hectic as I had 705 policies. Any ways, I had completed that already. But also thought of pulling the same data from SQL. No problems as I got the entire list.

Thank you for the time Cdinet...

 

Regards,

Venu
McAfee Employee hem
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: On Access Scan from SQL Database

Jump to solution

https://community.mcafee.com/t5/ePolicy-Orchestrator/SQL-Query-Help-needed/m-p/608899#M60627

 

 

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?
ePO Support Center Plug-in
Check out the new ePO Support Center. Simply access the ePO Software Manager and follow the instructions in the Product Guide for the most commonly used utilities, top known issues announcements, search the knowledgebase for product documentation, and server status and statistics – all from within ePO.