Members for a collection for a particular machine

I needed to see what collections had a membership for a machine

select
FullCol.CollectionId,
COL.Name from dbo.v_R_System r
join dbo.v_FullCollectionMembership FullCol on R.ResourceID = FullCol.ResourceID
join dbo.v_Collection COL on COL.CollectionID = FullCol.CollectionID
Where
R.Name0 = 'Machine'

If you find this article useful please leave me a comment or click on an ad to show your support.

Zenithink C91 Upgrade

I just bought a Zenithink C91 Upgrade. I am now waiting for delivery.

In all honesty for $130 I am not expecting much at all.

Edit: it just arrived.. I'll post a review if enough people are interested in me reviewing one.. (leave me a comment if you want me to post a review of it)

I never knew that a application shortcut could map a drive

We came across something today where a user would  double click a shorcut and it would actually then map a network drive... weird?  Not really. Turns out this is actually by design. If you create a shortcut from a mapped network drive it will store the mapping information in the shortcut (try opening a .lnk in notepad).

more info:

http://support.microsoft.com/kb/150604

Running multiple commands in SCCM ‘Run Command Line’ Task Sequence step from Danovich.com.au

Danovich shows you how you can run multiple commands from the one 'run command line' step in a task sequence.

Running multiple commands in SCCM ‘Run Command Line’ Task Sequence step

Unable to install FP4 for Notes 8.5.2

We hit this issue again.. Fix Pack 4 fails to install on a system with Lotus Notes 8.5.2

fix:

- Make sure NSD service and Notes Single sign on services are stopped.
- Rename npnotes.dll before the install.
- Install the fix pack
- Rename the npnotes.dll back to npnotes.dll.

If you find this post useful, please leave me a comment or event better click on an AD!

ObjFSO.FilesCopy Permission Denied from SCCM

Problem:

I had an 'Permission Denied' VB script issue last week. The script was trying to copy over an existing file in the windows installer directory.

The problem only occurred when we ran the script through SCCM. Manually the script would work fine without issue. 

I figured out the problem with the assistance of Paul Chen (Sydney based app packager). The issue turned out to be that if the file is set to 'read only' in windows you can't copy straight over the top of  the file using VB script   in an SCCM program. 

Solution:

Delete the file before copying over the new file. 

or 

Remove the 'Read Only' checkbox from  the file before overwriting the file. 

An per normal if you found this post useful leave me a comment or click on an AD.

Office Deployment Toolkit for APP-V Issue; Unable to uninstall

Just a quick heads up,

if you install office deployment toolkit for APP-V and then use an MST configure the proxies for it you won't be able to un-install it.

the reason for this is when you uninstall the MST will try and re-activate the proxies.

I had to make a fix for this that replaced the MST in the installer cache with one that worked to resolve the uninstall issue.