Garth Jones at myITforum.com

PC not logon for 14 days.

Garth Jones — Tue, 07 Feb 2012 02:04:01 GMT

For full details see. http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/thread/cf7d80a0-1a7c-430c-b33a-ee47a0efa806 select CS.Name0, LCU. date From dbo.v_GS_COMPUTER_SYSTEM CS join ( Select ResourceID, max (LastConsoleUse0) as '...(read more)

Symantec av software to a query

Garth Jones — Fri, 03 Feb 2012 18:47:15 GMT

Adding symantec av software to a query, see here for full details.http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/7c6b65be-cdfc-414f-a78d-f198f5e6a323 SELECT Sys.Netbios_Name0 as ' Computer Name ', Sys.User_Domain0...(read more)

IT Virtualization Boot Camp

Garth Jones — Fri, 03 Feb 2012 14:26:46 GMT

Did you know that the OWSUG is putting on the IT Virtualization Boot Camp? This boot camp is designed to help you pass the 70-659 exam… What do you need to know. the boot camp cost ~$27, there are two date for this boot camp Feb 17 & 18. ...(read more)

SCCM Query for Memory & CPU

Garth Jones — Wed, 01 Feb 2012 02:18:43 GMT

See Forum post for fill details. select distinct SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.LastLogonUserName, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_G_System_PROCESSOR.NormSpeed from SMS_R_System inner...(read more)

Custom Windows 7 report - workstation manufacturer & model & client version

Garth Jones — Tue, 17 Jan 2012 01:21:40 GMT

SELECT DISTINCT COMSYS.Manufacturer0, COMSYS.Model0, Client.Version0, Count (*) FROM v_GS_COMPUTER_SYSTEM COMSYS JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID JOIN v_GS_PROCESSOR PROC 1 ON COMSYS.ResourceID = PROC 1.ResourceID...(read more)

Custom Windows 7 report - workstation manufacturer & model type

Garth Jones — Mon, 16 Jan 2012 23:03:44 GMT

SELECT DISTINCT COMSYS.Manufacturer0, COMSYS.Model0, Count (*) FROM v_GS_COMPUTER_SYSTEM COMSYS JOIN v_FullCollectionMembership fcm ON COMSYS.ResourceID = FCM.ResourceID JOIN v_GS_PROCESSOR PROC 1 ON COMSYS.ResourceID = PROC 1.ResourceID JOIN v_GS_X86_PC_MEMORY...(read more)

WQL Query for both x86 and x64 version of Software

Garth Jones — Mon, 16 Jan 2012 22:27:42 GMT

select distinct SMS_R_System.Name, SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName...(read more)

Adding IP address to Client Summary data

Garth Jones — Fri, 13 Jan 2012 13:49:13 GMT

select NetBiosName as " CAM NetBiosName ", LastPolicyRequest as " CAM LastPolicyRequest ", LastDDR as " CAM LastDDR ", sy.Operating_System_Name_and0 as " Operating System ", sy.Resource_Domain_OR_Workgr0 as "...(read more)

WINS/DNS for a Collection

Garth Jones — Fri, 13 Jan 2012 13:41:44 GMT

SELECT S.Name0 AS [System Name], OS.Caption0 AS [Operating System], OS.CSDVersion0 AS [Service Pack], OS.InstallDate0 AS [Original OS Install Date ], OS.LastBootUpTime0 AS [ Last Boot Time ], NAC.IPAddress0 AS [IP Address], NAC.IPSubnet0 AS [Subnet Mask...(read more)

MyITforum donation for 2012

Garth Jones — Mon, 02 Jan 2012 15:21:58 GMT

With the start of a new year, it is that time again to support the System Center Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). http://myitforum.com/myitforumwp/aboutus/donations/ MIF is truly a community...(read more)

64 Bit Office

Garth Jones — Thu, 29 Dec 2011 22:04:26 GMT

SELECT CS . Name0 , ARP64 . DisplayName0 , ARP64 . Version0 FROM dbo . v_GS_COMPUTER_SYSTEM CS ...(read more)

Report Two items from Add/Remove Program

Garth Jones — Wed, 21 Dec 2011 00:00:20 GMT

Select Name0 From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_FullCollectionMembership FCM on CS.ResourceID = FCM.ResourceID Where CS.ResourceId in ( select ARP.ResourceId from dbo.v_Add_Remove_Programs ARP Where ARP.Displayname0 = ' Windows Server 2003...(read more)

Challenge aka 70-659

Garth Jones — Mon, 28 Nov 2011 15:15:21 GMT

On Thursday night at the User Group event, I was challenged to write 70-659 exam before Dec 31 2011. There are high stakes at risk here, bragging rights and more importantly beer! Over the next few weeks you will see a few blogs post...(read more)

Query on Prohibited application for specific OU

Garth Jones — Mon, 28 Nov 2011 13:39:22 GMT

Select distinct ou.system_ou_name0, sys.Netbios_Name0, fcm.SiteCode,sys.User_Domain0, sys.User_Name0, -- DATEADD(mi,(usr.lastLogontimeStamp0 / 600000000) - 157258080,0) AS [Last Logon Time Stamp (UTC)], usr.company0, sys.Operating_System_Name_and0, Displayname0...(read more)

Show list of computers whithout more than 30 criticals patches not installed

Garth Jones — Sun, 27 Nov 2011 16:59:32 GMT

select v_R_System.Name0 as ' Computername ', Count (v_StateNames.Statename) as ' Required Updates ' from v_StateNames, v_Update_ComplianceStatusAll Inner Join v_R_System On (v_R_System.ResourceID = v_Update_ComplianceStatusAll.ResourceID...(read more)