Buenos días, tras la averia de un disco duro, necesitamos hacer la restauracion de un SEPM.

Vamos a instalarlo en una maquina virtual, pero nocesitamos conocer el nombre de host y site_server que tenia el SEPM averiado.

Solo disponemos de la instancia sql del la BBDD. No tenemos ningun sylink (cliente) no backup.

¿puede hacerse una query al sql para obtener los resultados?

Gracias

---------------------------------------------------------------------------------------------------------------------------------------------------

We have to do a recovery sepm,
 
For this we need need to know:
-and get the nameof the Site andhost name storedin a sql database.What is the query?
- Which is the proper procedure?We do not have backup.Only the instance DB

Regards

Find some SQL query

Compilation of SQL queries to the SEPM database

https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database

https://www-secure.symantec.com/connect/forums/sql-querys-database

Symantec Endpoint Protection 12.1: Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager

Did you follow the DR process?

Symantec Endpoint Protection 12.1: Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager

Did you check the sylink file of an offline client to see what it's pointing to?

This is the solution of support Symantec:

Select case when type = ‘SemServerList’ Then ‘Server’ WHEN type =‘SenSite’ Then ‘site’ END as \Type’, Name as ‘Name’ From basic_metadata where type =‘SemSite’ OR ype=‘SemServerList’ order by Type ASC, Name Asc

Thank to alls