ssumgirl
Posts: 186
Score: 0 Joined: 11/24/2004 Status: offline
|
Hi all. For history and audit purposes, we have to save all of our advertisements for a year or so and we normally expire them and move them to one of a number of folders in the console (depending on the advert). Problem is sometimes our guys will forget to expire or expire incorrectly, and maybe move to the wrong folde - then when we discover something is pushing that we were not expecting its a bit of a panic to find the advertisement to shut it off. Does anyone have a query that will list only advertisements that are active now, and the folder they exit in in the console? I took a look at the v_advertisement table and some of that is obvious, but when it comes to figuring out how to link to the table or tables that determine console/folder location I was lost.
|