widsnet.com
4Sep/140

How to join in WQL/WMI

Everyone knows that there is no "join" in WQL. But this is how you do it 🙂

SELECT SMS_Collection.Name,SMS_Collection.CollectionID 
FROM SMS_ObjectContaineritem,SMS_collection 
WHERE SMS_ObjectContaineritem.ContainerNodeId='16777224' 
AND SMS_Collection.CollectionID=SMS_ObjectContaineritem.InstanceKey 
ORDER BY SMS_Collection.Name ASC
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.