SCOM - 如何清除舊資料 ?

USE [OperationsManager]

DECLARE @rowcount int

DECLARE @Err int

DECLARE @GroomingThresholdUTC datetime

SET @GroomingThresholdUTC = getutcdate()

EXEC @Err = dbo.p_DiscoveryDataPurgingByTypedManagedEntity @GroomingThresholdUTC,250, 0

EXEC @Err = dbo.p_DiscoveryDataPurgingByRelationship @GroomingThresholdUTC,250, 0

EXEC @Err = dbo.p_DiscoveryDataPurgingByBaseManagedEntity @GroomingThresholdUTC,250, 0

VMware VM unable to access \\server\J$

Cause

This is a known issue on VMware virtual machines due to VMWare capability of HotPlug/HotAdd 

Resolution

To resolve the issue, we need to implement the steps provided in VMWare article pasted below,

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225 

Check the default data set retention date setting in DW.

USE OperationsManagerDW

SELECT DataSetDefaultName,
AggregationTypeId,
MaxDataAgeDays
FROM StandardDatasetAggregation sda
INNER JOIN dataset ds on ds.datasetid = sda.datasetid
ORDER BY DataSetDefaultName

How to Add, Enable, and Disable Namespaces

https://technet.microsoft.com/en-us/library/hh544004.aspx

Active Directory Managmenet Pack possible errors

The problem is that the AD Attribute “fSMORoleOwner” for the infrastructureMaster is set to an Old DC.

-------fixfsmo.vbs------------------
const ADS_NAME_INITTYPE_GC = 3
const ADS_NAME_TYPE_1779 = 1
const ADS_NAME_TYPE_CANONICAL = 2

set inArgs = WScript.Arguments

if (inArgs.Count = 1) then
    ' Assume the command line argument is the NDNC (in DN form) to use.
    NdncDN = inArgs(0)
Else
    Wscript.StdOut.Write "usage: cscript fixfsmo.vbs NdncDN"
End if

if (NdncDN <> "") then

    ' Convert the DN form of the NDNC into DNS dotted form.
    Set objTranslator = CreateObject("NameTranslate")
    objTranslator.Init ADS_NAME_INITTYPE_GC, ""
    objTranslator.Set ADS_NAME_TYPE_1779, NdncDN
    strDomainDNS = objTranslator.Get(ADS_NAME_TYPE_CANONICAL)
    strDomainDNS = Left(strDomainDNS, len(strDomainDNS)-1)
     
    Wscript.Echo "DNS name: " & strDomainDNS

    ' Find a domain controller that hosts this NDNC and that is online.
    set objRootDSE = GetObject("LDAP://" & strDomainDNS & "/RootDSE")
    strDnsHostName = objRootDSE.Get("dnsHostName")
    strDsServiceName = objRootDSE.Get("dsServiceName")
    Wscript.Echo "Using DC " & strDnsHostName

    ' Get the current infrastructure fsmo.
    strInfraDN = "CN=Infrastructure," & NdncDN
    set objInfra = GetObject("LDAP://" & strInfraDN)
    Wscript.Echo "infra fsmo is " & objInfra.fsmoroleowner

    ' If the current fsmo holder is deleted, set the fsmo holder to this domain controller.

    if (InStr(objInfra.fsmoroleowner, "\0ADEL:") > 0) then

        ' Set the fsmo holder to this domain controller.
        objInfra.Put "fSMORoleOwner",  strDsServiceName
        objInfra.SetInfo

        ' Read the fsmo holder back.
        set objInfra = GetObject("LDAP://" & strInfraDN)
        Wscript.Echo "infra fsmo changed to:" & objInfra.fsmoroleowner

    End if

End if

Copy this VB Script into a file and execute this with the following parameter.

• cscript fixfsmo.vbs DC=DomainDnsZones,DC=contoso,DC=com
• cscript fixfsmo.vbs DC=ForestDnsZones,DC=contoso,DC=com

SCCM versions

	RTM	CU1	CU2	CU3	CU4	CU5
CM07 SP2	4.0.6487.2000
CM12 RTM	5.0.7711.0000	5.0.7711.0200	5.0.7711.301
CM12 SP1	5.0.7804.1000	5.0.7804.1202	5.0.7804.1300	5.0.7804.1400	5.0.7804.1500	5.0.7804.1600
CM12 R2	5.0.7958.1000	5.0.7958.1203	5.0.7958.1303	5.0.7958.1401	5.0.7958.1501	5.0.7958.1604
CM12 SP2/R2 SP1	5.0.8239.1000	5.0.8239.1203
CM16
CU KBs
CM12 RTM		KB2717295	KB2780664
CM12 SP1		KB2817245	KB2854009	KB2882125	KB2922875	KB2978017
CM12 R2		KB2938441	KB2970177	KB2994331	KB3026739	KB3054451
CM12 SP2/R2 SP1		KB3074857

SQL Server 2008 R2 SP2升級到SP3 失敗

[請您參考以下的說明]   

1.       現階段暫時使用其他具有管理員權限的帳號登入後，已經可以正常安裝相關更新。

2.       針對Kerberos Token大小的問題建議可以透過底下方式將大小調整成48000以減少此類問題發生。

步驟：

1)      打開regedit.exe

2)      找到HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Lsa\Kerberos\Parameters , 並在右邊新增一個DWORD值 , 命名為 MaxTokenSize , 並設定其值為48000 (十進位)。

3)      設定完成後重新開機讓該值生效即可