Endpoint Protection

Hi People,

Can anyone please assist me what is the SQL script that I need to execute to see the current version of the SQL server database schema ?

I need to know whether my SQL Server DB has been updated successfully or not by the SEPM v12.1 RU1 installer as I'm having a problem at the moment.

Thanks,

DG

Running the same SQL server script below now doesn't show up anything while previously it shows all of my client information:

SELECT computer_name, 
       Dateadd(s, CONVERT(BIGINT, [time_stamp]) / 1000, '01-01-1970 00:00:00') 
       AS 
       [Time Stamp], 
       Cast((CASE WHEN ip_addr1 < 0 THEN 0xFFFFFFFF + ip_addr1 ELSE ip_addr1 END 
       / 256 
       / 256 / 256) & 0xFF AS VARCHAR) 
       + '.' + Cast((CASE WHEN ip_addr1 < 0 THEN 0xFFFFFFFF + ip_addr1 ELSE 
       ip_addr1 
       END / 256 / 256) & 0xFF AS VARCHAR) 
       + '.' + Cast((CASE WHEN ip_addr1 < 0 THEN 0xFFFFFFFF + ip_addr1 ELSE 
       ip_addr1 
       END / 256) & 0xFF AS VARCHAR) + '.' 
       + Cast( CASE WHEN ip_addr1 < 0 THEN 0xFFFFFFFF + ip_addr1 ELSE ip_addr1 
       END & 
       0xFF AS VARCHAR) 
       AS LOCAL_IP_ADDRESS 
FROM   sem_computer 
WHERE  computer_name IN (SELECT computer_name 
                         FROM   sem_computer 
                         GROUP  BY computer_name 
                         HAVING ( Count(computer_name) > 1 )) 

Have you tried running the DBvalidator that comes with SEPM? I believe it will show you the version. It will also show if there are any errors in the schema.

http://www.symantec.com/business/support/index?page=content&id=TECH104892&actp=search&viewlocale=en_US&searchid=1343327212097

You can also see try querying the LICENSEtable it should show the current version.

Dushan

The script above will only display computers that are duplicated in your environment. That's what the last line [HAVING (count(computer_name)>1))] actually means. If you've cleaned out all duplicates, this query will return no results.

Running the query you posted without the WHERE clause will give you all computer objects defined in the DB (both active & inactive).

Yes, that is more detailed and the official way to test it.

Thanks for all of the response,