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.

Download

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

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

 

You can download it from http://www.rtsecurity.com/rshut_cnet.zip

 

 

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

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

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/