timbodv/SccmGetAllSystemsInACollection.wql

Created March 7, 2017 00:05

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/timbodv/b82f61cff9ee1a72f63ab270475f7e51.js"></script>
Save timbodv/b82f61cff9ee1a72f63ab270475f7e51 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

SccmGetAllSystemsInACollection.wql

Select * from SMS_R_SYSTEM where SMS_R_SYSTEM.ResourceId in (SELECT ResourceId FROM SMS_CM_RES_COLL_xxxxxxx)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment