Tags: SCCM

Posted on May 3, 2013 by | 0 Comments | 2,585 Views
SQL Code used in SCCM Reporting to get list of Advertisements that are Mandatory! select adv.AdvertisementName as [Adv Name], adv.PresentTime as DistributionDate, pkg.Name as PackageName, pgm.ProgramName, coll.Name as CollectioName, adv.AdvertisementID from v_Advertisement adv join v_Package pkg on adv.PackageID=pkg.PackageID join v_Program pgm on adv.PackageID=pgm.PackageID and adv.ProgramName=pgm.ProgramName join v_Collection coll on adv.CollectionID=coll.CollectionID join v_ClientAdvertisementStatus stat on adv.AdvertisementID=stat.AdvertisementID…
Read more »

Posted on April 1, 2013 by | 0 Comments | 2,564 Views
How to add link URL or shortcut file to users desktop profile ? Easiest way to accomplish this task is with GPO(Group policy Object). If you want to accomplish this task using Configuration manager(SCCM),you can create simple VB script that does this job.   Option Explicit dim path path=CreateObject("WScript.Shell").ExpandEnvironmentStrings("%UserProfile%\desktop") dim objFSO set objFSO=CreateObject("Scripting.FileSystemObject") If objFSO.FileExists(path &…
Read more »
SCCM Configmgr 2007 Script move packages to Archive Folder

Posted on March 13, 2013 by | 0 Comments | 892 Views
This is Continuation to previous post package archival process.up on the query results,I would not delete the packages from console directly rather i delete them from its assigned Distribution points and move them to Archive folder and let be there for sometime until for sometime incase if it is required. If you have large number…
Read more »

Posted on February 27, 2013 by | 1 Comment | 1,250 Views
Long ago ,written SCCM report to list packages not used for 6 months as part of Package Archival process http://eskonr.com/2012/11/sccm-configmgr-package-archival-process-cleanup-activity/ .This report tells you to take further action to clean or move to Archive folder to wait for some more months before it goes for Deletion. What next ? Delete these packages from Assigned DPs…
Read more »

Posted on January 19, 2013 by | 13 Comments | 58 Views
Happy to say that ‘Microsoft Community Contributor Award’ is renewed for 3rd time in a Row since 2011 for my contribution towards Microsoft Technical forum on Configuration Manager. Dear Eswar, Congratulations! We are pleased to inform you that your contributions to Microsoft online technical communities have been recognized with the Microsoft Community Contributor badge. This…
Read more »

Posted on January 15, 2013 by | 1 Comment | 3,306 Views
  Problem : Someone has Created package/Package’s (bulk) and distributed to sites/DP’s and these packages are in large size(more than 1GB). You get notification from network Team or other teams about bandwidth issues.You may have to identify what packages are in process of sending to DPs and should also check how much % leftover to…
Read more »
SCCM Patch compliance Report Last 1 month for specific Collection

Posted on December 14, 2012 by | 13 Comments | 9,213 Views
Update: SSRS Report for Configuration manager 2012 (all Versions) is available on http://eskonr.com/2014/02/configmgr-ssrs-report-patch-compliance-statistics-last-30-days/ In my previous blogs,I posted couple of reports for Patch compliance status based on the KB/MS ID numbers . SCCM Patch Compliance Progress report:  http://eskonr.com/2009/10/patch-status-compliancesoftware-updates-report-in-sms-sccm/ Software Update Compliance Status on Specific Collection : http://eskonr.com/2009/09/report-for-software-update-report-for-software-update-compliance/ SCCM monthly Patch statistics report http://eskonr.com/2011/10/sccm-monthly-patch-statistics-reports-to-the-management-in-a-simplified-manner/ This report is going to…
Read more »