→ 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: 
hellmold
Engaged Sweeper
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
1 ACCEPTED SOLUTION
stahly8
Engaged Sweeper III
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

View solution in original post

1 REPLY 1
stahly8
Engaged Sweeper III
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