Wednesday, September 29, 2010

Query to find renamed computers in the environment

SELECT a.Name0 as 'discovered Name', a.ResourceID,b.Name0 as 'Name from recent inventory',
b.TimeStamp FROM v_R_System as a
INNER JOIN v_GS_System as b on a.ResourceID = b.ResourceID
WHERE a.Name0 <> b.Name0

Description: This query compares the machine name which got discovered, with the machine name got updated through recent inventory.

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home