Browse by Tags

All Tags » WQL » SCCM (RSS)
2010 myITforum Donation
Thursday, January 07, 2010 1:39 PM
With the start of a new year, it is that time again to support the System Management Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). Why do I do it? Well as a past User Group leader for www.OWSUG.ca , I know how much it cost to host a small user group community. OWSUG is small in comparison to MIF! Our network traffic... Read More...
by Garth Jones
Filed under: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
Collection Query - AD group membership & filter for Add\Remove Programs
Monday, January 04, 2010 8:08 AM
select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ... Read More...
by Garth Jones
Filed under: , , , , ,
Why v_GS_OPERATING_SYSTEM.Caption0 is better than v_R_System.Operating_System_Name_and0
Friday, December 04, 2009 10:04 AM
Take the following query, if you only used v_R_System . Operating_System_Name_and0 then you would have no idea as to which PCs are installed with “Microsoft Windows 7 Ultimate" or “Microsoft Windows 7 Professional”.     Select       R . Name0 ,       R . Operating_System_Name_and0 ,      ... Read More...
by Garth Jones
Filed under: , , , , ,
Attribute Reference Query
Saturday, November 14, 2009 9:15 AM
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,     SMS_G_System_SYSTEM_CONSOLE_USER.LastConsoleUse,    ... Read More...
by Garth Jones
Filed under: , , , ,
More Posts « Previous page
Go

This Blog

Syndication