Category Archives: Stuff

Anything else

Sharepoint 2010

Currently installing shareopint 2010 at work. With the hope that it will become the new intranet and more. I think the ultimate plan is for some sort of document management and de-duplication of the same files in everyone’s home drive! That alone should save a few tb!

I’ll let you know how it goes and any show stoppers we find. So far so good though

Domestic Cleaning in Southampton

Completely unrelated to this blog really, but I thought I’d lend a hand. A friend ha started a cleaning company in Southampton called “Maid2Clean Southampton” that provides general domestic cleaning and ironing duties to people in the Southampton area and Winchester and Romsey areas. These duties include things such as dusting, mopping and hoovering.

Their website is located at www.maid2clean.co.uk/southampton if you are in need of any cleaning 🙂

SCCM Pre-R3 client patch

Here’s my collection to deploy the “power management” pack to clients. This is the MSP file that you get with R3 that clients need to have in order to manage power settings correctly. This collection selection should work, at least it seems to do so anyway!

select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SMS_ADVANCED_CLIENT_STATE on SMS_G_System_SMS_ADVANCED_CLIENT_STATE.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ClientType = 1 and SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Name = “SmsPowerManagement” and SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Version < “4.0.6487.2157”

SCCM SP2 Client Collection

Looking for a way of deploying and updating the SCCM SP2 client to old clients? Well, here is the collection I’ve been using. This will list all the clients that are not running Service Pack 2.

select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SMS_ADVANCED_CLIENT_STATE on SMS_G_System_SMS_ADVANCED_CLIENT_STATE.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ClientType = 1 and SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Name = “CcmFramework” and SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Version < “4.0.6487.2000”