I do recall installing ITAnalytics a ways back. Haven't played around with it much, but I or it apparently setup a linked connection to my server. Should be able to use this without doing anything else, right? Here is how I am thinking this needs to be re-worked:
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
I am just not sure where to add what I would assume to be this line:
ITANALYTICS_SEP_SYMANTEC_CMDB_MYNAV_SEM5
Does it go under 'WHERE [DELETED] = 0
Thanks.