https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65404#M18009 We don't recommend querying the DB directly for a number of reasons, but mainly because of the risk of affecting the whole environment. But for 1 the table to look at is BPAWorkQueueItem and for 2 and 3 it would be BPASessionLog. But be warned - these tables are usually the largest in a BP DB and expensive queries could have a negative impact. Fri, 16 Nov 2018 17:31:00 GMT John__Carter 2018-11-16T17:31:00Z https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65401#M18006 Hi All, I have few questions according to data stored in SQL base - as for now I do not have access to extract information, but it will change soon. Meanwhile, few questions to this base: 1) Can I extract whole Data inputted to queue ? 2) Can I see variables in specific moment/time ? 3) Is there chance to see end time of specific page/object ?   Regards, Pawel Thu, 15 Nov 2018 13:47:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65401#M18006 PawełMiżwa 2018-11-15T13:47:00Z https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65402#M18007 1) You can't see the data item contents from control room - this is intentional. You can use the Get Next Item or Get Data function in a process however. 2) If a data item is exposed as a Session Variable, then you can see/edit the value from control room while the process is running. 3) If the End stage of the page is logged then there will be a timestamp in the session logs. Thu, 15 Nov 2018 15:53:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65402#M18007 John__Carter 2018-11-15T15:53:00Z https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65403#M18008 I have asked for SQL, answers do not represent the topic. Fri, 16 Nov 2018 13:24:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65403#M18008 PawełMiżwa 2018-11-16T13:24:00Z https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65404#M18009 We don't recommend querying the DB directly for a number of reasons, but mainly because of the risk of affecting the whole environment. But for 1 the table to look at is BPAWorkQueueItem and for 2 and 3 it would be BPASessionLog. But be warned - these tables are usually the largest in a BP DB and expensive queries could have a negative impact. Fri, 16 Nov 2018 17:31:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65404#M18009 John__Carter 2018-11-16T17:31:00Z https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65405#M18010 Hey John, We would like to query the DB, too. Now I am unsure since you do not recommend it. Do you have any formal manuals? Are all/some negative aspects/impacts listed in manuals or somewhere else? Thank you in advance and have a nice day. Thu, 13 Dec 2018 17:06:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65405#M18010 DamianMastalerz 2018-12-13T17:06:00Z https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65406#M18011 Hi Damian - no there are no formal documents and for specific advice I'd recommend contacting the technical support team. Mon, 17 Dec 2018 15:23:00 GMT https://community.blueprism.com/t5/Product-Forum/SQL-server-queries/m-p/65406#M18011 John__Carter 2018-12-17T15:23:00Z