Browse by Tags

Input string was not in a correct format.
Wednesday, December 26, 2012 11:02 AM
  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
Tuesday, September 18, 2012 3:45 PM
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...   For more detail about each of the post see: Read More...
Find Programs Removed from a PC (updated)
Monday, May 21, 2012 10:15 AM
For full details see: SELECT DISTINCT CS.Name0, HARP.Publisher0 AS ' Publisher ', HARP.ProdID0 AS ' Product ', HARP.DisplayName0 AS ' Name ' FROM dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID... Read More...
MMS 2012
Monday, April 30, 2012 9:01 AM
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, so I didn’t bring a few things like shaving cream. I’m glad Walgreens is right there. I arrive at the airport... Read More...
List collection name and number of resources by OS
Wednesday, March 14, 2012 3:49 PM
For full details see:     SELECT C.Name, OS.Caption0 as ' Operating System ', OS.CSDVersion0 as ' Service Pack ', COUNT (*) AS ' Count ' FROM dbo.v_R_System R join dbo.v_GS_OPERATING_SYSTEM OS on OS.Resourceid = R.Resourceid... Read More...
Tuesday, March 13, 2012 10:06 PM
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!   And don’t forget that I have BIG news to spill at the end of the Webcast! Read More...
Total SQL Server Systems Query
Monday, March 12, 2012 10:19 AM
See forum post for full details:   SELECT DISTINCT R.Name0, R.User_Name0, ARP.DisplayName0 AS [Software Name], ARP.Version0 AS [Installed Version], IP.IP_Addresses0 AS IPAddress, -- ARP.TimeStamp AS [Last Time Stamp], ARP.InstallDate0 AS [Software... Read More...
Link v_MeteredUser.FullName to a full name from AD v2
Monday, March 12, 2012 10:10 AM
To see full post see select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, max (ou.User_OU_Name0), MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt ', MUS.UsageCount + MUS.TSUsageCount as ' Antal... Read More...
Link v_MeteredUser.FullName to a full name from ad
Monday, March 12, 2012 8:34 AM
To see the full post select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt ', MUS.UsageCount + MUS.TSUsageCount as ' Antal... Read More...
Sunday, March 11, 2012 10:40 PM
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 it Live!   oh, you want a hint?!?! Just a little hint??? Let’s just say that it involves... Read More...
MyITforum donation for 2012
Monday, January 02, 2012 10:21 AM
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).   MIF is truly a community that helps each other both professionally and personally. But it cost thousands of dollars each MONTH to... Read More...
Don’t you love emails like this one!
Monday, November 14, 2011 10:21 PM
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!-Bring-your-Swim-trunks!-e28093-Part-2.aspx http... Read More...
PC Var data
Sunday, August 28, 2011 4:38 PM
select Name , Value , Masked from MEP_MachineVariables where MachineID = 63 Read More...
RAM by User name
Saturday, August 06, 2011 2:00 PM
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”
Wednesday, June 08, 2011 7:19 AM
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 . Manufacturer0 AS 'Manufacturer' , CS . Model0 AS 'Model' , SCU . NumberOfConsoleLogons0 AS 'Console... Read More...
More Posts Next page »

This Blog