Skip to content

Instantly share code, notes, and snippets.

@timdenholm

timdenholm/sccm-get-su-membership.sql

Created May 1, 2019 03:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save timdenholm/d850258a68c9506adff99ffda6407ebd to your computer and use it in GitHub Desktop.
Save timdenholm/d850258a68c9506adff99ffda6407ebd to your computer and use it in GitHub Desktop.
Download ZIP
Get SCCM Software Update Collection Membership
Raw
sccm-get-su-membership.sql
SELECT
fcm.Name AS 'host',
fcm.CollectionID AS 'sccm_su_collection_id',
cg.CollectionName AS 'sccm_su_colection_name'
FROM v_FullCollectionMembership fcm
JOIN Collections_G cg ON cg.SiteID = fcm.CollectionID
WHERE cg.CollectionName LIKE 'SU-%'
ORDER BY host
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment