dmpippin
5/10/2013 - 7:17 PM

Developing: this script is to clear out as much redundant data in computer_checkin_history table.

Developing: this script is to clear out as much redundant data in computer_checkin_history table.

checkin_history_clean
content_copyfile_download
USE SEPM
GO

SELECT 
       USER_NAME
      ,MAX(COMPUTER_NAME)
      ,MAX(IP_ADDR1)
      ,(convert(char(10),LAST_UPDATE_TIME,120)) as 'CheckIn Time grouped by day'
      ,MAX(LAST_CONNECTED_IP_ADDR)
      ,MAX(AGENT_VERSION)
      ,MAX(VERSION)
      ,MAX(REGIONAL_COLLECTOR)

FROM 

[SEPM].[dbo].[COMPUTER_CHECKIN_HISTORY] 
    where USER_NAME = 'E682523'
    group by user_name,(convert(char(10),LAST_UPDATE_TIME,120))
 
 order by (convert(char(10),LAST_UPDATE_TIME,120)) desc