Created
February 21, 2017 01:41
-
-
Save timbodv/c35d4c72ff16966a273c2ed85d4cfe2c to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client | |
| from SMS_R_System | |
| where SMS_R_System.ResourceId in (select ResourceID from SMS_CM_RES_COLL_CollectionId) and SMS_R_System.ResourceId not in (select ResourceID from SMS_CM_RES_COLL_CollectionId) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment