cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
poweld1
Champion Sweeper
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.
3 REPLIES 3
Hemoco
Lansweeper Alumni
The report works ok when I tested it with the space.
Did you do a line wrap after 'deep'?
poweld1
Champion Sweeper
Solved now, it didn't like a space in the report name.
poweld1
Champion Sweeper
Looks like it doesn't like the spaces, is there a character I can put in to make the query work?