Video Screencast Help

How can i find the duplication

Created: 24 Jul 2014 • Updated: 11 Aug 2014 | 4 comments
This issue has been solved. See solution.

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?

Comments 4 CommentsJump to latest comment

Sumit G's picture

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

Regards

Sumit G.

SOLUTION
devdat's picture

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.

.Brian's picture

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

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

SOLUTION