CPU Core Count

[Hagai Nachmani]

Hi Experts,
I found out that the VM core count is not accurate, when viewing Inv_HW_Processor.
Well, to be more precise, when viewing Inv_HW_Processor - the count is in multirow per each CPU on the target, but when combining the Inv_HW_Processor with vComputer, and wishing to get only 1 appearance per each target, you have to choose "Select Distinct" and then you get false result, since you see only 1 row of a target.

Question is:
is there a way to view the sum total of cores on a machine in any of the ITMS tables, so I could join this table into vComputer to see IP / hostname and accurate number of cores?

tnx,
Hagai

[Igor Perevozchikov]

Hi Hagai!

You can always create any required report from ITMS Views page

Just click there required filter or "All Computers", set that they are managed=1 and open report builder to add additional columns or associations.

Here is example

And here is example SQL query which can be used for new SQL Report

SELECT DISTINCT
[vri1_Computer].[Guid] AS [Guid],
[vri1_Computer].[Name] AS [Name],
[vri1_Computer].[IsManaged] AS [Managed],
[dca2_AeX AC TCPIP].[IP Address] AS [IP Address],
[dca3_AeX AC Identification].[Domain] AS [Domain],
[dca3_AeX AC Identification].[OS Name] AS [OS Name],
[dca4_Processor].[Number Of Cores] AS [Number Of Cores],
[dca4_Processor].[Number Of Logical Processors] AS [Number Of Logical Processors],
[dca4_Processor].[Model] AS [Model]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN [Inv_AeX_AC_TCPIP] AS [dca2_AeX AC TCPIP]
ON ([vri1_Computer].[Guid] = [dca2_AeX AC TCPIP].[_ResourceGuid])
LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca3_AeX AC Identification]
ON ([vri1_Computer].[Guid] = [dca3_AeX AC Identification].[_ResourceGuid])
LEFT OUTER JOIN [Inv_HW_Processor] AS [dca4_Processor]
ON ([vri1_Computer].[Guid] = [dca4_Processor].[_ResourceGuid])
LEFT OUTER JOIN ([ScopeMembership] AS [ajs5_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs6_FolderBaseFolder]
ON ([ajs5_ScopeMembership].[ScopeCollectionGuid] = [ajs6_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs5_ScopeMembership].[ResourceGuid])
WHERE [vri1_Computer].[Guid] IN (

SELECT computer.[Guid] FROM
(
SELECT
[vri1_Computer].[Guid]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN ([ScopeMembership] AS [ajs2_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs3_FolderBaseFolder]
ON ([ajs2_ScopeMembership].[ScopeCollectionGuid] = [ajs3_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs2_ScopeMembership].[ResourceGuid])
WHERE
(
(
([ajs3_FolderBaseFolder].[ParentFolderGuid] = '91c68fcb-1822-e793-b59c-2684e99a64cd')
AND
([vri1_Computer].[IsManaged] = 1)
)
)

) AS computer
INNER JOIN fnGetTrusteeScopedResourcesByType('493435f7-3b17-4c4c-b07f-c23e7ab7781f','%TrusteeScope%',1) AS [fnGTSR_3] ON computer.[Guid] = [fnGTSR_3].[ResourceGuid]
INNER JOIN vComputer AS [vCMP_4] ON computer.[Guid] = [vCMP_4].[Guid]

)
GROUP BY
[vri1_Computer].[IsManaged],
[dca2_AeX AC TCPIP].[IP Address],
[dca3_AeX AC Identification].[Domain],
[dca3_AeX AC Identification].[OS Name],
[dca4_Processor].[Number Of Logical Processors],
[dca4_Processor].[Number Of Cores],
[dca4_Processor].[Model],
[vri1_Computer].[Guid],
[vri1_Computer].[Name]
ORDER BY
[Managed],
[IP Address],
[Domain],
[OS Name],
[Number Of Logical Processors],
[Number Of Cores],
[Model]

Thanks,

IP.

------------------------------
[JobTitle]
[CompanyName]
[State]
------------------------------

[Hagai Nachmani]

Thank you Igor,
will test and see how to customize it as suggested.

tnx,
Hagai