Garth Jones at myITforum.com : vNext

How to find all workstations with SNMP.

Garth Jones — Sat, 29 Dec 2012 16:39:44 GMT

For full detail please see, http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/2eb10f29-0927-4b43-a4a4-0c712793673f Select CS.Name0 as 'PC Name' , OS.Caption0 as 'OS' , OS.CSDVersion0 as 'SP' From dbo.v_GS_COMPUTER_SYSTEM...(read more)

Input string was not in a correct format.

Garth Jones — Wed, 26 Dec 2012 16:02:00 GMT

If you are trying to install CM12 console on a workstation, you will receive the following error: Input string was not in a correct format . The solution is to browse the DVD and smssetup\bin\i386 and execute the AdminConsole.msi....(read more)

Four reports to answer questions within the reporting forums

Garth Jones — Tue, 18 Sep 2012 19:45:45 GMT

So I have been running with my head cut of these days but I always like to make sure that the Reporting forum questions are answer... http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/threads For more detail about each of the...(read more)

Count of Manufacturers

Garth Jones — Sun, 08 Jul 2012 20:50:33 GMT

For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/4e4019b0-a28e-4637-ae8c-4ff523d11c1a select top 3 Manufacturer0, Count (*) from dbo.v_GS_COMPUTER_SYSTEM GROUP BY Manufacturer0 Order by 2 desc...(read more)

How to find an application installed in the last 7 days

Garth Jones — Tue, 03 Jul 2012 01:27:55 GMT

For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f96191-6e3e-4150-8f3a-18b1c4db8d7d SELECT R.Netbios_name0, R.AD_Site_Name0, ARP.DisplayName0, ARP.InstallDate0, DATEDIFF( Day , CONVERT ( Datetime ,ARP.InstallDate0...(read more)

Finding Adobe X for both x68 and x64

Garth Jones — Mon, 02 Jul 2012 13:45:03 GMT

For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/66c80e66-9760-49b3-b429-08bf2ca8f572 http://social.technet.microsoft.com/Forums/en-US/configmanagerapps/thread/b68ce42c-98f5-4500-bced-0e8e901cb211/ select distinct...(read more)

Query on user history

Garth Jones — Sun, 01 Jul 2012 13:37:27 GMT

For full details please see http://www.myitforum.com/Forums/tm.aspx?m=230539&high = SELECT DISTINCT R.Netbios_Name0, tu.SystemConsoleUser0, tu.logontime FROM dbo.v_R_System R join ( SELECT husr.ResourceID, Husr.SystemConsoleUser0, max (Husr.LastConsoleUse0...(read more)

List of PCs with Project, Visio or Visual

Garth Jones — Fri, 01 Jun 2012 11:53:44 GMT

For full details, please see this forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/50b2b524-3c11-41c5-a2d5-b8ae979ee3c2/ Select sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0,...(read more)

Find Programs Removed from a PC (updated)

Garth Jones — Mon, 21 May 2012 14:15:59 GMT

For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/db96da44-a9e0-4996-bca2-286b6e2c473a SELECT DISTINCT CS.Name0, HARP.Publisher0 AS ' Publisher ', HARP.ProdID0 AS ' Product ', HARP.DisplayName0...(read more)

MMS 2012

Garth Jones — Mon, 30 Apr 2012 13:01:29 GMT

Well MMS 2012 is over and it has been crazy for me. Here is the summary of what happened: My passport expired so had to get a new one, I picked it up on Thursday just before I left for Vegas I know my luggage would be close to being overweight...(read more)

Query to report OU information for Machines

Garth Jones — Thu, 05 Apr 2012 17:49:14 GMT

For full details please see: http://www.myitforum.com/forums/query-to-report-OU-information-for-Machines-m235317.aspx select R.Name0, max (OU.System_OU_Name0) From dbo.v_R_System R join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = R.ResourceID...(read more)

Last Reboot Report

Garth Jones — Sun, 18 Mar 2012 16:38:27 GMT

For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/e0147d8a-8946-42bb-b6ed-a3c92bae5b23 select distinct R.ResourceID, R.Netbios_Name0 AS ' Computer Name ', OS.LastBootUpTime0 AS ' Last Boot...(read more)

Lists people and how much they've been using specified software with OU fix

Garth Jones — Fri, 16 Mar 2012 22:53:20 GMT

For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=234978&mpage=1#234980 select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', ou.ou as OU, round( sum (MUS...(read more)

Lists people and how much they've been using specified software

Garth Jones — Fri, 16 Mar 2012 10:40:08 GMT

For full details see: http://www.myitforum.com/forums/Need-some-SQL-help-think-its-simple-m234978.aspx select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', replace( max (ou.User_OU_Name0...(read more)

List collection name and number of resources by OS

Garth Jones — Wed, 14 Mar 2012 19:49:36 GMT

For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/370ceff1-0f54-46f3-8e8e-5459069125e4 SELECT C.Name, OS.Caption0 as ' Operating System ', OS.CSDVersion0 as ' Service Pack '...(read more)