in

SMSUG.ca

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

Browse by Tags

  • 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
  • Routers?

    This might NOT list all routers in your environment, and it will has lots of false positives too.   Of the 7 device marked as a router, only 3 are right, the remaining 4 are false positives.   In my test lab it found 3 out of 7, Routers /Switches.   Plus it lists ·        ...
    Posted to Garth Jones (Weblog) by Garth on 01-20-2010
  • 2010 myITforum 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). 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...
    Posted to Garth Jones (Weblog) by Garth on 01-07-2010
  • Collection Query - AD group membership & filter for Add\Remove Programs

    select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ...
    Posted to Garth Jones (Weblog) by Garth on 01-04-2010
  • Why v_GS_OPERATING_SYSTEM.Caption0 is better than v_R_System.Operating_System_Name_and0

    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 ,      ...
    Posted to Garth Jones (Weblog) by Garth on 12-04-2009
  • Attribute Reference Query

    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,    ...
    Posted to Garth Jones (Weblog) by Garth on 11-14-2009
  • Find all non-client PCs

      :-) at the suggestion of a friend here is a query to find all non-client PCs. select                SMS_R_SYSTEM.ResourceID,                SMS_R_SYSTEM.ResourceType...
    Posted to Garth Jones (Weblog) by Garth on 11-10-2009
  • No HW inventory in the last 30 days.

    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 11-10-2009
  • A Collection based on Domain name

    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.Domain = "<domain name>"
    Posted to Garth Jones (Weblog) by Garth on 08-28-2009
  • List of PCs with Excel (WQL)

    select     R.NetbiosName,     R.LastLogonUserName,     SP.ProductName,     SP.ProductVersion from      SMS_R_System R     inner join SMS_G_System_SoftwareProduct SP on SP.ResourceID = R.ResourceId    ...
    Posted to Garth Jones (Weblog) by Garth on 08-06-2009
Page 3 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