cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

ePO admin Task and Query Ownership

Jump to solution

Hello Mcafee family,

I need to take Tasks and Queries ownership from past ePO admins. Is there anyway way we can run an Update statement against the databse to update by user name?

I think it is time consuming to access each Tasks and queries  save under my name.

2 Solutions

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

Re: ePO admin Task and Query Ownership

Jump to solution

Here is a script one of our advanced team members wrote for server tasks - please validate any table names:

/*
Created by: Jeremy Stanley - Intel Security Sr Engineer, Support Engineering Operations
Date: 06/30/2015

Purpose:
This script can be used to change server task ownership from one user to another

Usage:
This query was tested for use with ePO 5.1.X.

You will need to update to lines of the script to reflect
the user account you are moving ownership away from as well
as the user account to are changing the ownership to.

Example:
Suppose you had a user account called "ToBeDeleted" which
owned one or more server tasks and you want to assign ownership
of these tasks to a user account named "NewTaskOwner". In that
scenario the script would look like this:

update OrionSchedulerTaskMT set UserId =
 (Select ID from OrionUsersMT where Name = 'ToBeDeleted')
where
 UserID = (Select ID from OrionUsersMT where Name = 'NewTaskOwner')
 
You can use this query to list out the usernames in the table:
select Name from OrionUsersMT

*/


update OrionSchedulerTaskMT set UserId =
 (Select ID from OrionUsersMT where Name = '<Username you are moving too>')
where
 UserID = (Select ID from OrionUsersMT where Name = '<Username you are moving from>')

-----------------------------------------

You can use KB83096 to determine current task and query ownership.  You can change the created by using same method as above. 

I don't believe it is necessary to take ownership of queries that are publicly shared.

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 cdinet
McAfee Employee
Report Inappropriate Content
Message 4 of 8

Re: ePO admin Task and Query Ownership

Jump to solution

Let me know if that fixes it for you.

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?

7 Replies
McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 2 of 8

Re: ePO admin Task and Query Ownership

Jump to solution

Here is a script one of our advanced team members wrote for server tasks - please validate any table names:

/*
Created by: Jeremy Stanley - Intel Security Sr Engineer, Support Engineering Operations
Date: 06/30/2015

Purpose:
This script can be used to change server task ownership from one user to another

Usage:
This query was tested for use with ePO 5.1.X.

You will need to update to lines of the script to reflect
the user account you are moving ownership away from as well
as the user account to are changing the ownership to.

Example:
Suppose you had a user account called "ToBeDeleted" which
owned one or more server tasks and you want to assign ownership
of these tasks to a user account named "NewTaskOwner". In that
scenario the script would look like this:

update OrionSchedulerTaskMT set UserId =
 (Select ID from OrionUsersMT where Name = 'ToBeDeleted')
where
 UserID = (Select ID from OrionUsersMT where Name = 'NewTaskOwner')
 
You can use this query to list out the usernames in the table:
select Name from OrionUsersMT

*/


update OrionSchedulerTaskMT set UserId =
 (Select ID from OrionUsersMT where Name = '<Username you are moving too>')
where
 UserID = (Select ID from OrionUsersMT where Name = '<Username you are moving from>')

-----------------------------------------

You can use KB83096 to determine current task and query ownership.  You can change the created by using same method as above. 

I don't believe it is necessary to take ownership of queries that are publicly shared.

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: ePO admin Task and Query Ownership

Jump to solution

Great! this is what I was looking for. I have few past admins that I need to cleanup.

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

Re: ePO admin Task and Query Ownership

Jump to solution

Let me know if that fixes it for you.

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: ePO admin Task and Query Ownership

Jump to solution

@cdinet , I have successfully transferred the tasks and Queries to my username, but when I login I don't see those queries or tasks. 

Database on the other hand shows ownership belong to me.

McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 6 of 8

Re: ePO admin Task and Query Ownership

Jump to solution

Please open a ticket so we can look at this for you.

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: ePO admin Task and Query Ownership

Jump to solution

I have created the ticket.

Re: ePO admin Task and Query Ownership

Jump to solution

I solved my own issue. Updated the groupid to show for my login.

More McAfee Tools to Help You

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