cancel
Showing results for 
Search instead for 
Did you mean: 

Queries on 'Server Tasks'

Jump to solution

Hi Experts,

We need to create queries on 'Server Tasks' (to identify Failed tasks) that run on 'Daily', 'Weekly' and "Monthy" schedules

For getting the 'Daily failed Server Task' csv report, I can use 1) shown below and schedule a CSV report.

But, how do I create queries for 'weekly' and 'monthly' tasks? I don't see any 'Schedule' filter.
Queries are required for us as we need CSV files for automation. Please advice.


1) For 'Result type' select 'Task Log Entries' > Chart type "Table" > For Columns choose 'Name', 'Start Date', 'End Date', 'Status' > For filter use 'Start Date 'Is within the last 1 Days'

1 Solution

Accepted Solutions
Highlighted
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 3 of 5

Re: Queries on 'Server Tasks'

Jump to solution

There is no filter to specify schedule type.  You would basically just have to look for all failed tasks within a desired time frame.

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?

4 Replies
Reliable Contributor vnaidu
Reliable Contributor
Report Inappropriate Content
Message 2 of 5

Re: Queries on 'Server Tasks'

Jump to solution

Dear @Ramprakash,

May be you can give it a try as per the below steps.

1. Task Log Entry.
2. Select Boolean Pie Chart
3. Select Configure Criteria
4. Name equals to the task name irrespective of monthly weekly schedule.
5. Status is Failed.
6. In the Filter, you can select the step 5 as well.
7. Now export the query to a CSV file, may be you can automate this via Server task.

I hope the above helps. 

Cheers!!!!!! 

 

Venu
Highlighted
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 3 of 5

Re: Queries on 'Server Tasks'

Jump to solution

There is no filter to specify schedule type.  You would basically just have to look for all failed tasks within a desired time frame.

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: Queries on 'Server Tasks'

Jump to solution

Are there any alternatives, probably pull from Mcafee database

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

Re: Queries on 'Server Tasks'

Jump to solution

Not that I am aware of.  There are several tables involved and a good dba could probably figure it out, but we don't write custom scripts like that.

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?

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