‎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
‎11-13-2019 12:11 PM
‎07-08-2019 12:35 PM
‎07-05-2019 01:51 PM
‎02-18-2019 04:48 PM
‎10-30-2018 07:08 PM
‎10-24-2018 12:01 AM
‎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?
‎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?
‎10-24-2018 02:46 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now