Omniture bookings

Setup a stored procedure in the Guestdesk database called OmnitureBookingsAllInterfaces. Running this will give you all of the bookings for everyone that has settings in the Reservationsdb --> omnitureHotels_Lookup table. If you need to export the data into Excel, csv, etc. you can run the following:

DELETE FROM guestdesk.dbo.tblOmnitureBookingsExport

INSERT INTO guestdesk.dbo.tblOmnitureBookingsExport 
EXEC guestdesk.dbo.OmnitureBookingsAllInterfaces 
@arrivalDate = '9/1/2012', 
@departureDate = '9/30/2012'

You can then export the guestdesk.dbo.tblOmnitureBookingsExport table to a file.