vmware vm nic type

[mcmcjin]

I know we can probably get this data from powercli but I was wondering if it would be possible to make a report in LS to be able to tell me all the nic types of our vms. IE E1000 E1000E or VMXNET3? Is any of this data gathered by lansweeper?

[brandon_jones]

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

[mcmcjin]

This also returned 0 results.

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

[prighi61]

You can left out the

Inner Join lansweeperdb.dbo.tblNetworkClient On tblassets.AssetID = tblNetworkClient.AssetID

(and the tblNetworkClient.Manufacturer field)
or change it into

Left outer Join lansweeperdb.dbo.tblNetworkClient On tblassets.AssetID = tblNetworkClient.AssetID

[brandon_jones]

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

[mcmcjin]

This returned 0 results.

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