Garth Jones at myITforum.com : System Center, vNext

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)

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)

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)

78!

Garth Jones — Wed, 14 Mar 2012 02:06:28 GMT

I have been told that we are 78 people short of the 1200 people for tomorrows Webcast! Will you be the one to help set a new record for myITForm webcast? Sign up now! http://bit.ly/yMimvp And don’t forget that I have BIG news to spill at the end...(read more)

Total SQL Server Systems Query

Garth Jones — Mon, 12 Mar 2012 14:19:05 GMT

See forum post for full details: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/51ead03a-a43d-46df-b0ab-059d9322e432 SELECT DISTINCT R.Name0, R.User_Name0, ARP.DisplayName0 AS [Software Name], ARP.Version0 AS [Installed...(read more)

Link v_MeteredUser.FullName to a full name from AD v2

Garth Jones — Mon, 12 Mar 2012 14:10:28 GMT

To see full post see http://www.myitforum.com/forums/tm.aspx?high=&m=234899&mpage=1#234905 select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, max (ou.User_OU_Name0), MU.FullName as '...(read more)

Link v_MeteredUser.FullName to a full name from ad

Garth Jones — Mon, 12 Mar 2012 12:34:39 GMT

To see the full post http://www.myitforum.com/forums/How-to-link-v_MeteredUserFullName-to-a-full-name-from-ad-m234899.aspx select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, MU.FullName as '...(read more)

BIG NEWS!!!!

Garth Jones — Mon, 12 Mar 2012 02:40:34 GMT

I have big news but there is a catch….. I can’t say much until Wednesday at noon PST! J Which works out perfectly, as that is almost the exact time that I will be finishing my SCCM Guru webcast! So make sure that your register for the session to hear...(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)

Don’t you love emails like this one!

Garth Jones — Tue, 15 Nov 2011 03:21:11 GMT

I left ITProTeach (DevTeach) a bit early so that I could head home to pack before my long overdue vacation! After getting back, I found this nice surprise in my inbox! If you want to download the PPT, you can find it in Enhansoft’s blog http:/...(read more)

PC Var data

Garth Jones — Sun, 28 Aug 2011 20:38:24 GMT

select Name , Value , Masked from MEP_MachineVariables where MachineID = 63...(read more)

RAM by User name

Garth Jones — Sat, 06 Aug 2011 18:00:56 GMT

SELECT Distinct SYS.Netbios_Name0 , SYS.Operating_System_Name_and0 , MEM . TotalPhysicalMemory0 / 1024 As C083 FROM v_R_System SYS JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM . ResourceID WHERE User_Name0 = 'Garth'...(read more)

Modified version of “Hardware 03B - Computers for a specific primary console user”

Garth Jones — Wed, 08 Jun 2011 11:19:52 GMT

Select D istinct R . Netbios_Name0 AS 'Computer Name' , SCU . SystemConsoleUser0 as 'User' , S . SiteName as 'SMS Site Name' , SEU . SerialNumber0 AS 'Serial Number' , SEU . SMBIOSAssetTag0 AS 'Asset Tag' , CS ...(read more)

Canadian Microsoft Management Summit 2011

Garth Jones — Mon, 02 May 2011 12:58:15 GMT

Did you miss MMS this year? Well here is you change to see the highlight! (aka Put your head in the cloud) When: Friday, May 6 Where: Microsoft Canada Headquarters in Mississauga, Ontario Registration Details: http://www.microsoft.com/canada/events...(read more)