Page Comparison

...

1. Open Microsoft SQL Server Management Studio

2. Connect to and open the BOSS database

3. Right Click on the VIEW directory and select the New View... option

4. Close the Add Table window

5. Copy the following query in to the view:[cce lang="sql"]
   SELECT     TOP (1000) Date, Action, Module, Result
   FROM         dbo.EventLog
   WHERE     (Result LIKE '%Running%' OR
   Result LIKE '%Starting%'  OR
   Result LIKE '%finish%' OR
   Result LIKE '%bill run%') AND (Module = 'Billing') AND Result NOT LIKE '%thread%'
   ORDER BY ID DESC
   [/cce]

   Code Block
   SELECT TOP (1000) DATE, Action, Module, RESULT FROM dbo.EventLog WHERE (RESULT LIKE '%Running%' OR RESULT LIKE '%Starting%' OR RESULT LIKE '%finish%' OR RESULT LIKE '%bill run%') AND (Module = 'Billing') AND RESULT NOT LIKE '%thread%' ORDER BY ID DESC

6. Click the Execute SQL button [ ! ] or [CTRL]+R, to run the query

7. Save the View (no special characters or spaces, under scores can be used in place of spaces). Remember the name of the view as you will need to enter this value in EngageIP Billing

...