SCCM Duplicate System Entries in the Console

by

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 – alternate to right click tools ?

by

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

VB Script Drive Space Check on list of System

by

    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 Query

by

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

by

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

SCCM How to make know to unknow

by

  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/

SCCM OSD Error code 80004005

by

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

VBSCRIPT For a Copy a Folder

by

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