in

SMSUG.ca

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

Browse by Tags

  • Collection by Gateway

    select     SMS_R_System.Name 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 03-18-2011
  • Client Version and model

    select     SMS_R_System.Name,     SMS_R_System.ResourceId,     SMS_G_System_COMPUTER_SYSTEM.Manufacturer,     SMS_G_System_COMPUTER_SYSTEM.Model from      SMS_R_System     inner join SMS_G_System_COMPUTER_SYSTEM...
    Posted to Garth Jones (Weblog) by Garth on 03-09-2011
  • List PCs within a Security Group

    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    ...
    Posted to Garth Jones (Weblog) by Garth on 02-13-2011
  • PCs without SEP

    *** updated to use spaces instead of tabs *** 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.ResourceId not in (select SMS_G_System_ADD_REMOVE_PROGRAMS...
    Posted to Garth Jones (Weblog) by Garth on 01-11-2011
  • 2011 myITforum.com 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? http://www.myitforum.com/donations/donate.asp
    Posted to Garth Jones (Weblog) by Garth on 01-02-2011
  • PC with app x but exclude PC y

    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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId...
    Posted to Garth Jones (Weblog) by Garth on 10-08-2010
  • 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
  • SMSUG.ca Forums

    I have decided that the forums on www.SMSUG.ca 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
Page 2 of 6 (51 items) < Previous 1 2 3 4 5 Next > ... Last »
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems