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.