匯出AD 上Account's mail address

1.Active Directory Users and Computers的檢視, 新增"電子郵件地址"的欄位, 再選擇Users右鍵"匯出清單"即可.

2.命令列的方式可在DC上用下列指令。
csvde -r "(&(objectClass=user)(objectCategory=person))" -l "mail, name, userprincipalname" -f users1.csv

ps.
http://support.microsoft.com/kb/555636/zh-tw

WSUS can't reinstall

上網爬文並實証，確實解決了wsus無法重灌的問題。
方法如下:

1. Please download and install the Windows Installer Cleanup Utility. To install it simply run msicuu2.exe.

2. Once it is installed go to Start>All Programs>Windows Install Clean Up

3. Scroll through the options and highlight Microsoft Windows Server Update Services 3.0 SP1 (3.1.6001.65)



4. Click remove

5. Open a command prompt and run the following commands:

net stop wsusservice

net stop wsuscertserver

sc delete wsusservice

sc delete wsuscertserver

6. When complete, go back to the Windows Installer Cleanup Utility and highlight Windows Internal Database (MICROSOFT##SSEE) and click remove.

7. Go back to the command line and run the following commands

net stop mssql$microsoft##ssee

sc delete mssql$microsoft##ssee

8. Delete or edit the associated reg keys as noted below:

a. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server and edit the "InstalledInstances" value and remove "MICROSOFT##SSEE"

b. Remove the "MICROSOFT##SSEE" subkey under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

c. Remove the "MSSQL.2005" subkey under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

d. Rename the following folder:

\%Windir%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data

to

\%Windir%\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data.old

At the completion of this you should be at a point where you can reinstall WSUS from scratch if you like.

ARCserver DB不明原因停止

在做 VLDB 作掃描、修復、重整的動作後，這兩天似乎不再發作了。觀察ing....
指令如下 :

cd program files\ca\BrightStor ARCserve Backup\
rem This will check all of the databases for errors
dbcheck -a -L casdb;admin;secret asjob
dbcheck -a -L casdb;admin;secret asmedia
dbcheck -a -L casdb;admin;secret asobject
dbcheck -a -L casdb;admin;secret asrhost
dbcheck -a -L casdb;admin;secret astape
dbcheck -a -L casdb;admin;secret astpdrv
dbcheck -a -L casdb;admin;secret astpsdat
rem This section will repair each database as needed
dbfix -a -L casdb;admin;secret asjob
dbfix -a -L casdb;admin;secret asmedia
dbfix -a -L casdb;admin;secret asobject
dbfix -a -L casdb;admin;secret asrhost
dbfix -a -L casdb;admin;secret astape
dbfix -a -L casdb;admin;secret astpdrv
dbfix -a -L casdb;admin;secret astpsdat
rem This section will remove deleted records from the database
dbdefrag -a -L casdb;admin;secret asjob
dbdefrag -a -L casdb;admin;secret asmedia
dbdefrag -a -L casdb;admin;secret asobject
dbdefrag -a -L casdb;admin;secret asrhost
dbdefrag -a -L casdb;admin;secret astape
dbdefrag -a -L casdb;admin;secret astpdrv
dbdefrag -a -L casdb;admin;secret astpsdat
rem This section will repair high-level key problems, and should only be run in
conjunction DBDEFRAG.
keybuild -k -L casdb;admin;secret asjob
keybuild -k -L casdb;admin;secret asmedia
keybuild -k -L casdb;admin;secret asobject
keybuild -k -L casdb;admin;secret asrhost
keybuild -k -L casdb;admin;secret astape
keybuild -k -L casdb;admin;secret astpdrv
keybuild -k -L casdb;admin;secret astpsdat

我的資料匣不見了

資料匣莫名其妙的，就在檔案總管中不見了。
但在網址列中，直接鍵入資料匣路徑，又可以進入該資料匣。

cmd>> dir /a:h Folder path
果然發現，資料匣被改為隱藏屬性的。

透過cmd>> attrib -h +s
將屬性修正後，又可以在檔案總管中看到該資料匣囉。