Community FAQ
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?

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now