SCCM Duplicate System Entries in the Console

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 = s1.Name where s1.Name = s2.Name and s1.ResourceId != s2.ResourceId

 

I love this Query, especially.

 

 

 

-------------------
Thanks,
http://sccm07.blogspot.com/

SMS/SCCM Command-line Actions - alternate to right click tools ?

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:\\root\ccm\policy\machine\requestedconfig 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:\\root\ccm\policy\machine\requestedconfig path ccm_SoftwareDistributionClientConfig  WHERE ComponentName="Disable SWDist" delete /NOINTERACTIVE

Trigger Hardware Inventory:
WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000001}" /NOINTERACTIVE

Trigger Software Inventory:
WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000002}" /NOINTERACTIVE

Trigger DataDiscoverRecord (DDR) update:
WMIC /namespace:\\root\ccm path sms_client CALL TriggerSchedule "{00000000-0000-0000-0000-000000000003}" /NOINTERACTIVE

Force a FULL HW Inventory on next HW-Inv Schedule:
WMIC /namespace:\\root\ccm\invagt path inventoryActionStatus where InventoryActionID="{00000000-0000-0000-0000-000000000001}" DELETE /NOINTERACTIVE

Repair SMS/SCCM Agent on a remote client:
WMIC /node:%MACHINE% /namespace:\\root\ccm path sms_client CALL RepairClient

Repair a list (all clients listed in clients.txt) of remote SMS/SCCM Agents:
WMIC /node:@clients.txt /namespace:\\root\ccm path sms_client CALL RepairClient

-------------------
Thanks,
http://sccm07.blogspot.com/

VB Script Drive Space Check on list of System

 

 

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)

 

Do Until objFile.AtEndOfStream

strComputer = objFile.ReadLine

Set objWMIService = GetObject("winmgmts://" & strComputer)

 

On Error Resume Next

Set colDisks = objWMIService.ExecQuery("Select * From Win32_LogicalDisk Where DriveType = 3")

For Each objDisk In colDisks

objExcel.Cells(intRow, 1).Value = Ucase(strComputer)

objExcel.Cells(intRow, 2).Value = objDisk.DeviceID

objExcel.Cells(intRow, 3).Value = (FormatNumber(objDisk.Size/ 1024^3, 1)) & " GB"

objExcel.Cells(intRow, 4).Value = (FormatNumber(objDisk.Size/ 1024^3, 1) - FormatNumber(objDisk.FreeSpace/ 1024^3, 1)) & " GB"

objExcel.Cells(intRow, 5).Value = (FormatNumber(objDisk.FreeSpace/ 1024^3, 1)) & " GB"

objExcel.Cells(intRow, 6).Value = FormatPercent(objDisk.FreeSpace/objDisk.Size, 0)

 

If FormatPercent(objDisk.FreeSpace/objDisk.Size, 0) <= "25%" Then

objExcel.Cells(intRow, 6).Font.ColorIndex = 3

Else

End If

 

intRow = intRow + 1

Next

Loop

 

objExcel.Range("A1:F1").Select

objExcel.Selection.Interior.ColorIndex = 19

objExcel.Selection.Font.ColorIndex = 11

objExcel.Selection.Font.Bold = True

objExcel.Cells.EntireColumn.AutoFit

 

MsgBox "Done"

 

 

-------------------
Thanks,
http://sccm07.blogspot.com/

WQL to SQL Query

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,
http://sccm07.blogspot.com/

SCCM 2007 Right Click Tools latest version available, one can download from the below link

SCCM 2007 Right Click Tools latest version available, one can download from the below link

 

http://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 details and security compliance web reports for a single client inside collections

3.       A separate drill down for client logs as well as security update client logs.

4.       The ability to check the status of an advertisement with a right click from that advertisement In order to get the client and the advertisement web reports to work you must perform the following.

5.       Fixed the right click tools on the "collections" that didn't open a CMD window when running. Also fixed the echo so the results now show up in a command window

6.        Will detect the version of the tool installed so re-installation of unnecessary files does not occur when new versions are released

7.        Now has an entry in Add Remove Programs which enables un-installation of the program

8.       No more hard coding of your site code to get scripts and reports to run correctly

9. Detects and uninstalls any previous versions of the tool.
10. Right click tool added to the software updates node, but it only works if there is a update list with patches deployed. 
11. Prefixed each tool with your SCCM site code for easier recognition
12. Right click ability on each advertisement that will display three web reports
13. Added a prompt to see the CCMsetup.log on the SCCM Client install
14. Fixed the Client Action for User Policy Evaluation and Update

15. Added all the client actions from the control panel including the Security Updates Scan and Security Updates Deployment Evaluation
16. Added an extension to the client tools that will tell you what collection a user or system belongs to.
17. Added a web report to show all the advertisements for a certain system.

18. CCM and CCMSetup directories now work properly.

19. Added the Software Updates Scan Cycle to the Collection root so it runs not just on one client but a whole collection.  Requested by a member from the forum community.
20. Added Support for Windows 2008 64bit.
21. New Tool to Re-run advertisements from a drop down list.
22. Added the ability to run client actions from the Query results.
23. Fixed issue with script.bat

-------------------
Thanks,
http://sccm07.blogspot.com/

SCCM How to make know to unknow

 

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,
http://sccm07.blogspot.com/

SCCM OSD Error code 80004005

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 domain
Resolution 2:- Check your Network desgin if it is build with Cisco then might be Fast Port opened need to stop this to fix it.. Yep I never find this information microsoft site (I ver bad in searching )but this is the solution What i found.

-------------------
Thanks,
http://sccm07.blogspot.com/

VBSCRIPT For a Copy a Folder

For a Copy a Folder

Dim wShell
strComputer = "."
Set objWMIService = GetObject _
("winmgmts:\\" & strComputer & "\root\cimv2: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:\ups\Election.html"
Const OverwriteExisting = TRUE

Patch Failed to scan and install Error 8024400E

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,
http://sccm07.blogspot.com/

vb script To Clear SCCM / SMS CCM / Cache Folder

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 is nothing then
     set oUIResManager=nothing
'      wscript.echo "Couldn't get cache info - quitting"
     wscript.quit
end if
set oCacheElements=oCache.GetCacheElements
'wscript.echo "There are " & oCacheElements.Count & " cache elements"
'wscript.echo
' ***** Begin CLEAR CACHE *****
for each oCacheElement in oCacheElements
oCache.DeleteCacheElement(oCacheElement.CacheElementID)
next
' ***** End CLEAR CACHE *****

' ***** Clean up *****
set oCacheElements=nothing
set oUIResManager=nothing
set oCache=nothing

-------------------
Thanks,
http://sccm07.blogspot.com/

Change Default Power Management settings on Laptop users

Change Default Power Management settings on Laptop users to utilize batarry save

 

@echo off
powercfg /change "Portable/Laptop" /standby-timeout-ac 30 /standby-timeout-dc 30 /hibernate-timeout-ac 45 /hibernate-timeout-dc 45
powercfg /setactive "Portable/Laptop"

 

-------------------
Thanks,
http://sccm07.blogspot.com/

Change Default Power Management settings

To Change Default Power Management settings  to your own settings that is to allway On:--

 

@echo off
powercfg /change "Always On" /monitor-timeout-ac 30 /monitor-timeout-dc 30 /standby-timeout-ac 30

/standby-timeout-dc 0 /hibernate off
powercfg /setactive "Always On"
-------------------
Thanks,
http://sccm07.blogspot.com/

SCCM Query for SCCM Clients Model and Manufactures Name

Need to extract SCCM Clients Model and Manufactures Name?

 

You have to dig the Computer_System_DATA Table. Here are two shared SQL Querys.

 

Select DISTINCT Model0 from Computer_System_DATA

The above one will show all the Models

The below Query will show everything in the Database

Select

* from Computer_system_data

-------------------
Thanks,
http://sccm07.blogspot.com/

Use a PSEXEC tool to deploy software on list of systems in text file

Use a PSEXEC tool to deploy software on list of systems in text file

 

psexec @systems.txt -c exefilname.exe /silient commands

-------------------
Thanks,
http://sccm07.blogspot.com/