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…

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…

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…
SCCM Configmgr 2007 Reporting services Error ‘Cannot create a connection to data source’

  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…
SCCM Configmgr 2012 ADR Software Updates Fail to download updates Error 12007

Significant changes to Software Updates in Configuration manager 2012 compare with previous Version.One of the cool Feature is Automatic Deployment Rule which is Inhouse Feature of WSUS now incorporated into SCCM.To know more about what's new in SCCM 2012 Software Updates  http://technet.microsoft.com/en-us/library/gg699359.aspx Recently i was configuring ADR for windows 7 updates in lab to deploy…

  Finally 🙂 the most awaiting System center configuration manager(SCCM) 2012 SP1 RTM is now available for MSDN and TechNet Subscribers. For General Availability,we may have wait for some more days. If you have MSDN or TechNet  Subscription,you can download the product from http://technet.microsoft.com/en-us/subscriptions/ms772428.aspx Couple of points to be noted : Upgrade from Sp1 Beta…