ConfigMgr 2007

13 March 2009

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/

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.

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

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

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

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

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/

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

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

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