in

SMSUG.ca

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

Browse by Tags

  • Clients without Hardware information (WQL)

    select     *  from      SMS_R_System left outer join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where     SMS_G_System_OPERATING_SYSTEM.CSDVersion is null
    Posted to Garth Jones (Weblog) by Garth on 05-18-2009
  • Adding Display name to "All Systems" query

    select r.Name, r.SMSAssignedSites, r.IPAddresses, r.IPSubnets, r.OperatingSystemNameandVersion, r.ResourceDomainORWorkgroup, ru.name, r.LastLogonUserDomain, r.LastLogonUserName, r.SMSUniqueIdentifier, r.ResourceId, r.ResourceType, r.NetbiosName from sms_r_system r, sms_r_user ru Where r.LastLogonUserDomain...
    Posted to Garth Jones (Weblog) by Garth on 02-20-2009
  • 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 to MyITForum (MIF). Why do I do it? Well as a User Group leader for www.OWSUG.ca , I know how much it cost to host a small user group community. OWSUG is extremely...
    Posted to Garth Jones (Weblog) by Garth on 01-08-2009
  • Job posting

    Make sure that you stop by the OWSUG Job forums. There have been 10 new posting within the last month with more that half of them for Microsoft!
    Posted to Garth Jones (Weblog) by Garth on 12-03-2008
  • WQL - PCs with more that 2 GB free on C:

    select distinct SMS_R_System.Name, SMS_G_System_LOGICAL_DISK.* from SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_LOGICAL_DISK.FreeSpace > 2048 and SMS_G_System_LOGICAL_DISK.DeviceID = "C:" order by...
    Posted to Garth Jones (Weblog) by Garth on 09-24-2008
  • Blog Statistic – Part 2

    Just after posting the blog stats, I remember that I also want to check out that number of ping backs and comments. Since April 1 2007 there have been 181 ping backs and 22 comments select count(*) as '# of Comments' from cs_Posts cs_Posts, cs_Sections SEC where cs_Posts.SectionID = Sec.SectionID...
    Posted to Garth Jones (Weblog) by Garth on 01-20-2008
  • Blog Statistic

    Recently I was asked about stats for my blog, so instead of guessing what the stats are I created a SQL query to figure it out. So with out further ado here are the stats from April 1 2007 until this just before this post. Number of post 325 Total # of web views 49042 Average # of web views 150 Total...
    Posted to Garth Jones (Weblog) by Garth on 01-20-2008
  • All Windows XP without SP2

    select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System...
    Posted to Garth Jones (Weblog) by Garth on 01-08-2008
  • Happy New Year!!!

    Ellen and I would like wish you all the best in the New Year.
    Posted to Garth Jones (Weblog) by Garth on 01-01-2008
  • Hourly posting status.

    Why am I posting this information well, 2 reasons. 1) Someone asked me how I could ensure that I posted once per day and the answer is I pre-posted lots of posts. As you can tell I used hour between 6-7 am (7-8 EST) for pre-posted blogs. Just because… 2) Ever so often I would miss posting on time so...
    Posted to Garth Jones (Weblog) by Garth on 12-31-2007
Page 4 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