Browse by Tags

Routers?
Wednesday, January 20, 2010 9:45 AM

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 ·         1 WS, that is not acting like routers... Read More...

by Garth Jones

Filed under: ConfigMGr, Code, WQL, SCCM

2010 myITforum Donation
Thursday, January 07, 2010 1:39 PM

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. OWSUG is small in comparison to MIF! Our network traffic... Read More...

by Garth Jones

Filed under: Virtual Server , User Groups, 70-401, ConfigMGr, 70-400, MOM, SMS, OpsMgr, Fun Links, 70-299, 70-640, 70-643, 70-642, MS Support, Training, Windows 2008, self-study, System Center, 70-620, 70-536, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, Code, VS 2008, 70-624, Q&A, 70-298, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, WQL, MDT, 70-635, 70-671, 70-672, 70-673, 70-631, 70-089, MMS, Enhansoft, myITforum, Rant, 70-630, 70-236, Windows 7, MSN, SCCM, SMSI, SMS Installer

Collection Query - AD group membership & filter for Add\Remove Programs
Monday, January 04, 2010 8:08 AM

select     R.*  from      SMS_R_System R where     R.SystemGroupName != "GARTEK\\Domain Admins"     and R.ResourceId not in (    select                        ... Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, System Center, Code, WQL, SCCM

Why v_GS_OPERATING_SYSTEM.Caption0 is better than v_R_System.Operating_System_Name_and0
Friday, December 04, 2009 10:04 AM

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 ,       R . Operating_System_Name_and0 ,      ... Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, System Center, SQL, WQL, SCCM

Attribute Reference Query
Saturday, November 14, 2009 9:15 AM

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,     SMS_G_System_SYSTEM_CONSOLE_USER.LastConsoleUse,    ... Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, Code, WQL, SCCM

Find all non-client PCs
Tuesday, November 10, 2009 9:37 AM

  :-) 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,               ... Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, Code, WQL

No HW inventory in the last 30 days.
Tuesday, November 10, 2009 8:51 AM

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_WORKSTATION_STATUS... Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, Code, WQL

A Collection based on Domain name
Friday, August 28, 2009 10:15 AM

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>" Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, WQL

Clients without Hardware information (WQL)
Monday, May 18, 2009 4:48 PM

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 Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, Code, WQL

Adding Display name to "All Systems" query
Friday, February 20, 2009 10:52 AM

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 = ru.WindowsNTDomain and r.LastLogonUserName = ru.UserName Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, WQL

myITForum Donation
Thursday, January 08, 2009 9:23 AM

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 small compared to MIF! Our network traffic is nothing... Read More...

by Garth Jones

Filed under: Joke, Virtual Server , User Groups, 70-401, ConfigMGr, 70-400, MOM, Study group, SMS, OpsMgr, Canada, SoftGrid, 70-299, 70-640, 70-643, 70-642, MS Support, Training, Windows 2008, self-study, Podcast, System Center, Ottawa, 70-620, 70-536, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, MVP, Code, VS 2008, 70-624, Q&A, 70-298, A+, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, WQL, MDT, 70-635, 70-671, 70-672, 70-673, Flowcharts

Job posting
Wednesday, December 03, 2008 3:47 PM

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! Read More...

by Garth Jones

Filed under: Virtual Server , User Groups, 70-401, 70-400, MOM, Study group, SMS, OpsMgr, Canada, Fun Links, SoftGrid, 70-299, 70-640, 70-643, 70-642, MS Support, Training, Windows 2008, self-study, Podcast, System Center, Ottawa, 70-620, 70-536, 70-293, 70-622, 70-294, SCMDM, SCSM, SCE, SCVMM, Vista, exam, 70-652, 70-403, 70-402, MVP, Code, VS 2008, 70-624, Q&A, 70-298, A+, SQL, Windows 2003, 70-649, 70-646, 70-647, 70-431, MCSE, Hyper-v, WQL, MDT, 70-635

WQL - PCs with more that 2 GB free on C:
Wednesday, September 24, 2008 4:56 PM

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 SMS_R_System.Name Read More...

by Garth Jones

Filed under: ConfigMGr, SMS, Code, WQL