ePO admin Task and Query Ownership

[User16096767]

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.

[cdinet · Accepted 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.

[User16096767]

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

[cdinet · Accepted solution]

Let me know if that fixes it for you.

[User16096767]

@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.

[cdinet]

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

[User16096767]

I have created the ticket.

[User16096767]

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