SCCM Duplicate System Entries in the Console If your SCCM console has duplicated System entries in the Console, and you want to find it right? Below is the Query for this issue. select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier,R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId full join SMS_R_System as s2 on s2.Name … Read more
SMS/SCCM Command-line Actions We can use WMIC tool to run on remote computers and get the client actions as we want Some examples to trigger SMS/SCCM Client Actions from command line: Disable Software-Distribution:WMIC /namespace:rootccmpolicymachinerequestedconfig path ccm_SoftwareDistributionClientConfig CREATE ComponentName="Disable SWDist",Enabled="false",LockSettings="TRUE",PolicySource="local",PolicyVersion="1.0" ,SiteSettingsKey="1" /NOINTERACTIVE Re-Activate Software-Distribution:WMIC /namespace:rootccmpolicymachinerequestedconfig path ccm_SoftwareDistributionClientConfig WHERE ComponentName="Disable SWDist" delete /NOINTERACTIVE Trigger Hardware Inventory:WMIC /namespace:rootccm path … Read more
Set objExcel = CreateObject("Excel.Application") objExcel.Visible = True objExcel.Workbooks.Add intRow = 2 objExcel.Cells(1, 1).Value = "Machine Name" objExcel.Cells(1, 2).Value = "Drive" objExcel.Cells(1, 3).Value = "Total Size" objExcel.Cells(1, 4).Value = "Used Space" objExcel.Cells(1, 5).Value = "Free Space" objExcel.Cells(1, 6).Value = "Free Space Percentage" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("MachineList.txt", 1) … Read more
WQL to SQL Want to see What is the query???????? This SQL Query can be used to see how WQL is converted to SQL by SMS for collections Select Collections.SiteID , Collections.CollectionName , Collection_Rules.QueryName , Collection_Rules_SQL.WQL , Collection_Rules_SQL.SQL From Collections,Collection_Rules, Collection_Rules_SQL Where Collections.CollectionID = Collection_Rules.CollectionID AND Collections.CollectionID = Collection_Rules_SQL.CollectionID——————- Thanks,https://sccm07.blogspot.com/
SCCM 2007 Right Click Tools latest version available, one can download from the below link https://myitforum.com/cs2/blogs/rhouchins/archive/2008/04/09/sccm-right-click-tools.aspx All the advantages from the above link are below( actual source is above link) 1. Most of the tools that were included in the original SMS Console Additions V1.4 2. The ability to see the computer … Read more
select * from dbo.Network_DATA Where MACAddress0 = '00:21:70:39:a2:b7' select * from system_disc where Name0 = 'Machine Name' then change it to delete Will post more on this….——————-Thanks,https://sccm07.blogspot.com/
Tasksequence Issue: In Build and Captured error “Task Sequence Manager could not resume SMS components. code 80004005 TSManager 2/12/2009 12:15:04 AM 1268 (0x04F4)” Resolution 1:- Make sure in Task Sequese you have joining to Workgroup. Because sysprep can not be make under joining into domainResolution 2:- Check your Network desgin if it is build with … Read more
For a Copy a Folder Dim wShellstrComputer = “.”Set objWMIService = GetObject _ (“winmgmts:” & strComputer & “rootcimv2:Win32_Process”)‘errReturn = objWMIService.Create _ ‘ (“cmd.exe /c md c:ups”, Null, Null, intProcessID)Set objFSO = CreateObject(“Scripting.FileSystemObject”) objFSO.CopyFolder “file://172.20.128.51/sms_uk/Oct 2008*.*” , “c:pav” , OverwriteExisting Set wShell = CreateObject(“WScript.Shell”)‘wShell.Run “c:upsElection.html”Const OverwriteExisting = TRUE
Windows Update: Patch Management Error 8024400E in the log file: If you find 8024400E error in the patching failing system that means patchs are not approved. Approve it in the update list. ——————-Thanks,https://sccm07.blogspot.com/
To Clear SCCM / SMS CCM / Cache Folder ' Script to Clear SMS cache files on error resume next dim oUIResManager dim oCache dim oCacheElement dim oCacheElements set oUIResManager = createobject("UIResource.UIResourceMgr") if oUIResManager is nothing then ' wscript.echo "Couldn't create Resource Manager – quitting" wscript.quit end if set oCache=oUIResManager.GetCacheInfo() if oCache … Read more
