‎07-28-2015 01:00 PM
Solved! Go to Solution.
‎07-28-2015 05:19 PM
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]
‎07-29-2015 06:03 AM
‎07-28-2015 05:19 PM
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]
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now