Script ile SMS/SCCM Advanced Client'in Machine Policy yi cekip uygulamasini saglamak

Asagidaki ornek script araciligi ile SMS/SCCM Advanced Client yuklu istemcinizin sunucunuzdan son machine policy i cekip , uygulamasini saglayabilirsiniz, ozellikle testlerinizde isinizi hizlandirmak icin cok faydali olacagini saniyorum.



On Error Resume Next

Dim objCPAppletMgr
Dim objClientActions
Dim objClientAction
Dim strActionName

strActionName="Request & Evaluate Machine Policy"

'Get the Control Panel applet manager object
set objCPAppletMgr = CreateObject("CPApplet.CPAppletMgr")

'Get a collection of client actions

set objClientActions=objCPAppletMgr.GetClientActions

'Loop through the available client actions

For Each objClientAction In objClientActions

If objClientAction.Name = strActionName Then
objClientAction.PerformAction
WScript.Echo "Action " + objClientAction.Name + " initiated"
End If
Next

If you have a server with multiple NICs and if it is consisting to register it's IP address to DNS server even while you uncheck the "register this connection's addresses in DNS" option, I recommend you to create the registry entry below

Create a DWORD named  DisableDynamicUpdate under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters and assign value 1 .



Or you can run the command below to easily create the record.

reg add HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters /v DisableDynamicUpdate /t REG_DWORD /d 1 /f

Normally this method shown for 2000 and 2003 servers in MS pages, but it is also working for 2008.

Sunucunun IP adresini DNS'e kayit etmesini engellemek

Bir den fazla network kartina sahiop bir sunucunuz var ise, ve siz DNS sunucusuna kayit etme secenegini sectiginiz halde halen kartlardan biri DNS de ikinci,.. kayit aciyor ise asagidaki regsitry kaydini eklemenizi tavsiye ederim,
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters altinda  DisableDynamicUpdate DWORD u olusturun ve 1 degerini atayin, yada asagidaki komutu calistirabilirsiniz kolayce eklemek icin.

reg add HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters /v DisableDynamicUpdate /t REG_DWORD /d 1 /f

Bu yontemin Windows 2000, 2003 de calistigi belirtilmis MS sayfalarinda, ancak 2008'de de calismakta.

Changing collation of Virtual Center Database

I needed to change VMWare ESX's Virtual Center 2 Database collation while moving the DB to another MS SQL server using different collation, you might not need to change VC2 DB collation but I think it is better to use default server collation. As usual for most databases I got the error below; because of an object dependent on database collation.

• Alter failed for Database 'VirtualCenter2'.  (Microsoft.SqlServer.Smo)


• An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


• The object 'sys_PhysicalIndexStatistics_Wrapper' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.


• ALTER DATABASE failed. The default collation of database 'VirtualCenter2' cannot be set to SQL_Latin1_General_CP1_CI_AS. (.Net SqlClient Data Provider) (Microsoft SQL Server, Error: 5075)

You can easily deal with this issue by using the steps below.

1. After restoring the DB on target server , browse to VC2 DB\Programmability\Functions\Table-valued Functions, right click on sys_PhysicalIndexStatistics_Wrapper then select Script Function As > Create To > New Query Editor, it will create the query needed to re-create the  sys_PhysicalIndexStatistics_Wrapper object.


2. Delete sys_PhysicalIndexStatistics_Wrapper


3. Change collation of the database.


4. Run the query you have created on step 1. , check if sys_PhysicalIndexStatistics_Wrapper created successfully.

Virtual Center Veritabaninin Collation degerini degistirmek.

Az once VMWare ESX in Virtual Center 2 Database ini fakli collation'a sahip bir SQL sunucusuna tasirken, ne olur ne olmaz belki bir uyumluluk sorunu cikartir diye veritabaninin Collation'i ni Latin1_General_CP1_CI_AS 'den SQL_Latin1_General_CP1_CI_AS 'e cevirmem gerekti fakat cogu veritabaninda karsilasilmasi dogal olan hatalardan birini aldim

• Alter failed for Database 'VirtualCenter2'.  (Microsoft.SqlServer.Smo)
• An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
• The object 'sys_PhysicalIndexStatistics_Wrapper' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation.
• ALTER DATABASE failed. The default collation of database 'VirtualCenter2' cannot be set to SQL_Latin1_General_CP1_CI_AS. (.Net SqlClient Data Provider) (Microsoft SQL Server, Error: 5075)

Bu hatayi sizde asmak isterseniz asagidaki basit adimlardan faydalanabilirsiniz. (4 adim)

1. Database i hedef SQL sunucusuna restore ettikten sonra, DB\Programmability\Functions\Table-valued Functions altindaki sys_PhysicalIndexStatistics_Wrapper'a sag tusla basip Script Function As > Create To > New Query Editor u secin, sys_PhysicalIndexStatistics_Wrapper i yaratmak icin gerekli Query i boylece yedege almis olacaksiniz.
2. sys_PhysicalIndexStatistics_Wrapper objesini silin
3. Database collation i degistirin
4. 1. adimda acmis oldugunuz Query'i calistirin, sys_PhysicalIndexStatistics_Wrapper in yeniden yaratilmis oldugunu teyit edin.

WSUS 3.0 sunucunuzun senkronizasyonun script ile baslatilmasi

Merhaba asagida WSUS Team'in yayimladigi ornek scripti kullanarak WSUS 3.0 sunucunuzun senkronizasyona baslamasini saglayabilirsiniz.

Script de ki GetUpdateServer() call kismini GetUpdateServer(,true|false) seklinde degistirip icinde sunucuadi yazan kisma kendi uzak WSUS sunucunuzun adini yazabilirsiniz, eger SSL baglantisi ile haberlesiyorsaniz , parametreyi true , SSL kullanmadan baglaniyorsaniz false birakmaniz yeterli olacaktir.

[reflection.assembly]::LoadWithPartialName("Microsoft.UpdateServices.Administration") | out-null
$wsus = [Microsoft.UpdateServices.Administration.AdminProxy]::GetUpdateServer();
$wsus.GetSubscription().StartSynchronization();

uzak WSUS sunucunuz icin degistirilmis haline ornek ise.

[reflection.assembly]::LoadWithPartialName("Microsoft.UpdateServices.Administration") | out-null
$wsus = [Microsoft.UpdateServices.Administration.AdminProxy]::GetUpdateServer(WSUSSunucunuz,false);
$wsus.GetSubscription().StartSynchronization();

WSUS Team in cok yararli olacagini dusundugum Blog Sitesi.

Unattended.txt (GuiUnttended) TimeZone Endeksi

Asagida Unattended.txt dosyasini duzenlerken TimeZone degeri vermek icin ihtiyac duyabileceginiz TimeZone index ini bulabilirsiniz arkadaslar, GUIUnattended bolumu altinda bulunan TimeZone icin degeri TimeZone=130 (Istanbul icin) seklinde verebilirsiniz.

Index	Time Zone	Description
000	Dateline Standard Time	(GMT-12:00) International Date Line West
001	Samoa Standard Time	(GMT-11:00) Midway Island, Samoa
002	Hawaiian Standard Time	(GMT-10:00) Hawaii
003	Alaskan Standard Time	(GMT-09:00) Alaska
004	Pacific Standard Time	(GMT-08:00) Pacific Time (US and Canada); Tijuana
010	Mountain Standard Time	(GMT-07:00) Mountain Time (US and Canada)
013	Mexico Standard Time 2	(GMT-07:00) Chihuahua, La Paz, Mazatlan
015	U.S. Mountain Standard Time	(GMT-07:00) Arizona
020	Central Standard Time	(GMT-06:00) Central Time (US and Canada)
025	Canada Central Standard Time	(GMT-06:00) Saskatchewan
030	Mexico Standard Time	(GMT-06:00) Guadalajara, Mexico City, Monterrey
033	Central America Standard Time	(GMT-06:00) Central America
035	Eastern Standard Time	(GMT-05:00) Eastern Time (US and Canada)
040	U.S. Eastern Standard Time	(GMT-05:00) Indiana (East)
045	S.A. Pacific Standard Time	(GMT-05:00) Bogota, Lima, Quito
050	Atlantic Standard Time	(GMT-04:00) Atlantic Time (Canada)
055	S.A. Western Standard Time	(GMT-04:00) Caracas, La Paz
056	Pacific S.A. Standard Time	(GMT-04:00) Santiago
060	Newfoundland and Labrador Standard Time	(GMT-03:30) Newfoundland and Labrador
065	E. South America Standard Time	(GMT-03:00) Brasilia
070	S.A. Eastern Standard Time	(GMT-03:00) Buenos Aires, Georgetown
073	Greenland Standard Time	(GMT-03:00) Greenland
075	Mid-Atlantic Standard Time	(GMT-02:00) Mid-Atlantic
080	Azores Standard Time	(GMT-01:00) Azores
083	Cape Verde Standard Time	(GMT-01:00) Cape Verde Islands
085	GMT Standard Time	(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London
090	Greenwich Standard Time	(GMT) Casablanca, Monrovia
095	Central Europe Standard Time	(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
100	Central European Standard Time	(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb
105	Romance Standard Time	(GMT+01:00) Brussels, Copenhagen, Madrid, Paris
110	W. Europe Standard Time	(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
113	W. Central Africa Standard Time	(GMT+01:00) West Central Africa
115	E. Europe Standard Time	(GMT+02:00) Bucharest
120	Egypt Standard Time	(GMT+02:00) Cairo
125	FLE Standard Time	(GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius
130	GTB Standard Time	(GMT+02:00) Athens, Istanbul, Minsk
135	Israel Standard Time	(GMT+02:00) Jerusalem
140	South Africa Standard Time	(GMT+02:00) Harare, Pretoria
145	Russian Standard Time	(GMT+03:00) Moscow, St. Petersburg, Volgograd
150	Arab Standard Time	(GMT+03:00) Kuwait, Riyadh
155	E. Africa Standard Time	(GMT+03:00) Nairobi
158	Arabic Standard Time	(GMT+03:00) Baghdad
160	Iran Standard Time	(GMT+03:30) Tehran
165	Arabian Standard Time	(GMT+04:00) Abu Dhabi, Muscat
170	Caucasus Standard Time	(GMT+04:00) Baku, Tbilisi, Yerevan
175	Transitional Islamic State of Afghanistan Std.	(GMT+04:30) Kabul
180	Ekaterinburg Standard Time	(GMT+05:00) Ekaterinburg
185	West Asia Standard Time	(GMT+05:00) Islamabad, Karachi, Tashkent
190	India Standard Time	(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi
193	Nepal Standard Time	(GMT+05:45) Kathmandu
195	Central Asia Standard Time	(GMT+06:00) Astana, Dhaka
200	Sri Lanka Standard Time	(GMT+06:00) Sri Jayawardenepura
201	N. Central Asia Standard Time	(GMT+06:00) Almaty, Novosibirsk
203	Myanmar Standard Time	(GMT+06:30) Yangon (Rangoon)
205	S.E. Asia Standard Time	(GMT+07:00) Bangkok, Hanoi, Jakarta
207	North Asia Standard Time	(GMT+07:00) Krasnoyarsk
210	China Standard Time	(GMT+08:00) Beijing, Chongqing, Hong Kong SAR, Urumqi
215	Singapore Standard Time	(GMT+08:00) Kuala Lumpur, Singapore
220	Taipei Standard Time	(GMT+08:00) Taipei
225	W. Australia Standard Time	(GMT+08:00) Perth
227	North Asia East Standard Time	(GMT+08:00) Irkutsk, Ulaan Bataar
230	Korea Standard Time	(GMT+09:00) Seoul
235	Tokyo Standard Time	(GMT+09:00) Osaka, Sapporo, Tokyo
240	Yakutsk Standard Time	(GMT+09:00) Yakutsk
245	A.U.S. Central Standard Time	(GMT+09:30) Darwin
250	Cen. Australia Standard Time	(GMT+09:30) Adelaide
255	A.U.S. Eastern Standard Time	(GMT+10:00) Canberra, Melbourne, Sydney
260	E. Australia Standard Time	(GMT+10:00) Brisbane
265	Tasmania Standard Time	(GMT+10:00) Hobart
270	Vladivostok Standard Time	(GMT+10:00) Vladivostok
275	West Pacific Standard Time	(GMT+10:00) Guam, Port Moresby
280	Central Pacific Standard Time	(GMT+11:00) Magadan, Solomon Islands, New Caledonia
285	Fiji Islands Standard Time	(GMT+12:00) Fiji Islands, Kamchatka, Marshall Islands
290	New Zealand Standard Time	(GMT+12:00) Auckland, Wellington
300	Tonga Standard Time	(GMT+13:00) Nuku'alofa