‎05-25-2021 12:08 AM
‎05-25-2021 03:15 PM
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblNetworkAdapter.Name As Name,
tblNetworkClient.Manufacturer,
tblNetworkAdapter.Manufacturer As Manufacturer1
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tblNetworkAdapter On tblassets.AssetID =
tblNetworkAdapter.AssetID
Inner Join lansweeperdb.dbo.tblNetworkClient On tblassets.AssetID =
tblNetworkClient.AssetID
Where tblNetworkAdapter.Manufacturer Like '%vmware%' And tblassetcustom.State =
1
‎05-25-2021 03:25 PM
Brandon wrote:
I pasted the incorrect report before. Try this:Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblNetworkAdapter.Name As Name,
tblNetworkClient.Manufacturer,
tblNetworkAdapter.Manufacturer As Manufacturer1
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tblNetworkAdapter On tblassets.AssetID =
tblNetworkAdapter.AssetID
Inner Join lansweeperdb.dbo.tblNetworkClient On tblassets.AssetID =
tblNetworkClient.AssetID
Where tblNetworkAdapter.Manufacturer Like '%vmware%' And tblassetcustom.State =
1
‎08-31-2021 10:54 AM
‎05-25-2021 02:40 PM
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblNetworkAdapter.Name As Name
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tblNetworkAdapter On tblassets.AssetID =
tblNetworkAdapter.AssetID
Inner Join lansweeperdb.dbo.tblNetworkClient On tblassets.AssetID =
tblNetworkClient.AssetID
Where tblassetcustom.State = 1
‎05-25-2021 03:07 PM
Brandon wrote:
See if this gives you the information that you need.Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblNetworkAdapter.Name As Name
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tblNetworkAdapter On tblassets.AssetID =
tblNetworkAdapter.AssetID
Inner Join lansweeperdb.dbo.tblNetworkClient On tblassets.AssetID =
tblNetworkClient.AssetID
Where tblassetcustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now