Calculate your network's computing power

[Esben_D]

The report below will calculate an estimate of your network's total computing power based on the information available in Lansweeper.

You can find 2 reports below which can be used depending on the Lansweeper version you are using. The Lansweeper 6 report combines the total computing power of Windows, Linux and Macs.
The Lansweeper 7 reports adds VMware server computing power which is new information that is scanned in LS7.

The calculation used to achieve the numbers in the report is as follows:
Performance in TFlops = ((CPU speed in GHz) x (number of CPU cores, if available) x 16) / 1000

Lansweeper 6 report:

Select Top 1000000 (Case
    When TflopsWindows.TFlops Is Null Then 0
    Else TflopsWindows.TFlops
  End) As TflopsWindows,
  (Case
    When TflopsLinux.TFlops Is Null Then 0
    Else TflopsLinux.TFlops
  End) As TflopsLinux,
  (Case
    When TflopsMac.TFlops Is Null Then 0
    Else TflopsMac.TFlops
  End) As TflopsMac,
  ((Case
    When TflopsWindows.TFlops Is Null Then 0
    Else TflopsWindows.TFlops
  End) + (Case
    When TflopsLinux.TFlops Is Null Then 0
    Else TflopsLinux.TFlops
  End) + (Case
    When TflopsMac.TFlops Is Null Then 0
    Else TflopsMac.TFlops
  End)) As TflopsTotal
From (Select Sum((Cast(tblProcessor.MaxClockSpeed / 1000 As decimal(18,2)) *
        tblProcessor.NumberOfCores * 16) / 1000) As TFlops
      From tblAssets
        Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsWindows,
  (Select Sum((Cast(SubString(tblLinuxProcessors.MaxSpeed, 0, 5) /
        1000 As decimal(18,2)) * 4 * 16) / 1000) As TFlops
      From tblAssets
        Inner Join tblLinuxProcessors On tblAssets.AssetID =
          tblLinuxProcessors.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsLinux,
  (Select Sum(((Cast(SubString(Replace(tblMacHwOverview.CPUSpeed, ',',
        ''), 0, 4) As decimal(18,2)) / 10) * tblMacHwOverview.NrOfCPUs * 16) /
        1000) As TFlops
      From tblAssets
        Inner Join tblMacHwOverview On
          tblAssets.AssetID = tblMacHwOverview.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsMac

Lansweeper 7 report:

Select Top 1000000 (Case
    When TflopsWindows.TFlops Is Null Then 0
    Else TflopsWindows.TFlops
  End) As TflopsWindows,
  (Case
    When TflopsLinux.TFlops Is Null Then 0
    Else TflopsLinux.TFlops
  End) As TflopsLinux,
  (Case
    When TflopsMac.TFlops Is Null Then 0
    Else TflopsMac.TFlops
  End) As TflopsMac,
  (Case
    When TflopsESXi.TFlopsVM Is Null Then 0
    Else TflopsESXi.TFlopsVM
  End) As TflopsESXi,
  ((Case
    When TflopsWindows.TFlops Is Null Then 0
    Else TflopsWindows.TFlops
  End) + (Case
    When TflopsLinux.TFlops Is Null Then 0
    Else TflopsLinux.TFlops
  End) + (Case
    When TflopsMac.TFlops Is Null Then 0
    Else TflopsMac.TFlops
  End) + (Case
    When TflopsESXi.TFlopsVM Is Null Then 0
    Else TflopsESXi.TFlopsVM
  End)) As TflopsTotal
From (Select Sum((Cast(tblProcessor.MaxClockSpeed / 1000 As decimal(18,2)) *
        tblProcessor.NumberOfCores * 16) / 1000) As TFlops
      From tblAssets
        Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsWindows,
  (Select Sum((Cast(SubString(tblLinuxProcessors.MaxSpeed, 0, 5) /
        1000 As decimal(18,2)) * 4 * 16) / 1000) As TFlops
      From tblAssets
        Inner Join tblLinuxProcessors On tblAssets.AssetID =
          tblLinuxProcessors.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsLinux,
  (Select Sum(((Cast(SubString(Replace(tblMacHwOverview.CPUSpeed, ',',
        ''), 0, 4) As decimal(18,2)) / 10) * tblMacHwOverview.NrOfCPUs * 16) /
        1000) As TFlops
      From tblAssets
        Inner Join tblMacHwOverview On
          tblAssets.AssetID = tblMacHwOverview.AssetID
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
      Where tblAssetCustom.Model Not Like '%virtual%') As TflopsMac,
  (Select Sum((Cast(tblVmwareInfo.CpuMhz / 1000 As decimal(18,2)) *
        tblVmwareInfo.numCpuCores * 16) / 1000) As TFlopsVM
      From tblAssets
        Inner Join tblVmwareInfo On tblAssets.AssetID = tblVmwareInfo.AssetID)
  As TflopsESXi

[dshu]

Teraflops Total : 348.226560


A little way to go....

[Rudamento]

dshu wrote:
Teraflops Total : 348.226560


A little way to go....

Got ya beat, we have a whopping 50!

[jer007]

Rudamento wrote:

dshu wrote:
Teraflops Total : 348.226560


A little way to go....

Got ya beat, we have a whopping 50!

Amatures, try flying with a whopping 7.3!