→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Srikanth08
Engaged Sweeper II
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
Regards, Srikanth08
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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]

View solution in original post

2 REPLIES 2
Srikanth08
Engaged Sweeper II
That worked Wonders...Thank You
Regards, Srikanth08
Daniel_B
Lansweeper Alumni
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]