Can someone help me with this report
Select Distinct Top 1000000 tblcomputers.Computer, tblRegistry.Computername, tblRegistry.Value, tblRegistry.Lastchanged, tblcomputers.LastknownIP From tblRegistry Inner Join tblcomputers On tblcomputers.Computername = tblRegistry.Computername Where tblRegistry.Valuename Like 'DF Status' And tblRegistry.Regkey Like 'HKEY_LOCAL_MACHINE\SOFTWARE\Faronics\Deep Freeze 6'
It works but says incorrect syntax near 'Freeze' when I save the report.