Client Management Suite

I would need a report which displays the version of the service pack installed on each computers . I have tried with the report builder to use [PAtch windows].[service Pack] but the results are incorrect as it displays that 697 computers have service pack3 installed but I know by another platform Bigfix that I have  8166 computers. I am on Client Management Suite 7.1 SP2V3 rollup version

below is the request  I use :

SELECT
   [vri2_Computer].[Guid] AS [_ItemGuid],
   [vri2_Computer].[Name],
   [dca3_SW Patch Windows].[Description],
   [dca3_SW Patch Windows].[Service Pack]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      LEFT OUTER JOIN [Inv_SW_Patch_Windows] AS [dca3_SW Patch Windows]
         ON ([vri2_Computer].[Guid] = [dca3_SW Patch Windows].[_ResourceGuid])
WHERE
   (
      (
         ([dca3_SW Patch Windows].[Description] = N'windows xp service pack 3 ')
      )
      AND
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
   )
 

Just use [Inv_AeX_AC_Identification].[OS Revision] from basic inventory.

Software inventory might not be available from every client.

Hi Green,

Could you please try the following sql query?

select
vc.Name,
vc.Domain,
vC.[IP Address],
vc.[OS Name],
vc.[OS Revision]
from vComputer vc
where IsManaged = 1

Regards,

Thanks a lot for your help. The two solutions are solving my problem