Find the Collection Membership of a Specific Machine

There many times during the course of troubleshooting issues within SCCM where you will need to find out what Collections a specific client machine is a member of. Unfortunately there is no native way of finding that out, but you can use SQL and reports to help you find this information.

You can run the following SQL query against your SMS database within SQL Management Studio

select v_FullCollectionMembership.CollectionID As 'Collection ID', v_Collection.Name As 'Collection Name', v_R_System.Name0 As 'Machine Name' from v_FullCollectionMembership
JOIN v_R_System on v_FullCollectionMembership.ResourceID = v_R_System.ResourceID
JOIN v_Collection on v_FullCollectionMembership.CollectionID = v_Collection.CollectionID
Where v_R_System.Name0='ClientMachineName'

Replace ClientMachineName with the device name

You can create a custom report within SCCM. You would need to modify the query slightly, you would replace the ClientMachineName section with a parameter, like so:

select v_FullCollectionMembership.CollectionID As 'Collection ID', v_Collection.Name As 'Collection Name', v_R_System.Name0 As 'Machine Name' from v_FullCollectionMembership
JOIN v_R_System on v_FullCollectionMembership.ResourceID = v_R_System.ResourceID
JOIN v_Collection on v_FullCollectionMembership.CollectionID = v_Collection.CollectionID
Where v_R_System.Name0=@Comp

I would encapsulate the above query into one dataset and use that to populate the table results within the report. Then create a second dataset holding the SQL query:

select Name0 from v_R_System

That can be used to populate the options within your @Comp parameter. Your SQL report builder will look something like this:

The above SQL should work both on Configuration Manager 2007 and Configuration Manager 2012.

Uninstall Project 2013 with Configuration Manager

As I'm sure all of you have found there are lots of helpful articles out there about how to do a silent install of Microsoft Office/Project/Visio/etc through SCCM, but there is very little information out there on how to do an un-install silently. After much head scratching I finally found the method of doing so...

1. Navigate to the directory where your install files are located
2. Edit the config.xml file located within prjstd.ww (note this changes depending on the version of Project)
3. Remove the values from the Display level line and change it to look like below

4. Within your SCCM deployment modify the Uninstall file to read:
setup.exe /uninstall prjstd /config prjstd.ww/config.xml (again note the visio version name will differ depending on the edition)

5. Click OK and test the uninstallation via SCCM software centre

Uninstall Visio 2013 with SCCM

As I'm sure all of you have found there are lots of helpful articles out there about how to do a silent install of Microsoft Office/Project/Visio/etc through SCCM, but there is very little information out there on how to do an un-install silently. After much head scratching I finally found the method of doing so...

1. Navigate to the directory where your install files are located
2. Edit the config.xml file located within vispro.ww (note this changes depending on the version of Visio)
3. Remove the values from the Display level line and change it to look like below

4. Within your SCCM deployment modify the Uninstall file to read:
setup.exe /uninstall vispro /config vispro.ww/config.xml (again note the visio version name will differ depending on the edition)

5. Click OK and test the uninstallation via SCCM software centre