Renaming Client name in SEPM console.

Hello All,

I had this request from one of ours customers they wanted to change the computer name inside the SEPM console.Under clients tab.
we all have naming conventions to servers like XXINDDC01 XXINDEX01, meaning Domain controller and exchange server the same names appear in SEPM console too.
I have tried this in my test environment and it really works still monitoring to see if any issues in case of virus updates and communication issues, i'm pretty sure that this should work.

The first task was to find where the computer name information is stored.
I have uploaded the embedded DB tool editor to view SEM5.db under the downloads section, you may download that if you are using embedded DB, in my case if was Embedded DB.

The table which holds the computer name is SEM_COMPUTER

once I found this table all i need to use was a simple SQL query to update the fields.

you can find the DBISQLC.exe under

C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32

To change the computer name, follow the steps below:

Click on Start > Run.
Type services.msc
Click Ok.
Verify that the "Symantec Embedded Database Service" is running.
Stop the "Symantec Endpoint Protection Manager Service."
Exit the Services window.
Browse to:
C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32\
Double-click on dbisqlc.exe to launch the application.
Click the Login tab.
Type DBA as the username and enter the current complex password.
Click on the Database tab.
Enter the path to the database in the field labeled "Database file:" The default path is:
C:\Program Files\Symantec\Symantec Endpoint Protection Manager\db\sem5.db
Click Ok to log into the embedded database.
In the "Command" input box, type:

UPDATE SEM_COMPUTER
SET COMPUTER_NAME ='hP'
WHeRE COMPUTER_NAME = 'computertest1'

where 'hp' is the new name I wanted for the client and computertest1 was the existing name.

tried it in a test environment and it works.

Please try this in a test environment before attempting in production as your are directly editing DB.