‎10-23-2018 02:45 PM
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
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
‎10-23-2018 04:29 PM
‎10-23-2018 04:55 PM
dshu wrote:
Teraflops Total : 348.226560
A little way to go....
‎10-23-2018 05:07 PM
Rudamento wrote:dshu wrote:
Teraflops Total : 348.226560
A little way to go....
Got ya beat, we have a whopping 50!
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now