
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-15-2016 03:59 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2016 02:26 PM
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
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
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2016 02:26 PM
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
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
