Loading...

Knowledge Center


How to check which server tasks and queries a specific user created before deleting the user
Technical Articles ID:   KB83096
Last Modified:  9/25/2019

Environment

McAfee ePolicy Orchestrator (ePO) 5.x, 4.x

Summary

When deleting an ePO user, all server tasks and queries created by that user are deleted. This article describes how to determine which server tasks and queries a user created so you can back them up before deleting the user.

Solution

Run a SQL query to determine which server tasks a user created:

NOTE: It is not possible to determine which user created server tasks using the ePO console.
  1. Open Microsoft SQL Server Management Studio.
  2. Type the login and password information for the account specified and click Connect.
  3. Expand Databases.
  4. Right-click the ePO database (where the default name is ePO_<ePO_server_name>) and select New Query.
  5. Paste the following SQL statement into the query window:
     
    SELECT OrionSchedulerTask.Name, OrionSchedulerTask.USERID,OrionUsers.[name]
    FROM OrionSchedulerTask
    INNER JOIN OrionUsers
    on OrionSchedulerTask.USERID=ORIONUSERS.id
    ORDER BY OrionUsers.[name]
     
  6. Click Execute.
This query output contains three columns:
  • Name: Displays the name of the server task
  • USERID: Displays the ID number assigned to the user who created the server task
  • name: Displays the name of the user who created the server task

Solution

Run a SQL query to determine which queries a user created:

NOTE: It is not possible to determine which user created queries using the ePO console.

  1. Open Microsoft SQL Server Management Studio.
  2. Type the login and password information for the account specified and click Connect.
  3. Expand Databases.
  4. Right-click the ePO database (where the default name is ePO_<ePO_server_name>) and select New Query.
  5. Paste the following SQL statement into the query window:
  6.  
    SELECT * FROM [ePO_<ePO_server_name>].[dbo].[OrionQueryMT]where ModifiedBy = '<username>'
     
    where <ePO_server_name> is the ePO server name and <username> is the name of the user 
     
    NOTE: The above query will list created queries and modified queries for the user.
     
  7. Click Execute.
This query output contains columns including:
  • Name: Displays the name of the query
  • CreatedBy: Displays the name of the user who created the query
  • ModifiedBy: Displays the name of the user who modified the query

Rate this document

Glossary of Technical Terms


 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.