How to check which server tasks and queries were created by a specific user before deleting the user

Technical Articles ID: KB83096
Last Modified: 2023-07-18 10:14:52 Etc/GMT

Environment

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 1

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

NOTE: It isn't possible to determine which user created server tasks using the ePO console.

Open Microsoft SQL Server Management Studio.
Type the login and password information for the account specified and click Connect.
Expand Databases.
Right-click the ePO database (where the default name is ePO_<ePO_server_name>) and select New Query.
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]
Click Execute.

This query output contains three columns:

Name: Displays the name of the server task
USERID: Displays the ID assigned to the user who created the server task
name: Displays the name of the user who created the server task

Solution 2

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

NOTE: It isn't possible to determine which user created queries using the ePO console.

Open Microsoft SQL Server Management Studio.
Type the login and password information for the account specified and click Connect.
Expand Databases.
Right-click the ePO database (where the default name is ePO_<ePO_server_name>) and select New Query.
Paste the following SQL statement into the query window:
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 query above lists created queries and modified queries for the user.
Click Execute.

This query output contains columns including the following:

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

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

How to check which server tasks and queries were created by a specific user before deleting the user

Environment

Summary

Solution 1

Solution 2

Affected Products

Languages:

Title

Title

Knowledge Center

How to check which server tasks and queries were created by a specific user before deleting the user

Environment

Summary

Solution 1

Solution 2

Affected Products

Languages:

Choose your region

Title

Title