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…
Author: Eswar Koneti
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…
SCCM Configmgr 2012 SP1 is out now and available only for MSDN and TechNet subscribers for now.For General Availability,we may have to wait for couple of days or so. Johan updated the Hydration Kit to automate the installation of SCCM 2012 SP1 with One Domain Controller and Configmr 2012 SP1 Member server with all the required prerequisites. It took 3 hours of time to complete the setup on Johan Laptop.Installation time may vary on the resources what you have on your computer. For more information about Hydration Kit and download details http://www.deploymentresearch.com/Research/tabid/62/EntryId/82/The-Hydration-Kit-for-ConfigMgr-2012-SP1-with-Windows-Server-2012-SQL-Server-2012-is-available-for-download.aspx
Various methods to get the Uninstallation String for particular application.You can go with MOF changes to get uninstall string from registry(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall and HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall ) using Mark regkeytomof or You can use BDNA Normalize. Now aDays ,most of the organizations are converting Applications to MSI with more customizations with unattended installation except some applications which has msi inbuild with EXE file using Packaging Tools. More info about Packaging stuff,you can get from ttp://www.itninja.com/ You can uninstall particular application if you have MSI ID or product ID using simple Command msiexec /x {ProductID} . If you have used MSI based application to install…