Der Filter DoubleMAC (SW_FilterDoubleMAC.sql) wird anstandslos erstellt.
Orginal SQL-Skript:
Code: Select all
IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID(N'[SW_FilterOlder30Days]') AND OBJECTPROPERTY(ID, N'ISVIEW') = 1)
DROP VIEW SW_FilterOlder30Days
CREATE VIEW SW_FilterOlder30Days
AS
SELECT DISTINCT client_id, [name], InventoryID, bDelete, [Domain], os_type, type
FROM clients
WHERE (os_type <> 17) AND (os_type <> 18) AND (os_type <> 19) AND (os_type <> 21) AND (bDelete < 2)
AND (client_id IN (SELECT client_id FROM InvComputer
WHERE InvDate < DATEDIFF(second, '1/1/1970', GETDATE() - 30)))