Wednesday, March 18, 2009

SCCM 2007 with SQL Server 2005 Reporting Services

 
SCCM 2007 with SQL Server 2005 Reporting Services
 

Duration: 50 minutes 39 seconds
Size: 14.5MB

Watch Adam's video on DNRTV on these rules:

Part A (53:13) - 181MB
Part B (49:12) - 171MB
Part C (42:19) - 158MB

 

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

Friday, March 13, 2009

All the Third-Party Solutions for SCCM & SMS

Web Sites:

MyITForum is the premier online destination for IT professionals responsible for managing their corporations' Microsoft Windows systems; it is especially useful for IT professionals working with Microsoft Systems Management Server. (
http://www.myitforum.com)

FAQshop endeavors to provide a "one-stop-shop" for systems management questions, answers, and utilities. (
http://www.faqshop.com)

SMS Alliance is a consortium of companies that leverage joint resources to strengthen the capabilities and benefits of SMS. Their mission is to provide organizations with the best-of-breed solutions and services to enhance and extend SMS 2003. (
http://www.sms-alliance.com)

1E is one of the founding members of the SMS Alliance, 1E is a company on the cutting edge of systems management. It enhances and extends Microsoft management and deployment technologies, delivering advanced automation and reporting across the enterprise. (
www.1e.com)

Macrovision Corporation, another founding member of the SMS Alliance, Macrovision Corporation is a recognized leader in software deployment packaging, software installation, and software updating solutions. They offer one of the best software packaging tools with AdminStudio.
(
http://www.macrovision.com/)

PS'SOFT, as a founding member of the SMS Alliance, offers extenders for SMS 2003 that focus on IT asset management. They offer a web-based software cataloging system called SMS Software Requests. (
www.pssoft.com)

Vintela, another founding member of the SMS Alliance, Vintela offers a seamless solution to extend security and compliance of Microsoft Active Directory to Unix, Linux, and other platforms and applications. They offer solutions that help IT administrators manage Unix, Linux, and MAC systems using SMS 2003. Vintela is now part of Quest Software. (
www.vintela.com)

iAnywhere, the last founding member of the SMS Alliance, iAnywhere offers frontline security and management to SMS and provides extensions to manage your enterprise's mobile and wireless devices through SMS. (
www.iAnywhere.com)

AppDeploy is the Internet resource to go to when you need to script or repackage an application for distribution. Among other points of interest at the site is a massive library of applications, sorted by application name and vendor name. For each application listed, you'll find a community-based thread discussing the best practices, links, scripts, and challenges met/overcome with working with the application in regard to installation scripting/repackaging.(http://www.appdeploy.com/)

DesktopEngineer is perhaps one of the best resources in the Windows Installer arena. This site offers a wealth of information on Windows Installer technology, techniques, and troubleshooting tips. I have noticed that he is starting to increase the content related to Microsoft's upcoming PowerShell scripting language. (http://www.desktopengineer.com/)

Tools

SMSView is a utility that is used to extend the functionality of the Microsoft Systems Management Server 2003 advanced client. SMSView allows you to perform the following actions on an SMS advanced client: All nonadmin users to view current mandatory assignments and advertisement status, View advertisement history (past 60 days), View current mandatory assignments, Rerun advertisements, Remote operations (remotely view and manage the SMS client), Display hardware/software inventory status, Display management point/proxy management point, Repair the SMS advanced client. (
http://www.smsview.com/)

SMS 2003 Monster MOF is a MOF file that contains several new classes of MOF that will improve SMShardware inventory capabilities. The Monster MOF will enhance inventory data without requiring intimate knowledge of the SMS_DEF.MOF file. (
www.smsexpert.com)

SMS 2003 Web Remote Tools assist SMS administrators and allow client administration from a web page. (
http://www.myitforum.com/articles/19/view.asp?id=8662)

Corey Becht's Right-Click Tools is one of the best set of tools for all SMS administrators. This tool allows you to right click on any collection or individual PC within the SMS Administrator console and initiate hardware inventory, reassign the site code, restart the SMS Agent Host service, rerun advertisements without modifying the advertisement, perform discovery, initiate software inventory, create file collections, monitor software metering usage, refresh machine policies, evaluate policies, update Windows installer sources,change port number, and change cache size.These tools can run per computer resource or for all the members of a collection.(
www.myitforum.com/articles/8/view.asp?id=7099)

Microsoft SMS Toolkit 2: Microsoft released a very nice set of tools for SMS called the SMS Toolkit version 2 . It contains the following tools: IIS Lockdown 2.1 Template, URLScan 2.5 Template, Policy Spy, SMS Trace, Advanced Client and Management Point Cleaner, Advanced Client Spy, Policy Verifier, Send Schedule, Management Point Spy, Set Preferred Distribution Point and CAP, Delete Certificate, Patch Management Evaluation, Delete Group Class, Transfer SMS ID, Package Loader, Management Point Troubleshooter, Client Site Assignment Verifier, Site Boundary Tool, Create Secondary Site Tool, Create SMS Address Tool.(
www.microsoft.com/smserver/downloads/2003/tools/toolkit.mspx)


Security Logon Audit Tool (SLAT) extends SMS hardware inventory to include user logon information.This data can be used in web reports and queries. The tool includes the following samplereports: Top users for all systems, User logon information for a specific computer, Systems where the last logged-on user is not the top user, Systems where a specific user has logged on SLAT searches the security event log for the 528 event, which is created when user logon events occur and is enabled via Group Policy. (http://www.systemcentertools)

Enhanced System and User Discovery Tools, out of the box, SMS 2003 does a pretty good job of discovering systems from Active Directory. It's not perfect, though—there are a few gaps in its methods. The Enhanced System Discovery tool, assists in filling these gaps. Out of the box, SMS 2003 does not perform Windows NT 4 domain discovery. This tool solves that by enumerating all machines from a list of NT 4 domains, resolving their IP addresses from DNS or WINS, and creating data discovery records for each system. (http://www.systemcentertools/)

BITS Bandwidth Manager is an SMS Installer script that lets you throttle BITS bandwidthon Windows XP SP2 systems. You do not need to manually adjust any settings. The script takes care of the Registry key manipulation for you.(http://www.myitforum.com/inc/upload/11332BITSManager.zip)

1E SMSWakeUp: this WOL product is able to turn on computers after they have been shut down by users. The wake cycle can be triggered on a regular schedule to power up systems in preparation for the workday, or to perform software deployment activities. (http://www.1e.com/)

1E NightWatchman: Since we are talking about waking systems that have been shut down, it maybe a good practice to examine how best to shut down those systems in the first place. Why dowe want to shut down systems? We do this to enforce reboot cycles and to save energy costs. (http://www.1e.com/)

1E SMSNomad Branch: Some offices may not have the server hardware to allow for a Distribution Point (DP). But those offices may have a substantial number of users and/or be separated from the rest of the network by a low-speed or saturated WAN link, which you would rather not send multiple copies of a package across. SMSNomad Branch acts similar to a peer-to-peer network, allowing other computers to become DPs. If one machine is shutdown, another is selected as the DP. Included in this technology is multicast, increasing its efficiency to reduce network traffic on the local network segment. (http://www.1e.com/)

1E OSD Plus Pack: This is an enhancement to the SMS OSD Feature Pack. It allows you to leverage the SMS OSD Feature Pack in offices that do not have DPs. OSD Plus Pack offers similar functionality to SMSNomad Branch, but also has a few other applications bundledwith it: State Migration Editor, which is an interface for the User State Migration Tool, AppMigrator, which allows the automatic reinstallation of applications after OS imaging, PXE Lite, which is a local PXE server to allow deployment of OS images to bare-metalmachines booted from the network PXE server. (http://www.1e.com/)

SMS Companion 2006: This product provides WOL capabilities, similar to 1E's SMSWakeUp, but leverages slightly different technologies behind the scenes. A key difference is that SMS Companion puts systems in hibernation, rather than powering them off. The following are some of the key applications included with this product:Wake-on-Schedule: Allows clients to come out of a hibernation state. Service Windows: Allows you to restrict the SMS inventory and software distributions from happening during specific time periods, to reduce or eliminate user interruptions. Load Balancing: Allows you to reduce peak network and SMS server loading by making sure that the clients use these resources in a controlled manner. (http://www.smsexpert.com/)

Quest Management Xtensions for SMS: Since Windows platforms are not the only systems in an enterprise, you may need a way tomanage other platforms, such as Unix, Linux, and Mac OS X. These management extensions offer that capability for SMS 2003. One of the unique aspects of this product is its support route: first-level support is handled by Microsoft Product Support Services. (http://www.quest.com/quest-management-xtensions-for-sms)


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

SCCM / SMS Inactive systems from Active Directory?

Detailed Feature Comparison of ESD 2007, SMS 2003 and SCCM 2007

Feature ESD 2007 SMS SCCM 2007
Ability to extend discovery with additional AD Attributes Yes No Yes
Ability to filter on the when changed attribute Yes No No
Delta Discovery
– Only Discover AD Objects that have changed since the last discovery
Yes No No
Update Collection Membership Automatically when AD Group membership changes. New in R2! Yes No No
Discover only systems assigned to specific sites Yes No No
Run the discovery agent on a workstation reducing SMS/SCCM Server load Yes No No
:

Don't you think it's time to tie the knot?

  • Is SMS/SCCM continually discovering and troubleshooting inactive systems from Active Directory? How about disabled systems?
  • Do your patch compliance reports indicate less compliance due to a large percentage of inactive systems?
  • Is your organization paying for licenses they aren't using because of inactive systems being counted towards your Software Licensing Agreements?
  • Does it take hours or days for SMS/SCCM to update based on changes to systems in Active Directory?
  • Do you need to deploy software to systems immediately after they have changed OU's or been added to a new Active Directory group?
  • Are your site servers flooded with discovery records? Does it take all night or all weekend to complete an Active Directory discovery cycle?
 
Moreinfo can be find here

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

SCCM / SMS Inactive systems from Active Directory?

Don't you think it's time to tie the knot?

  • Is SMS/SCCM continually discovering and troubleshooting inactive systems from Active Directory? How about disabled systems?
  • Do your patch compliance reports indicate less compliance due to a large percentage of inactive systems?
  • Is your organization paying for licenses they aren't using because of inactive systems being counted towards your Software Licensing Agreements?
  • Does it take hours or days for SMS/SCCM to update based on changes to systems in Active Directory?
  • Do you need to deploy software to systems immediately after they have changed OU's or been added to a new Active Directory group?
  • Are your site servers flooded with discovery records? Does it take all night or all weekend to complete an Active Directory discovery cycle?
 
Moreinfo can be find here

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

SMS to SCCM Migration Made is with IE free Tool

This tool is designed to allow an SMS Administrator to Migrate all or selected packages and programs from his SMS environment into a System Center Configuration Management (ConfigMgr) environment. The tool has the following features:-

  • The Migration of Package and Program details along with source files
  • Renaming of Package and Program names during migration
  • Direct transfer of packages from your SMS site to ConfigMgr
  • Export to flat file structure from SMS site and Import into ConfigMgr from flat file
  • Exporting of SMSNomad command line settings to new ConfigMgr Nomad tab settings.


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

SCCM Collection / Computer Delete and Delete Special Explanation

 

  • Right clicking on a 'resource' and choosing 'Delete' will delete the resource from the SMS database
     
  • Right clicking on a 'Collection' and choosing 'Delete Special' will delete all objects in the Collection from the SMS database.
 
To restore the entry Again:

If the Client software has been installed but the information reflected by the resource entry in the MMC remains incomplete or inaccurate, you can correct it by deleting the existing resource entry and copy the '
SMSDISC.DDR' file from the target client workstation's '%WINDIR%\sms\sms\core\data' directory to the Site Servers '\sms\inboxes\ddm.box' directory.

Wait a few minutes then, in the MMC, highlight the '
All Systems' Collection, right click and select 'All Tasks | Update Collection Membership'. This usually places a small hour glass over the 'Collection' icon. Right click again and select 'Refresh'. A valid resource entry should now appear.

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

Thursday, March 12, 2009

SMS / SCCM Scheduled reboot :- Stop Schdeled restart / Shutdown

RSHUT Pro

RSHUT Pro is very usefull when you want to stop your system shuting down count time...

Just run this command in the execute mode...after installing the RSHUT Pro
 
rshutpro.exe /stop

Cancel previously scheduled shutdown action on the local computer
 
 
 

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

SQL Tables For accurate licence info

For accurate licence
 
 
select * from V_R_System_valid
select * from dbo.v_LU_MSProd
Select * from dbo.v_GS_INSTALLED_SOFTWARE

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

Friday, March 6, 2009

(C:\WINDOWS\IsUninst.exe)Uninstall Softwares with Batch file where you don;t have the msi commands

IsUninst.exe
 
Yes you can do a uninstall if you don;t have .msi files also.
 
 
below are the two software commands to where i tried with batch file
 
 
QuanvertDBA Software C:\WINDOWS\IsUninst.exe -y -x -a -fC:\qtime\qt\Undv5.7
Quantum57 Software C:\WINDOWS\IsUninst.exe -y -x -a -fC:\qtime\qt\Unv5.7
 
by adding y -x -a user window and prompting will not be display
 
 
-------------------
Thanks,
http://sccm07.blogspot.com/

Tuesday, March 3, 2009

FIND SQL Server Version with SQL Query

 
 
SELECT LTRIM(RIGHT(LEFT(@@VERSION,38),9))
SELECT 'SQL Server '    

+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '    

+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('    

+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

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

Thursday, February 26, 2009

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/

Tuesday, February 24, 2009

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/

Friday, February 20, 2009

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/

Monday, February 16, 2009

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
 
 
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

  1. Detects and uninstalls any previous versions of the tool.
  2. Right click tool added to the software updates node, but it only works if there is a update list with patches deployed. 
  3. Prefixed each tool with your SCCM site code for easier recognition
  4. Right click ability on each advertisement that will display three web reports
  5. Added a prompt to see the CCMsetup.log on the SCCM Client install
  6. Fixed the Client Action for User Policy Evaluation and Update
  1. Added all the client actions from the control panel including the Security Updates Scan and Security Updates Deployment Evaluation
  2. Added an extension to the client tools that will tell you what collection a user or system belongs to.
  3. Added a web report to show all the advertisements for a certain system.
  1. CCM and CCMSetup directories now work properly.
  1. 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.
  2. Added Support for Windows 2008 64bit.
  3. New Tool to Re-run advertisements from a drop down list.
  4. Added the ability to run client actions from the Query results.
  5. Fixed issue with script.bat

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

Thursday, February 12, 2009

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/

Monday, February 9, 2009

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


Friday, February 6, 2009

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/

Thursday, February 5, 2009

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/

Wednesday, February 4, 2009

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/

Tuesday, February 3, 2009

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/

Saturday, January 31, 2009

How to Install Configuration Manager Clients Using Software Update Point Based Installation

Step:1

To configure an Active Directory Group Policy object to specify the software update point for client installation and software updates

  1. Using an editor such as Windows Group Policy editor, open a new or existing Group Policy object.

  2. In the Group Policy editor, navigate to Computer Configuration / Administrative Templates / Windows Components / Windows Update, and then open the properties of the setting Specify intranet Microsoft update service location.

  3. Click Enabled.

  4. In the Set the intranet update service for detecting updates: field, specify the name of the software update point server you want to use, and the port. These must match exactly with the server name format and the port being used by the software update point:

    • If the Configuration Manager site system is configured to use a fully qualified domain name (FQDN), specify the server name using FQDN format.

    • If the Configuration Manager site system is not configured to use a fully qualified domain name (FQDN), specify the server name using a short name format.

    • If the site is in mixed mode and software updates is using the default Web site, the port number is likely to be 80 unless it has been changed.

    If the site is in mixed mode and software updates is using a custom Web site, the port number is likely to be 8530 unless it has been changed.

     If your WSUS Setup configured on port 8530 then the below URL will be placed

  5. In the Set the intranet statistics server: field, specify the name of the intranet statistics server you want to use. There are no specific requirements for specifying this server. It does not have to be the same computer as the software update point server, and the format does not have to match if it is the same server.

  6. Assign the Group Policy object to the computers on which you want to install the Configuration Manager client and receive software updates.

Step:2
To publish the Configuration Manager 2007 client to the software update point

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Site Management / <site code> – <site name> / Site Settings / Client Installation Methods.

  2. Right-click Software Update Point Client Installation, and click Properties.

  3. To enable client installation, select the Enable Software Update Point Client Installation check box.

  4. If the client software on the Configuration Manager 2007 site server is a later version than the client version stored on the software update point, the Upgrade Client Package Version dialog box will open. Click Yes to publish the most recent version of the client software to the software update point.

     
  5. To finish configuring the software update point client installation, click OK.

 

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

Wednesday, January 28, 2009

SCCM Client failes with Software Updates: WUAHandler.log Error = 0x80070002

SCCM Client failes with Software Updates:
 
 
Issue:- Software updates failes without installing when you check the WUAHandler.log file you will get below erro

OnSearchComplete - Failed to end search job. Error = 0x80070002. WUAHandler 1/28/2009 3:00:15 PM 3380 (0x0D34)
Scan failed with error = 0x80070002. WUAHandler 1/28/2009 3:00:15 PM 3380 (0x0D34)
 
Solution: Check will you able to connect wmi from remote system?
 
Rebuild the WMI
 

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

Tuesday, January 27, 2009

grave-accent character (`)

grave-accent character (`)
 

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

First command to start with Powershell is

First command to start with Powershell is

Get-Command
Get-Help

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

Power Shell Learning Commands

Power Shell Learning Commands:-

 

 

dir -RECURSE

`

Start-Transcript filename.txt

 

stop-Transcript

 

I will post to continue this article persistently

 

 

Paddy

 

Thursday, January 22, 2009

SCCM 2007 / SMS 2003 SQL Package Related Query


-----------------------------------------------------------------------------------------------------------------------------------
SQL Query:-->
-----------------------------------------------------------------------------------------------------------------------------------
To know the package Name and ID

SELECT     PackageID, Name
FROM         dbo.v_Package
-----------------------------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------------------------
SQL Query:-->

If you want to filter with the package ID then modify the Query to

SELECT     PackageID, Name
FROM         dbo.v_Package
WHERE     (PackageID = 'YourPKGID')

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


Failed to remove package from SMS / SCCM Retired/ Correpted distrubution point

Failed to remove package from a retired distrubution point

 

Select * from pkgservers where NALpath like '%\\retired DP path\DP$'
Select * from pkgstatus where pkgserver like '%\\retired DP path\DP$'

by runing above two commands verifiy that you have got the correct Correpted DP package ID or not. then if you find it you can safly run the below two commands to delete.


Next delete entries from any of the above tables to the invalid dp share.

Delete from pkgservers where NALpath like '%\\retired DP path\DP$'
Delete from pkgstatus where pkgserver like '%\\retired DP path\DP$'

This will be same for SMS 2003 and SCCM 2007
-------------------
Thanks,
http://sccm07.blogspot.com/

Wednesday, January 21, 2009

OSD error

Current issues which I amruning :)
 
OSD
 
 
 
 

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

SCCM OSD All Log Files

Operating System Deployment Log Files
 
The following table lists and describes the operating system deployment log files.
Log File Name Description
CCMSetup.log Provides information about client-based operating system actions.
CreateTSMedia.log Provides information about task sequence media when it is created. This log is generated on the computer running the Configuration Manager 2007 administrator console.
DriverCatalog.log Provides information about device drivers that have been imported into the driver catalog.
MP_ClientIDManager.log Provides information about the Configuration Manager 2007 management point when it responds to Configuration Manager 2007 client ID requests from boot media or PXE. This log is generated on the Configuration Manager 2007 management point.
MP_DriverManager.log Provides information about the Configuration Manager 2007 management point when it responds to a request from the Auto Apply Driver task sequence action. This log is generated on the Configuration Manager 2007 management point.
MP_Location.log Provides information about the Configuration Manager 2007 management point when it responds to request state store or release state store requests from the state migration point. This log is generated on the Configuration Manager 2007 management point.
Pxecontrol.log Provides information about the PXE Control Manager.
PXEMsi.log Provides information about the PXE service point and is generated when the PXE service point site server has been created.
PXESetup.log Provides information about the PXE service point and is generated when the PXE service point site server has been created.
Setupact.log Setupapi.log Setuperr.log Provide information about Windows Sysprep and setup logs.
SmpIsapi.log Provides information about the state migration point Configuration Manager 2007 client request responses.
Smpmgr.log Provides information about the results of state migration point health checks and configuration changes.
SmpMSI.log Provides information about the state migration point and is generated when the state migration point site server has been created.
Smsprov.log Provides information about the SMS provider.
Smspxe.log Provides information about the Configuration Manager 2007 PXE service point.
SMSSMPSetup.log Provides information about the state migration point and is generated when the state migration point site server has been created.
Smsts.log General location for all operating system deployment and task sequence log events.Log file location:·         If task sequence completes when running in the full operating system with a Configuration Manager 2007 client installed on the computer: <CCM Install Dir>\logs·         If task sequence completes when running in the full operating system with no Configuration Manager 2007 client installed on the computer: %temp%\SMSTSLOG·         If task sequence completes when running in WindowsPE: <largest fixed partition>\SMSTSLOG

Note
<CCM Install Dir> is %windir%\system32\ccm\logs for most Configuration Manager 2007 clients and is <Configuration Manager 2007 installation drive>\SMS_CCM for the Configuration Manager 2007 site server. For 64-bit operating systems, it is %windir%\SysWOW64\ccm\logs.
TaskSequenceProvider.log Provides information about task sequences when they are imported, exported, or edited.
USMT Log loadstate.log Provides information about the User State Migration Tool (USMT) regarding the restore of user state data.
USMT Log scanstate.log Provides information about the USMT regarding the capture of user state data.

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

Tuesday, January 20, 2009

Remote Desktop Cut and Paste does not work

RDP Cut or Copy and Paste does not work

Issue:

When using RDP you may not be able to cut and paste information between your local and remote sessions.

Cause:

The rdpclip.exe processing may not be running on the remote system. Alternatively, the clipboard chain may be incomplete.

Workaround:

Restart the rdpclip.exe process on the remote system.

More Information:
The following article has a good article on Clipboard chaining;

http://blogs.msdn.com/ts/archive/2006/11/16/why-does-my-shared-clipboard-not-work-part-1.aspx


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