cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
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
12 REPLIES 12
dshu
Engaged Sweeper III
Teraflops Total : 348.226560


A little way to go....
Rudamento
Engaged Sweeper II
dshu wrote:
Teraflops Total : 348.226560


A little way to go....


Got ya beat, we have a whopping 50!
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!

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now