Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-23-2011 12:03 PM
Upgraded to the latest version of Lansweeper and now new reports i've created don't display properly, if I click on this report I just created I get the following error message.
Report has an invalid syntax:
The object 'dbo.web40repNoSoftwareUnilauncher' does not exist in database 'lansweeperdb' or is invalid for this operation.
This is the query and it works fine through the builder
I created a duplicate report of another query and this new gives the same error message as above, but the existing report works fine.
Report has an invalid syntax:
The object 'dbo.web40repNoSoftwareUnilauncher' does not exist in database 'lansweeperdb' or is invalid for this operation.
This is the query and it works fine through the builder
Select Top 1000000 tblcomputers.Computername, tblcomputers.ComputerUnique, tblcomputers.Username, tblComputersystem.Manufacturer, tblComputersystem.Model, tblcomputers.LastknownIP, tblcomputers.Lastseen From tblcomputers Inner Join tblComputersystem On tblcomputers.Computername = tblComputersystem.Computername Inner Join tblOperatingsystem On tblcomputers.Computername = tblOperatingsystem.Computername Where tblcomputers.Computername Not In (Select tblsoftware.ComputerName From tblsoftware Where tblsoftware.softwareName = 'unilauncher') Order By tblcomputers.ComputerUnique
I created a duplicate report of another query and this new gives the same error message as above, but the existing report works fine.
Labels:
- Labels:
-
Archive
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-28-2011 08:49 PM
Latest version of Lansweeper has solved this for me. I just have to resave the reports.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-23-2011 04:37 PM
Can you please contact us by e-mail for this problem (lansweeper@hemoco.com)