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.
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