Endpoint Protection

I have configure the setting to delete the inactive client after the 30days. That is approved.

Still i have seen a duplication of data entry in server.

How can i find the duplication?

Any query to find it?

You can decrease the days from 30 days to remove it.

I know that if i change it then it will be delete but i need other option because i have not access to change it.

Check the sql queryto find it

https://www-secure.symantec.com/connect/forums/sql-querys-database?page=0#comment-6757241

https://www-secure.symantec.com/connect/forums/sepm-duplicates-query

From Ian_C:

DECLARE @TimeZoneDiff int   
SELECT @TimeZoneDiff = datediff(minute, getutcdate(), getdate())

SELECT UPPER([COMPUTER_NAME])
   , [COMPUTER_ID]
   , [HARDWARE_KEY]
   ,[CURRENT_LOGIN_USER]
   , dateadd(minute, @TimeZoneDiff, dateadd(second, [TIME_STAMP]/1000, '01/01/1970')) as [Time Stamp]
   ,[IP_ADDR1_TEXT]
FROM [V_SEM_COMPUTER]
WHERE [COMPUTER_NAME] in
   (
      SELECT [COMPUTER_NAME]
      FROM [V_SEM_COMPUTER]
      WHERE [DELETED] = 0
      GROUP BY [COMPUTER_NAME]
      HAVING COUNT([COMPUTER_NAME]) >1
   )
ORDER BY [COMPUTER_NAME]
   , [Time Stamp] DESC