SCCM by Davis

---

• Peter Daalmans wrote a new post, Adding PowerShell support to WinPE from ConfigMgr 2012 SP1 console
• Rafal Pe posted an update in the group Operating System Deployment:
• Rafal Pe joined the group Operating System Deployment
• Garth Jones wrote a new post, PC with MAC Address
• PC with MAC Address
• Garth Jones wrote a new post, Softwares installed in last 90 days on a collection of PC
• Garth Jones wrote a new post, Count of Video Controller details.
• Softwares installed in last 90 days on a collection of PC
• SCCM by Davis

Peter Daalmans wrote a new post, Adding PowerShell support to WinPE from ConfigMgr 2012 SP1 console Posted: 18 Nov 2012 10:50 AM PST This blog is initiated by a question asked to Wally Mead during the SCUG Netherlands event last week. The question was if there is any PowerShell support for Boot Images in Configuration Manager 2012 Service Pack […] Comments: 0

Rafal Pe posted an update in the group Operating System Deployment: Posted: 18 Nov 2012 05:20 AM PST SCCM – OSD Dynamic computer naming (dynamically generate computer name) http://www.itx-solutions.nl/sccm/sccm-osd-dynamic-computer-naming-dynamically-generate-computer-name/ I have noticed that a lot of people is missing that funcionality in SCCM (2007 and suprise 2012). I honestly dont know why Microsoft has not built that in. I have been using custom builds of services or scripts to do that but in my case of big enviroment those solutions just did not work as expected. Therefore I have written my own custom Web Services (available in codeplex and here).Benefits are: Comments: 0

Rafal Pe joined the group Operating System Deployment Posted: 18 Nov 2012 05:06 AM PST Comments: 0

Garth Jones wrote a new post, PC with MAC Address Posted: 17 Nov 2012 03:42 PM PST For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/6c00b44f-1b92-4c1b-924e-fd79c191d5e9 Select R.Netbios_Name0, MAC.MAC_Addresses0 from dbo.v_R_System R […] Comments: 0

PC with MAC Address Posted: 17 Nov 2012 03:42 PM PST For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/6c00b44f-1b92-4c1b-924e-fd79c191d5e9 Select R.Netbios_Name0, MAC.MAC_Addresses0 from dbo.v_R_System R join dbo.v_RA_System_MACAddresses MAC ON R.ResourceID = MAC.ResourceID Where MAC.MAC_Addresses0 in ( SELECT MAC.MAC_Addresses0 FROM dbo.v_RA_System_MACAddresses MAC GROUP BY MAC.MAC_Addresses0 having (Count(MAC.MAC_Addresses0)>1) )

Garth Jones wrote a new post, Softwares installed in last 90 days on a collection of PC Posted: 17 Nov 2012 01:38 PM PST For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/80c794d7-a55f-4d13-985b-9b84efd6f9e7   SELECT R.Name0 as 'PC', CS.Manufacturer0 as 'Man', […] Comments: 0

Garth Jones wrote a new post, Count of Video Controller details. Posted: 17 Nov 2012 12:58 PM PST For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f8a5c1-3b82-4ca4-b664-167b6c8226c5   select r.netbios_name0 as nm, Count(r.netbios_name0) from […] Comments: 0

Softwares installed in last 90 days on a collection of PC Posted: 17 Nov 2012 01:38 PM PST For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/80c794d7-a55f-4d13-985b-9b84efd6f9e7 SELECT R.Name0 as 'PC', CS.Manufacturer0 as 'Man', CS.Model0 as 'Model', ARP.DisplayName0 as 'DisplayName', ARP.Version0 as 'Version', installdate0 as 'IDate', datediff(dd,convert(datetime,cast(installdate0 as datetime),101),getdate()) as 'DateD' into #temp FROM dbo.v_R_System R JOIN dbo.v_ADD_REMOVE_PROGRAMS ARP ON R.ResourceID = ARP.ResourceID and isdate(arp.installdate0) = 1 JOIN dbo.v_GS_COMPUTER_SYSTEM CS ON R.ResourceID = CS.ResourceID JOIN dbo.v_FullCollectionMembership FCM ON R.ResourceID = FCM.ResourceID and CollectionID = 'SMS00001' WHERE ARP.DisplayName0 NOT LIKE '%Update%' Select t.PC, t.Man, t.Model, t.DisplayName, t.Version, t.IDate from #temp t where T.Dated < 90 Drop table #temp

SCCM by Davis Posted: 17 Nov 2012 01:46 PM PST SCCM by Davis Count of Video Controller details. SCCM 2012 : "A communication error has been detected between the specified site system and the site database computer" The limit of Software Inventory rules SCCM 2012: Clients cannot install deployed update packs. Error 0x87D00692 Vitaly Gritsenko became a registered member Sumo Logic Tracks Network Performance Through Event Logs Pete Pfunck commented on the post, ConfigMgr 2012 Powershell Right Click Tools Update John Hamilton joined the group System Center Configuration Manager 2007 SCCM by Davis Count of Video Controller details. Posted: 17 Nov 2012 12:58 PM PST For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f8a5c1-3b82-4ca4-b664-167b6c8226c5 select r.netbios_name0 as nm, Count(r.netbios_name0) from v_GS_VIDEO_CONTROLLER vc join v_R_System R on VC.ResourceID = R.ResourceID where vc.CurrentHorizontalResolution0 not like '' Group by r.netbios_name0 order by R.netbios_name0 SCCM 2012 : "A communication error has been detected between the specified site system and the site database computer" Posted: 28 Sep 2012 12:13 PM PDT Hi, Currently, I am working on an important System Center project. During SCCM 2012 installation, I have encountered this error in the pre requisites checking step : "Site System to SQL Server Communication;    Warning;    A communication error has been detected between the specified site system and the site database computer. This error can occur when the site database server is offline or if a valid SPN has not been registered in Active Directory Domain Services for the SQL Server instance hosting the site database. Setup cannot continue." In my case, the database server is hosted on a remote server. I have done all the necessary configurations. But this error occurred. I have applied consequently the suggestion of registering the SPN of the SQL instance. That did not solve my issue. Don't forget of course to fix the SQL communication ports, because the dynamic ports when you have more than one instance cause many problems. So I consulted the log file to analyze the issue and surprise ! I got these wonderful lines : <09-16-2012 15:27:25> ERROR: Connected to SQL Server but failed to execute query IF NOT EXISTS (select * from master.sys.server_principals where name='DOMAIN\SCCMCOMPUTERACCOUNT$') BEGIN CREATE LOGIN [DOMAIN\SCCMCOMPUTERACCOUNT$] FROM WINDOWS; SELECT 1; END ELSE SELECT 0 <09-16-2012 15:27:25> save to ini file SQLCONNECT:DatabaseServerAccount\cmsql. <09-16-2012 15:27:31> ERROR: Failed to connect to SQL Server SCCMCOMPUTERName. So I have verified the logins section in my SQL Server and really the account was not created. What's the matter? To understand the issue, try to execute the T-SQL query and bingo! this account cannot be retrieved and verified. In my case, the NetBios domain name is different from the domain name without DNS suffix. The wizard detects the domain name and simply extracts the NetBios name by removing the DNS suffix like .com for example. Let us suppose that your domain name is CONTOSO.COM. the SCCM wizard just extracts CONTOSO and considers it as the NetBios name, even it is different. After that, an account name is generated for your SCCM computer account using the extracted NetBios name. if the real NetBios name is different so the generated account is false and does not exist. What to do? Simply execute the SQL request by putting the real account name. you will notice that the request is executed successfully. Don't attribute privileges, the wizard does it for you. Now, when you relaunch the wizard the error sill exists but don't worry, you can continue without any problem. You will also have the following AD container errors even you have configured the necessary settings : <09-16-2012 15:27:14> ERROR: Site server does not have create child permission on AD 'System Management' <09-16-2012 15:27:14> WARN: Site server does not have delete child permission on AD 'System Management' <09-16-2012 15:27:16> SCCMComputerName; Verify site server permissions to publish to Active Directory.; Warning; The site server might be unable to publish to Active Directory. The computer account for the site server must have Full Control permissions to the System Management container in its Active Directory domain. You can ignore this warning if you have manually verified these permissions. For more information about your options to configure required permissions, see http://go.microsoft.com/fwlink/p/?LinkId=233190. Don't worry, the error is due to the same reason and you can install the SCCM without any problem. After installation please check your SQL server to verify the database creation and that the account you have created previously is attributed the right rights. Please check also the System management container in the AD and verify the information publication. The limit of Software Inventory rules Posted: 28 Sep 2012 07:53 AM PDT On the Inventory Collection tab of the Software Inventory Client Agent Properties recently I have stumbled upon an issue where the New icon has been greyed out and disabled, not allowing me add any new rules defining the software inventory scope. After some googling around, this behaviour turned out to be documented and by design. In Configuration Manager 2007, there is a maximum limit of 64 rules. I am not sure if it is applicable to Configuration Manager 2012 as well, but it is worth to keep this limit in mind. Sometimes you learn things which are well documented the hard way. For more information, refer to the Configuring Software Inventory Rules article on Microsoft Technet – http://technet.microsoft.com/en-us/library/cc181215.aspx SCCM 2012: Clients cannot install deployed update packs. Error 0x87D00692 Posted: 28 Sep 2012 07:52 AM PDT Issue: SCCM Clients cannot install deployed updates. Resolution: Check your deployment status either in console, or using SCCM report  (Software Updates – E Troubleshooting/Troubleshooting 2 – Deployment errors) The cause of failure is "GPO conflict". Domain GPO overwrites SCCM Client settings and points the machine to corporate WSUS server. That is why Client cannot use SUP for update evaluation. It is necessary to either set GPO settings for Intranet Windows Update Server to "Not Configured" and let SCCM client configure local policy properly or put SUP FQDN and port instead of WSUS into GPO. If you are in migration and not ready to repoint all machines to SCCM  you can configure GPO to repoint the settings to SCCM for SCCM clients only using WMI filter (see more here ) Vitaly Gritsenko became a registered member Posted: 17 Nov 2012 05:38 AM PST Comments: 0 Sumo Logic Tracks Network Performance Through Event Logs Posted: 16 Nov 2012 04:30 PM PST The data analytics service studies reams of data about a client's network and applications to learn about the network's performance and to find ways to improve it. Pete Pfunck commented on the post, ConfigMgr 2012 Powershell Right Click Tools Update Posted: 16 Nov 2012 02:34 PM PST I had similar issue, try the fix below: Run: regedit * Goto HKEY_LOCAL_MACHINESOFTWAREMicrosoftPowerShell * Right-Click > Permissions * Select, and add your account, grant it "Full Control" […] Comments: 0 John Hamilton joined the group System Center Configuration Manager 2007 Posted: 16 Nov 2012 01:40 PM PST Comments: 0 SCCM by Davis Posted: 16 Nov 2012 01:34 PM PST SCCM by Davis Rod Trent wrote a new post, Infographic: The power hungry Internet Brooke Owens joined the group System Center Jobs Brooke Owens joined the group Ron's Web Essentials Brooke Owens joined the group Operating System Deployment Brooke Owens joined the group System Center Configuration Manager 2012 Brooke Owens joined the group SCCM Right-click tools Rod Trent posted an update in the group IT Fit: Science Launches Urban Remedy To Bring Healthy Juices, […] Rod Trent posted an update in the group The Word at myITforum: Psalm 119:147 I rise before the dawning of the morning, And […] Todd Miller commented on the post, SCCM Right Click Tools September 17, 2012 update for ConfigMgr 2007/2012 Todd Miller commented on the post, SCCM Right Click Tools September 17, 2012 update for ConfigMgr 2007/2012 Todd Miller became a registered member Rod Trent posted an update in the group Microsoft Surface: Display shootout: Microsoft Surface RT vs. iPads vs. Android […] Cloud Infrastructure, VDI Issues Cost Businesses Millions: Endace Owen joined the group Script Gallery Owen joined the group System Center Service Manager Owen joined the group Software Licensing and SAM Owen joined the group System Center Operations Manager Owen joined the group System Center Orchestrator/Opalis Rod Trent uploaded the file: Query for Java to Configuration Manager Queries, Reports, and MOFs Owen became a registered member Rod Trent wrote a new post, Infographic: The power hungry Internet Posted: 16 Nov 2012 10:51 AM PST It's amazing how much the Internet and it's usage has grown. I can kind of remember I time without it, but that seems so very long ago now. Compiled By: WirelesSatelliteInternet.org Comments: 0 Brooke Owens joined the group System Center Jobs Posted: 16 Nov 2012 10:30 AM PST Comments: 0 Brooke Owens joined the group Ron's Web Essentials Posted: 16 Nov 2012 10:30 AM PST Comments: 0 Brooke Owens joined the group Operating System Deployment Posted: 16 Nov 2012 10:29 AM PST Comments: 0 Brooke Owens joined the group System Center Configuration Manager 2012 Posted: 16 Nov 2012 10:28 AM PST Comments: 0 Brooke Owens joined the group SCCM Right-click tools Posted: 16 Nov 2012 10:28 AM PST Comments: 0 Rod Trent posted an update in the group IT Fit: Science Launches Urban Remedy To Bring Healthy Juices, […] Posted: 16 Nov 2012 09:30 AM PST Science Launches Urban Remedy To Bring Healthy Juices, Gluten-Free Snacks And More To The Masses | TechCrunch Comments: 0 Rod Trent posted an update in the group The Word at myITforum: Psalm 119:147 I rise before the dawning of the morning, And […] Posted: 16 Nov 2012 08:42 AM PST Psalm 119:147 I rise before the dawning of the morning, And cry for help; I hope in Your word. Comments: 0 Todd Miller commented on the post, SCCM Right Click Tools September 17, 2012 update for ConfigMgr 2007/2012 Posted: 16 Nov 2012 07:48 AM PST Figured it out. You have to run the main installer first - its the top link before you get down to the updates. The updates are separate from the main installer. They are updates to the tool - not updates to […] Comments: 0 Todd Miller commented on the post, SCCM Right Click Tools September 17, 2012 update for ConfigMgr 2007/2012 Posted: 16 Nov 2012 07:38 AM PST Me too. I get the error above- ed9ee86... The installer creates files at 2b64eff..., and ed9ee86 does not exist. Comments: 0 Todd Miller became a registered member Posted: 16 Nov 2012 07:32 AM PST Comments: 0 Rod Trent posted an update in the group Microsoft Surface: Display shootout: Microsoft Surface RT vs. iPads vs. Android […] Posted: 16 Nov 2012 07:17 AM PST Display shootout: Microsoft Surface RT vs. iPads vs. Android Tablets | ZDNet Comments: 0 Cloud Infrastructure, VDI Issues Cost Businesses Millions: Endace Posted: 16 Nov 2012 05:30 AM PST A survey indicates businesses are rapidly adopting network-centric computing like unified communications and VDI platforms. Owen joined the group Script Gallery Posted: 16 Nov 2012 05:30 AM PST Comments: 0 Owen joined the group System Center Service Manager Posted: 16 Nov 2012 05:18 AM PST Comments: 0 Owen joined the group Software Licensing and SAM Posted: 16 Nov 2012 05:18 AM PST Comments: 0 Owen joined the group System Center Operations Manager Posted: 16 Nov 2012 05:18 AM PST Comments: 0 Owen joined the group System Center Orchestrator/Opalis Posted: 16 Nov 2012 05:18 AM PST Comments: 0 Rod Trent uploaded the file: Query for Java to Configuration Manager Queries, Reports, and MOFs Posted: 16 Nov 2012 05:06 AM PST Use this query to locate Java inventory. You'll need to modify the versioning information in the query to find the version you are inventorying. Comments: 0 Owen became a registered member Posted: 16 Nov 2012 05:02 AM PST Comments: 0