SOLVED Sccm Custom report

[SME]

Hi !

Im trying to create custom report for computers that dont have skype installed.
Im not very good at SQL, but friendly google helped.

This is what i have:

---
Select Distinct
sys.Netbios_Name0,
sys.User_Domain0,
sys.User_Name0

FROM
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
sys.ResourceID not in (select sys.ResourceID
from
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
where
DisplayName0 like '%Skype%')
---


It runs against all sccm collections but how could i run this against specific collection ?

Any help is appreciated
-
SME

 

[Milan0]

This should help.

https://prajwaldesai.com/how-to-add-collection-parameter-in-sccm-report/

 

[SME]

This should help.

https://prajwaldesai.com/how-to-add-collection-parameter-in-sccm-report/

Thanks !
That did the trick.
I got the lines i needed for specific program and specific collection ID (without parameters) and the final working version is like this:

***
Select Distinct
sys.Netbios_Name0,
sys.User_Domain0,
sys.User_Name0

FROM
v_R_System sys
join v_FullCollectionMembership fcm on fcm.resourceid=SYS.ResourceID
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
sys.ResourceID not in (select sys.ResourceID
from
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
where
DisplayName0 like '%Skype%')
and
fcm.Collectionid= 'Collection ID here'
***

 

[Prajwal Desai]

Marking this thread as Solved.