PENDING Dont give report spesific program

[Ruslan]

Hello,

When I added this query SCCM I got report all installed progrom count.. But I need spesific program when I chose program dont give me spesific program install count report.

Which line incrooect wrote, who is help me this issue

declare @RuleID nvarchar;
declare @CollID nvarchar;
SELECT
DisplayName0 AS 'SoftwareName',
Version0 AS 'Version',
Publisher0 AS 'Publisher',
Count (sum.FileID) as 'installationcount'


FROM
v_Add_Remove_Programs arp
JOIN v_GS_SoftwareUsageData sum on arp.ResourceID = sum.ResourceID
join v_MonthlyUsageSummary mm on arp.ResourceID = mm.ResourceID
join v_MeteredFiles md on sum.FileID = md.MeteredFileID
inner join v_FullCollectionMembership fcm on arp.ResourceID = fcm.ResourceID

WHERE
md.SecurityKey IN (@RuleID)
and fcm.CollectionID = @CollID
GROUP BY
DisplayName0, Version0, Publisher0
ORDER BY
InstallationCount DESC;

 

[Garth]

Hello,

When I added this query SCCM I got report all installed progrom count.. But I need spesific program when I chose program dont give me spesific program install count report.

Which line incrooect wrote, who is help me this issue

declare @RuleID nvarchar;
declare @CollID nvarchar;
SELECT
DisplayName0 AS 'SoftwareName',
Version0 AS 'Version',
Publisher0 AS 'Publisher',
Count (sum.FileID) as 'installationcount'


FROM
v_Add_Remove_Programs arp
JOIN v_GS_SoftwareUsageData sum on arp.ResourceID = sum.ResourceID
join v_MonthlyUsageSummary mm on arp.ResourceID = mm.ResourceID
join v_MeteredFiles md on sum.FileID = md.MeteredFileID
inner join v_FullCollectionMembership fcm on arp.ResourceID = fcm.ResourceID

WHERE
md.SecurityKey IN (@RuleID)
and fcm.CollectionID = @CollID
GROUP BY
DisplayName0, Version0, Publisher0
ORDER BY
InstallationCount DESC;

There is no link between between ARP and SWM data. This will never work. https://forums.prajwaldesai.com/threads/sql-query-custom-report-for-collections.6190/