Report for Client network bandwith

[hellmold]

Dear all,

is there a finished report or can somebody write a report for me, which show the network bandwith of all clients and servers and assetts (e.g 100/1000 Mbit).

Warm regards
Philip

[stahly8 · Accepted solution]

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tsysOS.OSname As OS,
tblAssets.IPAddress,
tblNetworkAdapter.Name As NIC,
tblNetworkAdapter.NetConnectionID As Connection,
tblNetworkAdapter.MACAddress,
tblNetworkAdapter.Speed As SpeedInMb
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblNetworkAdapter On tblAssets.AssetID = tblNetworkAdapter.AssetID
Where tblNetworkAdapter.NetConnectionID Not Like '%virtualbox%' And
tblAssetCustom.State = 1 And tblNetworkAdapter.NetEnabled = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
NIC