image_thumb.png

SCCM Configmgr SSRS Report How do I quickly tell if Clients are compliant or not for all the approved patches?

Another interesting report  on software update compliance which will really helps lot of people in their daily job . Did you ever receive any requests to report compliance status(in one line report) for bunch of clients for ex: specific collection ? Management or Security guys do not really care about what software updates the computer... Continue Reading >>

0
image_thumb.png

Configmgr SSRS SQL Query How to check Client is member of what collections and its Maintenance Window

  This is quick post on How to check Client is member of what collections and display its Maintenance window . Maintenance Window information for collections are stored in view called v_ServiceWindow .Here is the excel spreadsheet that I always make it as reference for any custom queries always help to find right view. http://eskonr.com/2013/10/download-sccm-configmgr-2012-r2-sql-views/... Continue Reading >>

0
image_thumb.png

SCCM Configmgr How to generate patch compliance report that shows all updates for specific collection ?

There are couple of posts on TechNet blog and other forums asking for ‘Is there any report that list all updates with compliance status for specific collection’ ? Read it once again ,A software update compliance report that list all updates whether Targeted, Installed, Missing for specific Collection. A collection may contain X number of... Continue Reading >>

0
image_thumb.png

SCCM Configmgr SSRS Report Get list of missing updates for PC from specific Software update group

Few months ago,I posted blog on How to get list of missing/Required software updates for specific computer which helps to identify if a PC is 100% complaint or not for list of available patches(metadata) from SCCM,but that report gives you overall missing patches from SCCM DB irrespective of whether they are part of any software... Continue Reading >>

0
image_thumb.png

Download SCCM Configmgr V1511 SQL Views documentation

  After the release of Configmgr V1511,really busy setting up the new lab,upgrading the stuff from Configmgr 2012 R2 SP1 to SCCM Configmgr V1511 (In Place) and doing things with it. This post is about,what are the SQL views in SCCM Configmgr V1511 that helps you to write custom SSRS /SQL queries. As you know,there... Continue Reading >>

0
image_thumb.png

Download and Install SCCM Configmgr V1511 RTM available

The latest version of Configuration manager which is V1511 (YY/MM) RTM for December 2015 from Microsoft is now available for download and ready to install to production Environment. We call this version as System Center Configuration Manager current branch (CB) and Microsoft has updated TechNet documentation on December 8 (Yesterday) for this version .The documentation... Continue Reading >>

0
image_thumb.png

Download and Install SCCM Configmgr Vnext Technical Preview 4

  Microsoft released Technical preview 4 (TP4) for Configmgr Vnext ( System Center Configuration Manager and Endpoint Protection ) .The previous technical preview was Technical preview 3 with updated version 1510 (YYMM). Microsoft haven’t updated the TechNet documentation with capabilities available with this release (TP4) for now but soon to be updated here on https://technet.microsoft.com/library/dn965439.aspx.... Continue Reading >>

2
image_thumb.png

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... Continue Reading >>

0
© 2015 Eswar Koneti's Blog. All rights reserved.