SCCM Collection SQL Views

There are two types of Collection Views in SCCM. Collection Membership Views Collection Property Views Collection View Description v_ClientCollectionMembers Lists all devices, by resource ID, that are not in an obsolete or decommissioned state, what collections the device is a member of, and whether the resource is a Configuration Manager client. The view can be […]

Collection Membership Query

If you are ever in a situation where you do not have Roger Zanders Right-click tools and you want to track down what collections a device is a member of, use the query below.   SELECT FCM.Name, FCM.CollectionID, C.Name FROM v_FullCollectionMembership AS FCM LEFT JOIN v_Collection AS C ON FCM.CollectionID = C.CollectionID WHERE FCM.Name = @DeviceName […]

How to Change Password on Remote Computer

In most cases when running a standard RDP session CTRL + ALT + END will work but when connecting to a client via a Citrix Session and using an elevated Run As account.  I was unable to bring up the “Change a Password” option.   To fix this I launched the On Screen Keyboard (OSK.exe) […]