Category: SCCM 2007

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 28, 2013 by | 4 Comments | 2,170 Views
Old post but useful to share from J.C.HornBeck .We all know there are some hidden files(they are kind of secret files) which are available since Since Many years( I would think from SMS 2003 or may be from 2.0) in order to activate or deactivate some features in SMS/SCCM 2007 /SCCM 2012 (now) on client…
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 »

Posted on January 10, 2013 by | 0 Comments | 154 Views
There was a useful email exchange recently about a list of reasons for moving from SCCM 2007 to 2012. so here are some of the Reasons to move Move from SCCM Configmgr 2007 to SCCM Configmr 2012 User device affinity is introduced, a method of associating a user with one or more devices. Software distribution…
Read more »