cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted

Need to delete an old ePO admin but they own many reports and queries that will get deleted

Jump to solution
Need to delete an old ePO admin but they own many reports and queries that will get deleted if I delete their account. The account has been disabled for now but will need to be removed. How can I take ownership of queries, reports and server tasks without re-creating them?
1 Solution

Accepted Solutions
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 7

Re: Need to delete an old ePO admin but they own many reports and queries that will get deleted

Jump to solution

For server tasks, you only have to edit and save them, then ownership would change to you.  You don't need to actually make any changes.  If there are a large number of them, we can provide a script to change them through sql.  That would require finding the user id of the account in question and the one you want to change it to.  Once you get that script, you could do the same for the orionquerymt table to change ownership.  I don't see where the reports are owned by anyone, just the queries used to run the reports.  If the report is not in the shared groups where it is accessible, then you might need to log in as that user and move any private queries and reports.  

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?

View solution in original post

6 Replies
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 7

Re: Need to delete an old ePO admin but they own many reports and queries that will get deleted

Jump to solution

For server tasks, you only have to edit and save them, then ownership would change to you.  You don't need to actually make any changes.  If there are a large number of them, we can provide a script to change them through sql.  That would require finding the user id of the account in question and the one you want to change it to.  Once you get that script, you could do the same for the orionquerymt table to change ownership.  I don't see where the reports are owned by anyone, just the queries used to run the reports.  If the report is not in the shared groups where it is accessible, then you might need to log in as that user and move any private queries and reports.  

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?

View solution in original post

Highlighted
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 3 of 7

Re: Need to delete an old ePO admin but they own many reports and queries that will get deleted

Jump to solution

Hi mate,

would it be possible to provide me with the script?

We are from time to time facing the same problem.

 

Best regards
Dan
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 7

Re: Need to delete an old ePO admin but they own many reports and queries that will get deleted

Jump to solution

Sent you private message.

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?

Highlighted

Re: Need to delete an old ePO admin but they own many reports and queries that will get deleted

Jump to solution

I know this post is a little old, but I would also like to request a copy of this script.  We regularly face this scenario.  

Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 6 of 7

Re: Need to delete an old ePO admin but they own many reports and queries that will get deleted

Jump to solution

see attached

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?

Highlighted

Re: Need to delete an old ePO admin but they own many reports and queries that will get deleted

Jump to solution

Thank you very much for the prompt reply!

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

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