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