In this post, i will discuss about the requirement that i have got recently. Local team /manager wants to run…
Browsing: SQL code
Other day,I was trying to create my first SCCM Configmgr SSRS report with RBA (role based administration) what it…
Introduction: Few months ago ,we had an issue with one of the deployment (it was software updates) that was deployed…
Collections in Configmgr play a crucial role .If you want to do anything(can be software deployment,OSD ,Client agent settings,Software updates,compliance…
This post is an extension to my previous article to view the content status for the applications,packages,driver packages,software updates,windows images…
We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version…
Full details:http://social.technet.microsoft.com/Forums/systemcenter/en-US/82a7862a-fc1c-4c45-9635-ee44489c2673/file-inventory-report-query-by-name-count-and-machineid?forum=configmgrreporting select cs.Name0 [Computer name],COUNT(*) as [No of Times] from v_GS_SoftwareFile SF,v_GS_COMPUTER_SYSTEM cs where FileName like '%.mdf%' and…
We have been seeing many hotfixes and Cumulative updates for configmgr 2012 product .For each hotfix /CU level,the client version…