Add Remove Program vs Software Product

Question

Hello ,

I ran two queries to verify a product is installed:

SELECT DISTINCT
v_Add_Remove_Programs.ResourceID AS [v_Add_Remove_Programs ResourceID]
,v_Add_Remove_Programs.DisplayName0
,v_CollectionMemberClientBaselineStatus.Name AS [v_CollectionMemberClientBaselineStatus Name]
,v_CollectionMemberClientBaselineStatus.CollectionID AS [v_CollectionMemberClientBaselineStatus CollectionID]
,v_Collection.CollectionID AS [v_Collection CollectionID]
,v_Collection.Name AS [v_Collection Name]
,v_R_System.ResourceID AS [v_R_System ResourceID]
,v_R_System.Name0
FROM
v_Add_Remove_Programs
INNER JOIN v_R_System
ON v_Add_Remove_Programs.ResourceID = v_R_System.ResourceID
INNER JOIN v_CollectionMemberClientBaselineStatus
ON v_CollectionMemberClientBaselineStatus.Name = v_R_System.Name0
INNER JOIN v_Collection
ON v_Collection.CollectionID = v_CollectionMemberClientBaselineStatus.CollectionID
WHERE
v_Collection.CollectionID = 'UCP00242'

AND v_R_System.Name0 like 'BSPEDWDB01'

This is reporting 86 records...

But when runnig the following query
===================================================================Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion
From v_GS_SoftwareProduct SP
Join v_R_System SYS on SP.ResourceID = SYS.ResourceID
Join v_FullCollectionMembership COL on COL.ResourceID = SYS.ResourceID
Where SYS.Netbios_Name0 like 'BSPEDWDB01'

AND COL.CollectionID = 'UCP00242'

I am getting 132 records

Which query should I select to get the verification accurate?
Apparently the product ("Duo Authentication" is sometimes appearing in both queries, sometimes only in one ...

Thanks,
Dom

Answer 1

First off the query are NOT the same. One has Baseline added too it and the other doesn't.
Secondly, ARP will show all app. AI will NOT show all apps.

So step one is to make the queries match so that you can compare apples to apples.

Answer 2

Hi,

Haven't heard from you for some time, is Garth's answer helpful to you? If it is helpful, please accept answer. It will make someone who has the similar issue easily find the answer.

If you have any other issues, please don't hesitate to let us know.

Thanks and have a nice day.

Best regards,
Amanda

Answer 3

work in progress!!