15.01.2013 UPDATE: New Query As you probably already know Oracle just released a Java update to patch two critical vulnerabilities, including one that had been exploited in ongoing and accelerating attacks. https://blogs.oracle.com/security/entry/october_2012_critical_patch_update So I thought that this was a good time as ever to make a little list of tips that could be helpful keeping Java …
Tag Archive: query
Aug 28
SCCM 2012–Unknown machines
Since you are reading this post you are probably “pissed off” and tired of deleting an object in All systems collection that is named Unknown…. You probably figured out that whenever a deployment fails, for some strange reason you have to find and delete these unknown objects in All Devices Collection. Well, I got tired …
Mar 22
ConfigMgr Client Hotfix Queries
After the release of ConfigMgr 2007 R3 the need to update Client Agents with hotfixes suddenly became all that more interesting. Some optional patches have been released earlier, but for Power Management to work on clients in R3 a hotfix is required. So, how do you check what kind of hotfixes are actually installed on …
Oct 15
ConfigMgr Queries, Operating System Name and Version
Ever wondered what those different Operating System Name and Version attributes mean? Wonder no more. Clients Microsoft Windows NT Workstation 5.1 – Windows XP Microsoft Windows NT Workstation 5.2 – Windows XP x64 Microsoft Windows NT Workstation 6.0 – Windows Vista Microsoft Windows NT Workstation 6.1 – Windows 7 Servers Microsoft Windows NT Server 4.0 …
Sep 08
ConfigMgr Query, Exclude Collection
I’ve recently tried to find a strategy to exclude a set of machines from my WMI queries. While I can compile an enorumous query to exclude the machines I want, this is not a very user friendly approach for those not familiar with ConfigMgr queries. I came across a post from the SMS Guys outlining …
Feb 10
ConfigMgr, Query Machines Based on TopConsoleUser in a Group
So, you have a group of users, but you can’t advertise your Task Sequence to users. If you enable Asset Intelligence to inventory the TopConsoleUser for a machine, you can extract all machines based on the TopConsoleUser for that group. select distinct SMS_R_System.Name from SMS_R_System inner join SMS_G_System_SYSTEM_CONSOLE_USAGE on SMS_G_System_SYSTEM_CONSOLE_USAGE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM_CONSOLE_USAGE.TopConsoleUser in …
Newest Comments