問題描述︰

針對網路卡的IP subnet以排除方式達到針對特定的subnet 排除在collection之外

使用以下可以排除某個IPSubnets 例如 "10.10.30.0"

select *  from  SMS_R_System where IPSubnets != "10.10.30.0"

但是若是有兩張網卡的例如另外一張是 192.168.0.0的網段仍會被query出來

也就是同一比電腦帳號有兩張網卡只要其中一張有符合條件就會被query出來

使用語法

select *  from  SMS_R_System where IPSubnets != "10.10.30.0" and IPSubnets != "192.168.0.0"

可以達到需求，但是要增加更多的sunbet進來時就會有問題

解決方法︰

透過SQL語法可解決排除collection中多個IPSubnet問題

SELECT *

FROM  SMS_R_SYSTEM

WHERE IPSUBNETS NOT IN ('10.69.5.0','10.10.0.0','10.69.0.0',

'10.10.30.0','10.10.33.0','10.11.70.0',

'10.8.30.0','10.8.31.0','10.8.40.0',

'10.8.50.0','10.8.60.0','10.8.61.0',

'192.168.0.0')

1. On the agent computer, stop the MOM service.

2. Start Registry Editor (Regedt32), and then locate the HKEY_LOCAL_MACHINE\SOFTWARE\Mission Critical Software\OnePoint\ key. Write down the directory paths for the following three registry values:

o DataDir

o MSInstallSubDir

o TempDir

1. Delete the following registry keys if they are present:

HKEY_LOCAL_MACHINE\SOFTWARE\Mission Critical Software\OnePoint
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OnePoint

2. Delete the following registry value if it is present:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SNMP\Parameters\ExtensionAgents\MCSExtnAgent

This key may contain Software\Mission Critical Software\OnePoint\SNMP. If you do not delete this value, you cannot delete the SNMPExtnAgent.dll file in the folder that is listed in the MSInstallSubDir registry value.
IMPORTANT: Deleting these registry values disables any NetIQ administration products that are installed. You will need to reinstall the NetIQ products.

3. Quit Registry Editor.

4. Restart SNMP service.

5. In Windows Explorer, locate and delete the three folders where the program was installed, if those folders are present. (Refer to the paths that you wrote down in Step 3.) However, do not delete the folder that is listed in the TempDir registry value; rather, delete the Mission Critical Software folder in this Temp directory.

1. Please download the Cleanmom utility from the Microsoft Download Center.
http://www.microsoft.com/downloads/en/details.aspx?familyid=14FF7073-C71B-4AD0-805A-A8E458D2C9E0&displaylang=en

2.unzip OpsMgrCleanup.zip

3. Based on the architecture of the machine you will have to use either CleanMom.exe or CleanMom64.exe respectively.
The command should look like this:

CleanMom.exe /CleanAgents

正常清除已經不存在網域中的DC紀錄.可以採用 KB 216498 文章提到採用ntdsutil 一步步的進入並選擇要清除的DC.

不過您也可以採用一行指令.來清除DC紀錄.詳細說明請見參考資訊

使用ntdsutil 指令清除NTDS不存在DC紀錄:

ntdsutil "m c" "r s s CN=DCName,CN=SERVERS,CN=SiteName,CN=sites,CN=configuration,dc=Contoso,dc=com" q q

dsrm "CN=DCName,CN=SERVERS,CN=SiteName,CN=sites,CN=configuration,dc=Contoso,dc=com " -noprompt –q

參考資訊

How to remove data in Active Directory after an unsuccessful domain controller demotion
http://support.microsoft.com/default.aspx?scid=KB;EN-US;216498

Active Directory 目錄服務維護公用程式 (ntdsutil.exe)  http://technet.microsoft.com/zh-tw/library/cc758526(WS.10).aspx

正常來講，非admin的使用者在Windows XP系統下，插入隨身碟後仍可以正常使用。如果當您發現一般使用者插入隨身碟後，系統畫面跑出需要安裝驅動程式而且安裝失敗(但是具有admin權限的帳戶就沒有這個問題)，該如何排除這個問題?以下提供幾個方向，可以依照方式一往下做，如果問題解決，就不需再往下處理。

方法一：

1.將Cryptographic Services停用。

2.將C:\Windows\system32\Catroot2資料夾刪除或是將它命名成其他的名稱。

3.啟用Cryptographic Services服務，再試一次。

方式二：

檢查以下的三個檔案，權限是否和正常機器的不一樣。如果不一樣的話，請修改其權限，再試一次

C:\Windows\system32\drivers\usbstor.sys

C:\Windows\inf\usbstor.inf

C:\Windows\inf\usbstor.pnf

方式三：

執行以下的指令，讓系統檔案的權限還原預設值

secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb /verbose (參考http://support.microsoft.com/kb/313222)

方式四：

再安裝一次Windows XP Service Pack3，以及後面的Hotfix。

方式五:

 檢查以下的三個機碼，在右方找到是否有LowerFilters或是UpperFilter的值，值的內容和正常的機器是否不一樣，如果有不一樣的地方，請刪除或是修改，再重新開機試一次。

HKLM\SYSTEM\CurrentControlSet\Control\Class\{4D36E965-E325-11CE-BFC1-08002BE10318}
HKLM\SYSTEM\CurrentControlSet\Control\Class\{4D36E967-E325-11CE-BFC1-08002BE10318}
HKLM\SYSTEM\CurrentControlSet\Control\Class\{6D807884-7D21-11CF-801C-08002BE10318}

(在做任何修改前，請先備份機碼)