Visible Shared Folders Report

[jmzhs]

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!

[Daniel_B · Accepted solution]

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]

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]

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?