Console is retrieving process instances from history tables using jbpm-bam module. It is configured via hibernate.cfg.xml. So it can be either inside jbpm-bam-{version}.jar file or in gwt-console-server.war file. It contains connection definition to the data base to retrieve history information.
So you could verify that it has right data, by default it uses H2 db instead of hsql.
HTH