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…
Blog Stats for the Year 2012

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…