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

Browse by Tags

  • 2011 Donation

    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). Have you made a donation to your community yet?
    Posted to Garth Jones (Weblog) by Garth on 01-02-2011
  • Find PCs like TTDRxxxACxxWxxx

    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.Name like "TTDR___AC__W___"
    Posted to Garth Jones (Weblog) by Garth on 09-03-2010
  • Dynamic Subnet Collection

    select     *  from      SMS_R_System     inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId where     SMS_G_System_NETWORK_ADAPTER_CONFIGURATION...
    Posted to Garth Jones (Weblog) by Garth on 07-16-2010
  • Forums

    I have decided that the forums on are not being used and due to some SPAMMER populating the membership list, I have closed them down. This is a good thing as it means I will arrange for the site to be convert to a blog only site. With the new site will come a new look a feel. (wait for it...
    Posted to Garth Jones (Weblog) by Garth on 07-01-2010
  • List of Random PCs by Condition

    Here is a nice and simple way to get a list of Random PCs.   Create a query based on what you want to find, in my example Windows XP. Then add to the query a condition to find those with a “3” as the last character in the SMSID, Since the SMSID/GUID is HEX this will give you ~1/16 of all of those...
    Posted to Garth Jones (Weblog) by Garth on 06-16-2010
  • Vista without SP1 or SP2 (WQL)

    select     R.Name,     OS.Caption,     OS.CSDVersion from      SMS_R_System R     inner join SMS_G_System_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceId where     OS.CSDVersion is null    ...
    Posted to Garth Jones (Weblog) by Garth on 06-13-2010
Page 1 of 1 (6 items)
©2010 Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems