![Esben_D Esben_D](https://community.lansweeper.com/legacyfs/online/forums_avatars/14060.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-23-2018 02:45 PM
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
- Labels:
-
Finished Reports
-
Report Center
![GBInnovation GBInnovation](https://community.lansweeper.com/html/assets/User_Avatar.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-13-2019 12:11 PM
My result for one of my environments :
4002.542080
12886.2720000
0.00000000
256.7680000
17145.582080
![stiwa stiwa](https://community.lansweeper.com/html/assets/User_Avatar.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-08-2019 12:35 PM
![GBInnovation GBInnovation](https://community.lansweeper.com/html/assets/User_Avatar.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-05-2019 01:51 PM
Conversion failed when converting the nvarchar value 'Unkn' to data type int.
It was funny report until it died...:-(
![CVannest CVannest](https://community.lansweeper.com/html/assets/User_Avatar.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2019 04:48 PM
Got 1016.213440....
![marrngtn marrngtn](https://community.lansweeper.com/legacyfs/online/forums_avatars/7033.jpg)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-30-2018 07:08 PM
Error: Error converting data type nvarchar to numeric.
![ctr ctr](https://community.lansweeper.com/html/assets/User_Avatar.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-24-2018 12:01 AM
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?
![Esben_D Esben_D](https://community.lansweeper.com/legacyfs/online/forums_avatars/14060.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-24-2018 05:15 PM
ctr wrote:
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.
![FixitDave FixitDave](https://community.lansweeper.com/legacyfs/online/forums_avatars/8957.jpg)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-24-2018 10:58 AM
ctr wrote:
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 ctr](https://community.lansweeper.com/html/assets/User_Avatar.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-24-2018 02:46 PM
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
![](/skins/images/C814C14E754F4012AB6B3098C075832D/responsive_peak/images/icon_anonymous_message.png)