SCCM Configmgr SSRS SQL Expression Examples Frequently Used

  While Creating SSRS reports for configuration manager ,I use lot of expressions through the report definition. These expressions (formula filed) are used frequently in reports to control content and report appearance. Expressions are written in Microsoft Visual Basic, and can use built-in functions, custom code, report and group variables, and user-defined variables. Expressions begin…
SCCM Configmgr 2012 Software update compliant non-compliant results for list of computers from collection for specific month

Few days ago ,I was working on request to get the software update compliance (compliant /Non-Compliant) for list of clients (Desktops or servers) from collection for specific month.I have posted lot of Configmgr 2012 SSRS reports on my blog http://eskonr.com/tag/sccm-patch-reports/about software update compliant but this is something different compared to other reports. Due to the…
How to Install MBAM 2.5 SP1 and integrate with SCCM Configmgr 2012 R2 SP1

  MBAM is Microsoft Bitlocker Administration and Monitoring Tool Enables administrators to automate the process of encrypting volumes on client computers across the enterprise.BitLocker offers protection against data theft or data exposure for computers that are lost or stolen. BitLocker encrypts all data that is stored on the Windows operating system and drives and configured…
How to Install MBAM 2.5 SP1 and integrate with SCCM Configmgr 2012 R2 SP1 – Part 4

  In part 3 here of this MBAM 2.5 SP1 multi series guide,we have installed MBAM prerequisites for configuration manager 2012,changes to MOF file,inventory changes,MBAM collection etc. In this part 4 ,we will see the main components of MBAM 2.5 SP1, which are database ,reports and web application. Login to MBAM01 server with CM_SRV (MBAM_admin)…
How to Install MBAM 2.5 SP1 and integrate with SCCM Configmgr 2012 R2 SP1 – Part 3

  In Part 2 here of this MBAM 2.5 SP1 multi series, we have installed prerequisites for Windows roles/Features and SQL server components,Permissions to the Database and reports. In this post (part 3) ,we will see the prerequisites for the Configuration Manager Integration feature with MBAM. If you do not want to integrate MBAM 2.5…
How to Install MBAM 2.5 SP1 and integrate with SCCM Configmgr 2012 R2 SP1 – Part 2

  In part 1 here ,we have created the AD user accounts,security group and register SPN .In part 2 of this multiple series guide ,we will install windows roles/features ,SQL server 2012 SP1 and configure database,permissions etc on our MBAM server (MBAM01). MBAM SQL server Requirements: Login to the MBAM01 server using account that has…