Event Queue Export

Event Queue Export

If a customer wants to export all of the customers from an Event to Excel, use the attached script.

1. Open the script on you computer to Notepad
2. Under Select, remove any c.[ColumnName], Customer table columns, the customer doesn't want
3. At the bottom, set 'where EHD.EventID = 25'. Change the '25' to the Event ID you need
4. Log onto the server > open SQL > click New Query
5. Copy the adjusted query & past into your new, blank query & press Execute
6. Copy the output into Excel on your computer to give the customer.

If you have any questions, ask level 2.

Related Articles