Hostname History

This query will display computers who host names changes.

Select
CS.Name0,
HCS.Name0,
HCS.TimeStamp
from
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_HS_COMPUTER_SYSTEM HCS on Cs.ResourceID = HCS.ResourceID
Where
CS.Name0 <> HCS.Name0