Uninstall button is disabled in Software Centre in SCCM 2012 R2 for available Applications

In SCCM 2012 R2 RTM, There is a known issue that if an application contains multiple Deployment Types, after the application gets installed successfully on the client as  available, uninstall button in the software centre is disabled and there is no easy way to perform Uninstallation of the software. In my example, I have used the…


How to move an application to a folder programmatically

  Prerequisites Add AdminUI.WqlQueryEngine.dll as a reference Get the ContainerID of a folder by querying SMS_ObjectContainerNode WMI Class with ObjectType = 6000 (6000 indicates Application). Model Name of the application by querying ModelName from SMS_ApplicationLatest WMI Class   Solution Call MoveMembers method on SMS_ObjectContainerItem method by specifying InstanceKeys as the modelname of the application, ContainerNodeID…


Uninstall button is disabled in Software Centre

It is a common question in Forums why Uninstall button is disabled in Software Centre : There are quite interesting things needs to know the reason behind it :   1)  If the software is deployed as “required” , it is not possible to uninstall from Software Centre. However the user can go to Programs…


Creation of Deployment Types using Powershell Cmdlets in SCCM 2012 R2 Preview

Here are the sample examples to create deployment types: Android App From Google Play: PS DEV:\> Add-CMDeploymentType -ApplicationName TestApp -AutoIdentifyFromInstallationFile – ForceForUnknownPublisher $true -InstallationFileLocation “https://play.google.com/store/apps/details?id=com.gameatelier.sela&feature=featured-apps iOS App from IStore: PS DEV:\>Add-CMDeploymentType -ApplicationName TestApp -AutoIdentifyFromInstallationFile – ForceForUnknownPublisher $true -InstallationFileLocation “https://itunes.apple.com/us/app/calorie-counter-diet-tracker/id341232718?mt=8” –iOSDeepLinkInstaller Win Phone 8 from Win Phone Store: PS DEV:\> Add-CMDeploymentType -ApplicationName TestApp -AutoIdentifyFromInstallationFile -ForceForUnknownPublisher $true…


Application failure retry behavior in SCCM 2012

If the MSI app fails with an exit code in{4,5,8,13,14,39,51,53,54,55,59,64,65,67,70,71,85,86,87,112,128,170,267,999,1003,1203, 1219,1220,1222,1231,1232,1238,1265,1311,1323,1326,1330,1618,1622,2250},a retry will happen for every 2 hours up to 10 times. Applcation Deployment Evaluation Cycle will run for every 7 days by default and tries to evaluate all applications whenever this cycle is ran.   Note: The abovedata i have got is based on…


Creation of App-V Virtual Environments in SCCM 2012 SP1

Virtual Environment concept makes the virtual applications on the client to share the same file system and registry on client settings and share data among them. These Virtual Environments gets created on the clients whenever the virtual applications are installed/evaluated on the client side. PreRequisites: Assuming App-V5 Applications already created in the Site Server  …


New Features in SSMS Denali

1. Surround With Feature This feature allows us to select a set of T-SQL statements and enclose them into Transactional, Conditional, & Looping etc. constructs like Begin-End, If-Else, & While etc.   Steps: i) Open SSMS and open Query Editor ii) Enter the query and select the query iii)  On selecting Surround With… from context…


Sequences in SQL Server

Customers have been asking for sequences for a very long time and now finally it is included with SQL Server Denali CTP 1. You don’t have to do workaround of sharing identity table across all tables now. Creating a Sequence: CREATE SEQUENCE counter AS INT MINVALUE 1 NO MAXVALUE START WITH 1; GO Get Next…


How to get Processors Count in SQL Server ?

SQL Server 2000: CREATETABLE#TempTable ( [Index]VARCHAR(MAX), NameVARCHAR(MAX), Internal_ValueVARCHAR(MAX), Character_ValueVARCHAR(MAX) ) INSERTINTO#TempTable EXECxp_msver SELECTInternal_Value From#TempTable WHEREName=‘ProcessorCount’ SQL Server 2005: select cpu_count / hyperthread_ratio AS PhysicalCPUs from sys.dm_os_sys_info  


SQL Server 2008 SP2 is released

SQL Server 2008 SP2 contains the following features: ·         All hotfixes released up to Microsoft SQL Server 2008 SP1 CU 8. ·         Updates to the Reporting Services Add-in for Microsoft SharePoint Products 2007 allowing customer to connect to SQL Server 2008 R2 Report Servers. ·         Support for SQL Server 2008 R2 version of Management Studio…