Indeed. Anand already answered how to see the custom pages details using Coreservice API.
As @Anand/Peter already mentioned in his comment to clarify how to get the custom page XML using API, because in database it's store as Encoded XML Fragment.
It looks like you are still looking at the database level to see that data not using Coreservice API.
SDL highly recommends that you use the APIs to read. Accessing the database directly carries a high risk. The risk is that you corrupt the database or incur data loss. Only Engineering knows database design and business logic about the database data how it's stored.
Anyway, let me give you two examples one with full Coreservice example another one with database read.
Coreservice Example:
using System;
using System.ServiceModel;
using System.Xml;
using Tridion.ContentManager.CoreService.Client;
namespace SDL.FindAndReadCustomPagesURL
{
class Program
{
private const string ServiceUrl = "{0}webservices/CoreService201603.svc/basicHttp";
private const int MaxMessageSize = 10485760;
static void Main(string[] args)
{
try
{
var client = GetClient("localhost:7086");
client.ChannelFactory.Credentials.Windows.ClientCredential = new System.Net.NetworkCredential("username", "password");
var appData = client.ReadApplicationData(null, "CustomPages");
if (appData != null)
{
var ada = new ApplicationDataAdapter(appData);
XmlElement appDataXml = ada.GetAs<XmlElement>();
Console.WriteLine(appDataXml.OuterXml);
}
}
catch (Exception ex)
{
Console.Write($"Failed to process {0}", ex.Message);
}
}
static CoreServiceClient GetClient(string hostname)
{
var basicHttpBinding = new BasicHttpBinding
{
MaxReceivedMessageSize = MaxMessageSize,
ReaderQuotas = new XmlDictionaryReaderQuotas
{
MaxStringContentLength = MaxMessageSize,
MaxArrayLength = MaxMessageSize
},
Security = new BasicHttpSecurity
{
Mode = BasicHttpSecurityMode.TransportCredentialOnly,
Transport = new HttpTransportSecurity
{
ClientCredentialType = HttpClientCredentialType.Windows
}
}
};
hostname = string.Format("{0}{1}{2}", hostname.StartsWith("http") ? "" : "http://", hostname, hostname.EndsWith("/") ? "" : "/");
var remoteAddress = new EndpointAddress(string.Format(ServiceUrl, hostname));
return new CoreServiceClient(basicHttpBinding, remoteAddress);
}
}
}
Database Level Read:
Use Tridion_cm
SELECT [APP_ID],CONVERT(varchar(max),CONVERT(varbinary(max),[DATA_CONTENT])) as XMLDATA
FROM [Tridion_cm].[dbo].[APP_DATA] WHERE APP_ID='CustomPages'
I hope it's helps