select COL.Name from SMS_Collection as COL JOIN SMS_FullCollectionMembership as COLMEM on COL.CollectionID = COLMEM.CollectionID where COLMEM.Name = ##PRM:SMS_FullCollectionMembership.Name## order by COL.NameYou can use this query within SCCM solely as a Query or as a collection membership query. For SQL queries and reports take a look here
Showing posts with label WQL. Show all posts
Showing posts with label WQL. Show all posts
Monday, December 18, 2017
SCCM: Query collection membership for specific system
Beneath you find a WQL query for listing all collection memberships for a specific system in SCCM
I got some examples of the internet which didn't work for me. This query does and uses a prompt asking for a system resource name.
Labels:
Collections,
SCCM,
WQL
Tuesday, August 16, 2011
SCCM: Get Drivers From Driver Packages (WQL)
I was searching for a way to list Driver Packages which contain Drivers. Why? I want to use Driver Packages without importing the drivers in SCCM.
Why? You can read about that here: http://hayesjupe.wordpress.com/sccm-osd-driver-best-practices/
I found an interesting script of Christjan which can detect differences in drivers between Driver Packages. The script contained the necessary WQL statements that I needed.
Here's the link to his script:
http://pr3m.pri.ee/blog/?p=653
Example WQL query for displaying the PackageID and Name of Driver Packages that contain drivers:
Why? You can read about that here: http://hayesjupe.wordpress.com/sccm-osd-driver-best-practices/
I found an interesting script of Christjan which can detect differences in drivers between Driver Packages. The script contained the necessary WQL statements that I needed.
Here's the link to his script:
http://pr3m.pri.ee/blog/?p=653
Example WQL query for displaying the PackageID and Name of Driver Packages that contain drivers:
SELECT DPKG.Name,DPKG.PackageID FROM SMS_PackageToContent AS PTC
JOIN SMS_CIToContent AS CITC ON PTC.ContentUniqueID=CITC.ContentUniqueID
JOIN SMS_Driver AS DRV ON CITC.CI_ID=DRV.CI_ID
JOIN SMS_DriverPackage AS DPKG ON PTC.PackageID = DPKG.PackageID
Subscribe to:
Posts (Atom)
