cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jmzhs
Engaged Sweeper II
We are using Lansweeper v. 5305 and I found the following report on the Lansweeper site

http://www.lansweeper.com/Forum/yaf_postst10172_Shares--Visible-shared-folders--Built-in.aspx#post386

When I build this new report within Lansweeper I get the following error.

Invalid SELECT statement. Unknown object name: "tblShares".: Unexpected token "tblShares" at line 0, column -1

Did the table name change in the version we are running? Could somebody assist? I'm trying to view a user's shared drive mappings as a reference point. Any advice would be appreciated. Thanks!
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
Not sure if there is a typo in your query. If no database table has been deleted, you should be able to run this report.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tsysOS.OSname,
tblSharesUni.Name,
tblSharesUni.Path,
tblShares.Lastchanged,
tsysOS.Image As icon
From tblShares
Inner Join tblAssets On tblAssets.AssetID = tblShares.AssetID
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSharesUni On tblShares.ShareUniqueID =
tblSharesUni.ShareUniqueID
Where Not (tblSharesUni.Name Like N'%$') And tblAssetCustom.State = 1 And
tblSharesUni.Type = 0
Order By tblAssets.AssetName


If you are still facing the same issue, could you send us a mail to support@lansweeper.com with a link to this forum topic and Program Files (x86)\Lansweeper\Service\errorlog.txt from your Lansweeper server.

View solution in original post

3 REPLIES 3
Daniel_B
Lansweeper Alumni
Not sure if there is a typo in your query. If no database table has been deleted, you should be able to run this report.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tsysOS.OSname,
tblSharesUni.Name,
tblSharesUni.Path,
tblShares.Lastchanged,
tsysOS.Image As icon
From tblShares
Inner Join tblAssets On tblAssets.AssetID = tblShares.AssetID
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSharesUni On tblShares.ShareUniqueID =
tblSharesUni.ShareUniqueID
Where Not (tblSharesUni.Name Like N'%$') And tblAssetCustom.State = 1 And
tblSharesUni.Type = 0
Order By tblAssets.AssetName


If you are still facing the same issue, could you send us a mail to support@lansweeper.com with a link to this forum topic and Program Files (x86)\Lansweeper\Service\errorlog.txt from your Lansweeper server.
jmzhs
Engaged Sweeper II
That was a fast reply thanks! Here's a screen shot


https://dl.dropboxusercontent.com/u/6763468/2015-06-03_9-08-48%20-%20Lansweeper.png

Thanks
Daniel_B
Lansweeper Alumni
We can't reproduce the issue on the latest version of Lansweeper. Could you attach a screenshot of the report query you entered into the report editor and the error message?