London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

AI OnAI Off

SQL Query to return all PUBLISHED pages in Episerver 6

Sam Thompson
Sam Thompson
Vote:
 

I am trying to run a SQL query to get all of the pages that are published on my live website. I can't find the table property to highlight this published state. Does any know the table name and table property that I need to query please.

Thanks

Sam

#152643
Aug 26, 2016 16:15
Per Bjurström
Per Bjurström
Vote:
 

tblPageLanguage (PendingPublish/StartPublish/StopPublish)

#154820
Aug 30, 2016 16:23
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.