With the Release of SCCM Configmgr 2012 SP1 RTM,When you deploy Secondary Site from its Parent site ,it will install SQL Server Express 2008 R2 Service Pack 1 (SP1) but as you can see from below snap (SQL server Requirements),the minimum required cumulative update is CU6 which you will have to install it manually. Read more on http://support.microsoft.com/kb/2688247/en-us?sd=rss&spid=1060:SQL
Author: Eswar Koneti
Read More
When you are doing Migration from SCCM 2007 to SCCM 2012,you may want to remove some of the drivers which are no longer needed . This report list all the drivers which are part of any driver package so you can take action on them before you migrate to SCCM Configmgr 2012. Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c82cc16a-06b7-49ae-ac11-2f6399047b6a select locCI.DisplayName as DriverName,locci.CI_ID, drivers.DriverClass as DriverClass, drivers.DriverProvider as ProviderName, drivers.DriverVersion as DriverVersion, CIs.IsEnabled as DriverEnabled0 from v_CI_DriversCIs drivers inner join v_ConfigurationItems as CIs on CIs.CI_ID=drivers.CI_ID inner join v_LocalizedCIProperties_SiteLoc as locCI on drivers.CI_ID=locCI.CI_ID where locCI.CI_ID not in (select ci_id from v_DriverContentToPackage)
Status of Specific Advertisement can get from Default available report but what if you want to find the status of specific advertisement with its LastAcceptanceStatusTime greater or less than X days. Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/30e4dbda-982b-43dc-8665-8dd142925d4f DECLARE @olddate datetime ,@NullVal datetime SET @olddate = DATEADD(day,-5, GETUTCDATE()) select adv.AdvertisementName 'Application', sys.Name0 'System', LastAcceptanceStateName 'Acceptance', sts.LastAcceptanceStatusTime 'AcceptTime_GMT', sts.LastStatusMessageIDName 'ExecutionStatus', sts.LastStateName 'ExecutionState',sts.LastStatusTime 'ExecutionTime_GMT', adt.MessageName,sts.LastExecutionResult from v_ClientAdvertisementStatus sts join v_AdvertisementStatusInformation adt on adt.MessageID=sts.LastStatusMessageID join v_Advertisement adv on adv.AdvertisementID=sts.AdvertisementID join v_R_System sys on sys.ResourceID=sts.ResourceID where ((sts.LastAcceptanceStatusTime < @olddate) or (sts.LastStatusTime < @olddate)) and adv.AdvertisementName like '%Adobe_reader_Eng%' and sts.LastExecutionResult like '1603' order by sys.Name0 Change the number…
With the Release of SCCM Configmgr 2012 SP1 supports windows 8 and Windows server 2012 Operating System.It also Supports Non-Windows Operating Systems like Apple Mac,Unix and Linux. The client for Mac computers allows you to discover, collect inventory, manage settings, and deploy applications and patches using your Configmgr environment. Microsoft System Center 2012 Configuration Manager SP1 also supports the management of UNIX and Linux servers. The clients for UNIX and Linux extends the scope of your Configuration Manager environment to collect inventory, deploy software, and run reports about UNIX and Linux servers in your enterprise. The client operates as a…
In this Week TechNet Radio show, Keith Mayer and Wally Mead Senior Program Manager from the System Center Client Management team and all-around ConfigMgr Guru continue their “What’s New” in System Center 2012 Configuration Manager Service Pack 1 series and in today’s episode they discuss how we can manage App-V 5 Virtual Applications. Tune in as they demo its new capabilities as well as walk us through a deployment of a virtual application in ConfigMgr 2012 SP1. In this episode, we'll be covering ... New Support for App-V 5 virtual applications App-V 5 Connection Groups / Virtual Environments Deploying App-V…
The easiest possible way to remove the sccm client is to run the command line ccmsetup.exe /uninstall from windows\ccmsetup folder. But what if ccmsetup.exe do not exists on some of the client machines and you would require to remove the client on them ? and if ccmsetup.exe does not work for you to remove the sccm client successfully ? Mike Griswold did a post on this how to do manual executions to remove sccm client without using ccmsetup.exe on the way at his customer place. So You can perform below steps to manually clean-up all the traces of the client.…
When i try to run SCCM Reporting Services Report,I get error always saying ‘Cannot create a connection to data source 'AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_'. I verified if the user has sufficient permissions to access the database (datasource) or not,User has enough permissions. Error Message: If you look at the above Screen shot,it says “You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server” I check…
To kick off the new year, I’d like to share with you data on my blog’s activity in 2012 how did blog went with posts,number of visitors and some interesting count. I would like to thank you for visiting ESKONR.COM reading blogs. Here are the statistics for the Year 2011 Crunchy numbers: About 55,000 tourists visit Liechtenstein every year. This blog was viewed about 190,000 times in 2012. If it were Liechtenstein, it would take about 3 years for that many people to see it. Your blog had more visits than a small country in Europe! In 2012, there were…