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,956
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: 26  
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: 51  
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,956  
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: 13  
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: 7  
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: 63  
posted: 7/8/2019 11:35:14 AM(UTC)
Still working for me, using v. 7.1.115.3
GBInnovation
#12GBInnovation Member Posts: 7  
posted: 11/13/2019 12:11:18 PM(UTC)
Some devices don't have cores reported and some other have unknow Frequency, it is a nightmare to have different Tabvle in the DB for CPU informations/ OS info etc..

My result for one of my environments :

4002.542080
12886.2720000
0.00000000
256.7680000
17145.582080

Active Discussions

Lansweeper iManage Client deployment
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 3:09:47 AM(UTC)
Lansweeper Missing hyperv host details for guest asset LAN-4130
by  danielm  
Go to last post Go to first unread
Last post: 12/7/2019 7:15:56 AM(UTC)
Lansweeper Lansweeper showing MAC address instead of name
by  crashff   Go to last post Go to first unread
Last post: 12/6/2019 10:26:25 PM(UTC)
Lansweeper Dell Warranty Lookup - Incorrect Information
by  Trenton Knew  
Go to last post Go to first unread
Last post: 12/6/2019 10:17:15 PM(UTC)
Lansweeper Incoming Email Parse
by  UEFT   Go to last post Go to first unread
Last post: 12/6/2019 5:46:22 PM(UTC)
Lansweeper SSH - Keyboard Interactive Authentication
by  KevinA-REJIS  
Go to last post Go to first unread
Last post: 12/6/2019 5:22:21 PM(UTC)
Lansweeper Custom OID Scanning / multible OIDs with wildcards
by  Esben.D  
Go to last post Go to first unread
Last post: 12/6/2019 11:57:18 AM(UTC)