USE SUSDB ;
GO
EXEC sp_configure 'remote query timeout', 0 ;
GO
RECONFIGURE ;
GO

���� ��

#WSUS

USE SUSDB; 
GO 
SET NOCOUNT ON;

-- Rebuild or reorganize indexes based on their fragmentation levels 
DECLARE @work_to_do TABLE ( 
    objectid int 
    , indexid int 
    , pagedensity float 
    , fragmentation float 
    , numrows int 
) 

DECLARE @objectid int; 
DECLARE @indexid int; 
DECLARE @schemaname nvarchar(130);  
DECLARE @objectname nvarchar(130);  
DECLARE @indexname nvarchar(130);  
DECLARE @numrows int 
DECLARE @density float; 
DECLARE @fragmentation float; 
DECLARE @command nvarchar(4000);  
DECLARE @fillfactorset bit 
DECLARE @numpages int 
 
-- Select indexes that need to be defragmented based on the following 
-- * Page density is low 
-- * External fragmentation is high in relation to index size 
PRINT 'Estimating fragmentation: Begin. ' + convert(nvarchar, getdate(), 121)  
INSERT @work_to_do 
SELECT 
    f.object_id 
    , index_id 
    , avg_page_space_used_in_percent 
    , avg_fragmentation_in_percent 
    , record_count 
FROM  
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'SAMPLED') AS f 
WHERE 
    (f.avg_page_space_used_in_percent   < 85.0 and f.avg_page_space_used_in_percent/100.0 * page_count   < page_count - 1) 
    or (f.page_count > 50 and f.avg_fragmentation_in_percent > 15.0) 
    or (f.page_count > 10 and f.avg_fragmentation_in_percent > 80.0) 

PRINT 'Number of indexes to rebuild: ' + cast(@@ROWCOUNT as nvarchar(20)) 

PRINT 'Estimating fragmentation: End. ' + convert(nvarchar, getdate(), 121) 

SELECT @numpages = sum(ps.used_page_count) 
FROM 
    @work_to_do AS fi 
    INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id 
    INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id 

-- Declare the cursor for the list of indexes to be processed. 
DECLARE curIndexes CURSOR FOR SELECT * FROM @work_to_do 

-- Open the cursor. 
OPEN curIndexes 

-- Loop through the indexes 
WHILE (1=1) 
BEGIN 
    FETCH NEXT FROM curIndexes 
    INTO @objectid, @indexid, @density, @fragmentation, @numrows; 
    IF @@FETCH_STATUS   < 0 BREAK; 

    SELECT  
        @objectname = QUOTENAME(o.name) 
        , @schemaname = QUOTENAME(s.name) 
    FROM  
        sys.objects AS o 
        INNER JOIN sys.schemas as s ON s.schema_id = o.schema_id 
    WHERE  
        o.object_id = @objectid; 

    SELECT  
        @indexname = QUOTENAME(name) 
        , @fillfactorset = CASE fill_factor WHEN 0 THEN 0 ELSE 1 END 
    FROM  
        sys.indexes 
    WHERE 
        object_id = @objectid AND index_id = @indexid; 

    IF ((@density BETWEEN 75.0 AND 85.0) AND @fillfactorset = 1) OR (@fragmentation   < 30.0) 
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REORGANIZE'; 
    ELSE IF @numrows >= 5000 AND @fillfactorset = 0 
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD WITH (FILLFACTOR = 90)'; 
    ELSE 
        SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD'; 
    PRINT convert(nvarchar, getdate(), 121) + N' Executing: ' + @command; 
    EXEC (@command); 
    PRINT convert(nvarchar, getdate(), 121) + N' Done.'; 
END 

-- Close and deallocate the cursor. 
CLOSE curIndexes; 
DEALLOCATE curIndexes; 

IF EXISTS (SELECT * FROM @work_to_do) 
BEGIN 
    PRINT 'Estimated number of pages in fragmented indexes: ' + cast(@numpages as nvarchar(20)) 
    SELECT @numpages = @numpages - sum(ps.used_page_count) 
    FROM 
        @work_to_do AS fi 
        INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and fi.indexid = i.index_id 
        INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id = ps.object_id and i.index_id = ps.index_id 
    PRINT 'Estimated number of pages freed: ' + cast(@numpages as nvarchar(20)) 
END 
GO 

-- �Զ���б� ��������

-- Windows 8.1 �� PC �������
UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 8.1'
WHERE [OSMajorVersion] = '6'
AND [OSMinorVersion] = '3'
AND [OldProductType] = '1'
AND ([OSDescription]   <> 'Windows 8.1' or [OSDescription] IS NULL) 

-- Windows Server 2012 R2 �� PC �������
UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows Server 2012 R2'
WHERE [OSMajorVersion] = '6'
AND [OSMinorVersion] = '3'
AND [OldProductType]   <> '1'
AND ([OSDescription]   <> 'Windows Server 2012 R2' or [OSDescription] IS NULL) 

-- Windows 10 �� PC �������
UPDATE [SUSDB].[dbo].[tbComputerTargetDetail] 
SET [OSDescription] = 'Windows 10' 
WHERE [OSMajorVersion] = '10' 
AND [OSMinorVersion] = '0' 
AND [OldProductType] = '1' 
AND ([OSDescription]   <> 'Windows 10' or [OSDescription] IS NULL)
-- �Զ���б� �����ޤ� --


--Update all statistics 
PRINT 'Updating all statistics.' + convert(nvarchar, getdate(), 121)  
EXEC sp_updatestats 
PRINT 'Done updating statistics.' + convert(nvarchar, getdate(), 121)  
GO 

���� ��

#WSUS

use SUSDB;
GO

DECLARE @var1 INT
DECLARE @msg nvarchar(100)

-- spGetObsoleteUpdatesToCleanup �η�̤����ơ��֥� #results �˳�Ǽ
CREATE TABLE #results(Col1 INT)
INSERT INTO #results(Col1) EXEC spGetObsoleteUpdatesToCleanup

DECLARE WC Cursor FOR
    SELECT Col1 FROM #results
	
OPEN WC
FETCH NEXT FROM WC
INTO @var1

WHILE(@@FETCH_STATUS > -1)
BEGIN
    SET @msg = 'Deleting ' + CONVERT(varchar(10), @var1)
    RAISERROR(@msg, 0, 1) WITH NOWAIT EXEC spDeleteUpdate @localUpdateID=@var1
    FETCH NEXT FROM WC
    INTO @var1
END

CLOSE WC

DEALLOCATE WC

DROP TABLE #results

[reflection.assembly]::LoadWithPartialName("Microsoft.UpdateServices.Administration")` 
 | out-null 
$wsus = [Microsoft.UpdateServices.Administration.AdminProxy]::GetUpdateServer(); 
$cleanupScope = new-object Microsoft.UpdateServices.Administration.CleanupScope; 
$cleanupScope.DeclineSupersededUpdates = $true        
$cleanupScope.DeclineExpiredUpdates         = $true 
$cleanupScope.CleanupObsoleteUpdates     = $true 
$cleanupScope.CompressUpdates                  = $true 
#$cleanupScope.CleanupObsoleteComputers = $true 
$cleanupScope.CleanupUnneededContentFiles = $true 
$cleanupManager = $wsus.GetCleanupManager(); 
$cleanupManager.PerformCleanup($cleanupScope);

���� ��

#WSUS

���� ��

#WSUS

• ���ݡ��Ⱦ��� : Windows Server Update Services 3.0 Service Pack 2 �Ѥι����ץ������ˤĤ��� (KB2720211) �ʥ���������� ���󥿡���


• ���ݡ��Ⱦ��� : An update for Windows Server Update Services 3.0 Service Pack 2 is available (KB2734608) �ʥ���������� ���󥿡���


• ���ݡ��Ⱦ��� : Windows Server Update Services 3.0 SP2 �Ѥι����ץ�����ब���Ѳ�ǽ (KB2828185) �ʥ���������� ���󥿡���


• ���ݡ��Ⱦ��� : An update to harden Windows Server Update Services (KB2938066) �ʥ���������� ���󥿡���

UPDATE [SUSDB].[dbo].[tbComputerTargetDetail]
SET [OSDescription] = 'Windows 10'
WHERE [OSMajorVersion] = '10'
AND [OSMinorVersion] = '0'
AND [OldProductType] = '1'
AND ([OSDescription] <> 'Windows 10' or [OSDescription] IS NULL)

1. SQL Server �إ������󤹤롣

2. [������������] ����Υ����ɤ�Ž���դ��¹Ԥ��롣

���� ��

#WSUS

1�ĤΥץ�����ब�Ĥ����Ƥ��ޤ���
----------------------------------------------------
(�Ե���) Windows Update
���Υץ������ˤ�ꡢ����åȥ�����Ǥ��ޤ���
----------------------------------------------------
[��������åȥ�����] [����󥻥�]

• Microsoft OneDrive for Business (KB3054825) 32�ӥå��Ǥι����ץ������
• Microsoft Visio 2013 (KB3039729) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3054774) 32�ӥå��Ǥι����ץ������
• Microsoft Word 2013 (KB3039755) 32�ӥå��Ǥι����ץ������
• Windows 8.1 for x64-Based System �ѥ������ƥ������ץ������ (KB3062760)
• Windows 8.1 for x64-Based System �ѥ������ƥ������ץ������ (KB3057839)
• Windows 81. for x64-Based System �� Internet Explorer 11 ������Ū�ʥ������ƥ������ץ������ (KB3058515)
• Microsoft Office 2013 (KB3054856) 32�ӥå��Ǥι����ץ������
• Microsoft Excel 2013 (KB3054794) 32�ӥå��Ǥι����ץ������
• Microsoft Project 2013 (KB3054830) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3054797) 32�ӥå��Ǥι����ץ������
• Windows 8.1 for x64-Based System �ѥ������ƥ������ץ������ (KB3059317)
• Microsoft Office 2013 (KB3039791) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB2889863) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3039749) 32�ӥå��Ǥι����ץ������
• Skype for Business 2015 (KB3054791) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3054786) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3023054) 32�ӥå��Ǥι����ץ������
• Windows 8.1 for x64-Based System �� Internet Explorer Flash Player �Υ������ƥ������ץ������ (KB3065820)
• Microsoft Outlook Social Connector 2013 (KB3054854) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3054853) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3039782) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3054855) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3054783) 32�ӥå��Ǥι����ץ������
• Microsoft OneNote 2013 (KB3039764) 32�ӥå��Ǥι����ץ������
• Microsoft Office 2013 (KB3039761) 32�ӥå��Ǥι����ץ������
• Microsoft Access 2013 (KB3054795) 32�ӥå��Ǥι����ץ������
• Microsoft PowerPoint 2013 (KB3023058) 32�ӥå��Ǥι����ץ������
• Microsoft PowerPoint 2013 (KB3023058) 32�ӥå��Ǥι����ץ������
• Microsoft Access 2013 (KB3054795) 32�ӥå��Ǥι����ץ������