Notification

Icon
Error

Calculate your network's computing power

Posted: Tuesday, October 23, 2018 1:45:41 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,738
1
Like
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:
Code:
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:
Code:
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
#1dshu Member Posts: 25  
posted: 10/23/2018 3:29:08 PM(UTC)
Teraflops Total : 348.226560


A little way to go....
Rudamento
#2Rudamento Member Posts: 10  
posted: 10/23/2018 3:55:23 PM(UTC)
Originally Posted by: dshu Go to Quoted Post
Teraflops Total : 348.226560


A little way to go....


Got ya beat, we have a whopping 50!
jer007
#3jer007 Member Posts: 1  
posted: 10/23/2018 4:07:27 PM(UTC)
Originally Posted by: Rudamento Go to Quoted Post
Originally Posted by: dshu Go to Quoted Post
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!
ctr
#4ctr Member Posts: 2  
posted: 10/23/2018 11:01:16 PM(UTC)
Well, with LanSweeper 7 running on SQL Server I receive this errormessage when trying to safe the 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 Conversion failed when converting the nvarchar value 'Unkn' to data type int.

Any advise?
FixitDave
#5FixitDave Member Posts: 49  
posted: 10/24/2018 9:58:27 AM(UTC)
Originally Posted by: ctr Go to Quoted Post
Well, with LanSweeper 7 running on SQL Server I receive this errormessage when trying to safe the 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 Conversion failed when converting the nvarchar value 'Unkn' to data type int.

Any advise?


I also got an error, so only included Windows devices...

Our score was 326.558720
ctr
#6ctr Member Posts: 2  
posted: 10/24/2018 1:46:41 PM(UTC)
Thanks for that idea, LS failed to include Linux so I erased Linux from the SQL Statement:


Select Top 1000000 (Case
When TflopsWindows.TFlops Is Null Then 0
Else TflopsWindows.TFlops
End) As TflopsWindows,
(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 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(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
Esben.D
#7Esben.D Member Administration Original PosterPosts: 1,738  
posted: 10/24/2018 4:15:26 PM(UTC)
Originally Posted by: ctr Go to Quoted Post
Well, with LanSweeper 7 running on SQL Server I receive this errormessage when trying to safe the report:

Conversion failed when converting the nvarchar value 'Unkn' to data type int.

Any advise?


It seems that one of your assets has the value 'Unkn' stored in the CPU speed field. Since the report tried to convert it to a number, it fails. Easiest fix would be to either remove the asset type which is causing the issue from the report.
marrngtn
#8marrngtn Member Posts: 12  
posted: 10/30/2018 7:08:54 PM(UTC)
I get:
Error: Error converting data type nvarchar to numeric.
CVannest
#9CVannest Member Posts: 14  
posted: 2/18/2019 4:48:56 PM(UTC)
Pretty cool report!
Got 1016.213440....
GBInnovation
#10GBInnovation Member Posts: 1  
posted: 7/5/2019 12:51:22 PM(UTC)
This report doesn't work anymore with Last version of Lansweeper :
Conversion failed when converting the nvarchar value 'Unkn' to data type int.

It was funny report until it died...:-(
stiwa
#11stiwa Member Posts: 64  
posted: 7/8/2019 11:35:14 AM(UTC)
Still working for me, using v. 7.1.115.3

Active Discussions

Lansweeper non-active computer report
by  Apaulcolypse   Go to last post Go to first unread
Last post: 7/19/2019 5:16:21 PM(UTC)
Lansweeper Report for showing CPUs below or above
by  GBA Craig  
Go to last post Go to first unread
Last post: 7/18/2019 3:38:41 PM(UTC)
Lansweeper Hardware list
by  GBA Craig   Go to last post Go to first unread
Last post: 7/18/2019 3:34:43 PM(UTC)
Lansweeper Top 10 users submitting tickets
by  LGuth  
Go to last post Go to first unread
Last post: 7/17/2019 9:29:44 PM(UTC)
Lansweeper Microsoft Patch Tuesday Report - July 2019
by  Noobmode   Go to last post Go to first unread
Last post: 7/17/2019 8:48:08 PM(UTC)
Lansweeper Custom Scanning - file not existing
by  Bruce Garoutte  
Go to last post Go to first unread
Last post: 7/17/2019 8:19:50 PM(UTC)
Lansweeper MouseJack vulnerability affected devices report
by  Viper   Go to last post Go to first unread
Last post: 7/16/2019 5:19:14 PM(UTC)
Lansweeper TPM support
by  Sander Eerdekens  
Go to last post Go to first unread
Last post: 7/16/2019 1:38:17 PM(UTC)