in

SMSUG.ca

...your virtual communITy
All Tags » WQL (RSS)

Browse by Tags

  • Top 50 posts for 2007

    Total Title Web Views RSS Views 1117 One more reason to use v_GS_Computer_System vs v_R_System 748 369 989 SMS Log files 572 417 928 Number of Microsoft Certified Professionals Worldwide 611 317 872 What are my top 25 post? 256 616 859 Ottawa Windows Server User Group Newsletter 512 347 846 What is the...
    Posted to Garth Jones (Weblog) by Garth on 12-30-2007
  • Find all PCs with a version lessthen Adobe 8.1.0

    select SMS_R_System.Name, SMS_R_System.ResourceId from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe Reader%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version...
    Posted to Garth Jones (Weblog) by Garth on 12-28-2007
  • 365 posts

    Well, with this post I have now officially met my goal of one blog post per day for a year, sort of. J The year actually will end on Jan 2 2008. There have been few things that I have noticed while doing this. Each post is not the same as the next, and what I mean by that is there are some quality post...
    Posted to Garth Jones (Weblog) by Garth on 12-02-2007
  • Bump Rant

    Lately I have been seeing a lot more of the “bump” being used within the mailing list, forums, and newsgroups! What “bump” tells me is that the person doing it couldn’t be bothered to re-read their issue and re-write it to provide more details and so that it piques someone’s interest. Don’t get me wrong...
    Posted to Garth Jones (Weblog) by Garth on 08-15-2007
  • Find PCs without .Net 2.0 or .Net 3.0

    select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS...
    Posted to Garth Jones (Weblog) by Garth on 05-29-2007
  • Find PCs without .Net 3.0

    select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS...
    Posted to Garth Jones (Weblog) by Garth on 05-28-2007
  • Find PC with .Net 3.0

    select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS...
    Posted to Garth Jones (Weblog) by Garth on 05-27-2007
  • Find PCs with .Net 2.0

    select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS...
    Posted to Garth Jones (Weblog) by Garth on 05-26-2007
  • Find all PCs without .Net 2.0

    select distinct SMS_G_System_SYSTEM.Name from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select distinct SMS_G_System_COMPUTER_SYSTEM.ResourceID from SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS...
    Posted to Garth Jones (Weblog) by Garth on 05-25-2007
  • WQL Subset Query

    This blog post goes with the Subset Query post. This is the WQL example with a few tips. - For the positive query don’t return the PC name because of the possibility of duplicate PC Names instead return ResourceID - I also like to keep my queries clean of the junk that the SMS wizard-built queries have...
    Posted to Garth Jones (Weblog) by Garth on 05-10-2007
Page 5 of 6 (51 items) « First ... < Previous 2 3 4 5 6 Next >
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems