Ross

Author Archives: Ross

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.  Collection Membership QuerySELECT FCM.Name, FCM.CollectionID, C.NameFROM v_FullCollectionMembership AS FCMLEFT JOIN v_Collection AS C on FCM.CollectionID = C.CollectionIDWHERE FCM.Name = @DeviceNameORDER BY FCM.CollectionID

Continue reading

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) then […]

Continue reading

Direct Collection Memberships

There are a number of best practices to follow in order to ensure that collection evaluation times run as quickly as possible.   There are a number of guidelines to follow but not all are obvious. In this blog post I want to go into why you should avoid using Direct Members in collections and how […]

Continue reading

State Names

State Names

State Messages were introduced in SCCM 2012.  State Messages are only used by some components such as Software Updates, Desired Configuration Management and reflect the client condition at certain points in time.  These are useful for administrators to track the flow of data through various components. 

Continue reading

WSUS Error Code Bible

WSUS Error Codes

The following database provides information about common errors you might run into with Windows Updates.  Please let me know if you know of any missed here and I will add them to the list.

Continue reading

SCCM Error Code Bible

Your one stop shop for all SCCM Error codes and descriptions.  Type in your error code into the search field to find the matching description.  This page takes several seconds to load.

Continue reading

Create an SCCM Windows 10 Collection Query

If you would like to create a collection based on a specific Operating System in SCCM. 1.  From Assets and Compliance, Right-Click on Device Collections then click Create Device Collection. 2.  On the General page, provide a name for the collection, eg. Windows 10 Devices, then Browse to the Limiting Collection Desktops, then click Next3.  On the Membership Rules page, click on Add Rule […]

Continue reading