-- Abfrage an die WSUS Datenbank um eine Übersicht
-- des Patchstatus aller PCs zu bekommen
-- September 2008 - Wolfgang Führer
 
SELECT 
T.TargetID,
T.FullDomainName,
M.Downloaded,
M.Failed,
M.InstalledPendingReboot,
T.IPAddress,
M.Installed,
M.NotInstalled,
M.Unknown,
T.LastSyncTime,
M.LastChangeTime
FROM 
tbComputerTarget T, tbComputerSummaryForMicrosoftUpdates M 
WHERE 
T.TargetID = M.TargetID
ORDER BY 
T.FullDomainName

/*
** ------------------------------
** database audit script SQL 2005
** job 
** mar 2005 - Wolfgang Führer
** ------------------------------
*/
 
USE [msdb]
GO
 
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
 
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @TYPE=N'LOCAL', @name=N'[Uncategorized (Local)]'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
 
END
 
DECLARE @jobId BINARY(16)

/*
** ------------------------------
** database audit script SQL 2000
** job 
** mar 2005 - Wolfgang Führer
** ------------------------------
*/
 
 
--------------------------------
-- create daily job for audit --
--------------------------------
 
BEGIN TRANSACTION            
  DECLARE @JobID BINARY(16)  
  DECLARE @ReturnCode INT    
  SELECT @ReturnCode = 0     
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'Database Maintenance') < 1 
  EXECUTE msdb.dbo.sp_add_category @name = N'Database Maintenance'

/*
** ----------------------------
** database audit script
** mar 2005 - Wolfgang Führer
** ----------------------------
*/
 
-------------------------------------
-- make Audit folder for later use --
-------------------------------------
USE master
exec xp_cmdshell 'c: & md "c:\program files\microsoft sql server\Audit"', no_output
 
--------------------------------------------
-- drop audit database if exist --
--------------------------------------------
IF DB_ID('DB_Audit') IS NOT NULL
BEGIN
    DROP database DB_Audit
END
go
 
--------------------------