Share Folder Report

[Srikanth08]

Hi,

I need to create report for Visible and Invisible shares in network with below details computer name, share name, user name, display name and IP address

[Srikanth08]

That worked Wonders...Thank You

[Daniel_B · Accepted solution]

Please use the report below for the information you are after. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
- Updating to Lansweeper 5.3, if you haven't already. Lansweeper 5.3 includes a database dictionary, which is linked at the top of the report builder.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblADusers.Displayname,
  tblSharesUni.Name As [Share name],
  tblSharesUni.Path,
  Case tblSharesUni.Type When 0 Then 'Disk drive'
    When 2147483648 Then 'Disk Drive Admin' When 2147483651 Then 'IPC Admin'
  End As [share type],
  tblAssets.IPAddress,
  tblShares.Lastchanged,
  tsysOS.Image As icon
From tblShares
  Inner Join tblAssets On tblShares.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblSharesUni On tblShares.ShareUniqueID =
    tblSharesUni.ShareUniqueID
  Left Join tblADusers On tblADusers.Username = tblAssets.Username And
    tblADusers.Userdomain = tblAssets.Userdomain
Where tblAssetCustom.State = 1 And tblSharesUni.Type In (0, 2147483648,
  2147483651)
Order By tblAssets.AssetName,
  [Share name]