Useful SCCM 2012 Device Collection Queries

Below are some useful SCCM Device Collection Queries. Some of these may require the device collection to be Dynamic.

Device Collection based on OU

SELECT * from SMS_R_System WHERE SMS_R_System.SystemOUName = "YOURDOM.LOCAL/Computers/YourCustomOU"

Device Collection Laptops/Notebooks

SELECT * FROM SMS_R_System INNER JOIN SMS_G_System_SYSTEM_ENCLOSURE ON SMS_G_System_SYSTEM_ENCLOSURE.ResourceID = SMS_R_System.ResourceID WHERE SMS_G_System_SYSTEM_ENCLOSURE.ChassisTypes in ( "8", "9", "10", "14" ) 

64bit Devices

SELECT * FROM SMS_R_System INNER JOIN SMS_G_System_COMPUTER_SYSTEM ON SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceID WHERE SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC" 

Windows 8 Devices

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId
WHERE
SMS_R_System.OperatingSystemNameandVersion
LIKE
"%Workstation 6.2%" or SMS_R_System.OperatingSystemNameandVersion LIKE "%Windows 8%" 

All Servers

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_SYSTEM ON SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId WHERE SMS_G_System_SYSTEM.SystemRole = "Server"

Domain Controllers

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 WHERE SMS_R_System.PrimaryGroupID = "516"

Computer Name Contains…

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_SYSTEM ON SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId WHERE SMS_G_System_SYSTEM.Name LINK "%COMP%" ORDER BY SMS_R_System.Name

Drupal 7 – Major Update!

The machine-readable web has come a step closer thanks to open sourcers in the Drupal community.

Drupal 7 has received sign-off – finally – adding the ability to embed semantic meta-data into sites using the open-source content management system.

That means Drupal 7 is adding native support for the W3C’s RDFa – a set of XHTML attributes that are designed to turn human readable data into data that’s readable by machines. That could be data such as a location’s map coordinates. RDFa is already being used by Google (see here).

Read More

Dropbox Cloud Storage

Dropbox is a cloud storage system where you can backup your files and folders on their servers and access them in real-time on Windows and Linux machines.

It integrates with the operating systems desktop manager and allows you to add/remove files just like a folder on your computer.

It’s free to try out and you’ll have 2GB of storage completely free; if you invite your friends using the referral scheme you get an extra 250MB per person (up to 3GB) so in theory you could have 5GB of online storage for nothing.

The good thing about Dropbox is that it supports Windows, Linux, Mac and even your iPhone and allows you to share files between these devices. It’s pretty good considering it costs you nothing.
Read More

Google Chrome Extensions

chromeGoogle chrome have just released a BETA version of the extension gallery. You can check it out here. There are many good extensions already released. I have listed below some of the more interesting ones.

Speed Tracer (By Google) is one of the more advanced extensions available, this will provide you with detailed graph analysis of the speed that web pages are loaded.
Speed Tracer is a tool to help you identify and fix performance problems in your web applications. It visualizes metrics that are taken from low level instrumentation points inside of the browser and analyzes them as your application runs. Speed Tracer is available as a Chrome extension and works on all platforms where extensions are currently supported (Windows and Linux).
Read More

Cloud Storage: Ubuntu One

ubuntuI came across a free (and paid) cloud service from Ubuntu; the creators of the popular OS Ubuntu Linux. You can have a free account and have 2GB’s worth of storage costing you nothing. If you happen to run the Ubuntu OS, One integrates with the desktop; providing ‘drag and drop’ functionality for backing up files.

More information below.

Read More

Game Server Manager Project

gsmGame Server Manager (GSM) started life as a very simple system for managing Linux based game servers. The early versions all worked via shell scripts and whilst this worked very well managing the servers requires an understanding of Linux. GSM was created to remove the requirement for any Linux knowledge in setting up and managing game servers.

You can view this project here: Game Server Manager website

Read More

Google unveils Chrome operating system

chromeChrome OS, due to launch next year, will be based on Linux, and is leaner than Windows and some people believe it could radically change the way we use computers. User data will be stored on Google’s servers and synchronise with Chrome OS devices.

No common desktop applications such as Microsoft Word or Adobe Reader will run on Chrome OS and the only application it will come with is a web browser.

This means the user is limited to web applications such as Gmail and Google Docs. Google said that because Chrome OS doesn’t allow the user to install desktop applications, the user is less at risk from malicious software.

Chrome OS allows Google to collect more information on the computing habits of its users, adding to the information it already has about people’s search, email and video usage.

The software will be designed for portable computers such as netbooks; but currently not for desktop PCs or standard laptops.