# How to get compiled scripts output
**URL:** https://forum.liquibase.org/t/how-to-get-compiled-scripts-output/8557
**Category:** General Discussion
**Created:** [August 18, 2023, 7:58am UTC](https://forum.liquibase.org/t/how-to-get-compiled-scripts-output/8557 "2023-08-18T07:58:00Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@linuxerpro](https://forum.liquibase.org/u/linuxerpro)
#### Post date: [August 18, 2023, 7:58am UTC](https://forum.liquibase.org/t/how-to-get-compiled-scripts-output/8557/1 "2023-08-18T07:58:00Z")
I need to get compiled scripts output like below
Table Created
1 row Updated
Commit Completed
Can you please suggest how to get.
---
### Author:  [@daryldoak](https://forum.liquibase.org/u/daryldoak)
#### Post date: [August 18, 2023, 1:19pm UTC](https://forum.liquibase.org/t/how-to-get-compiled-scripts-output/8557/2 "2023-08-18T13:19:24Z")
I’m not sure I understand your question, but I’m assuming it related to seeing the results of your SQL executions. Try setting the following when you run Liquibase:
```auto
log-level=INFO
sql-log-level=INFO
```
> **[Liquibase Parameters](https://docs.liquibase.com/parameters/home.html)**
>
> Reference information for the Liquibase parameters and environment variables. The page identifies Liquibase parameters for use as environment variables, with the Properties file, and with the CLI.
---
### Author:  [@linuxerpro](https://forum.liquibase.org/u/linuxerpro)
#### Post date: [August 31, 2023, 9:23am UTC](https://forum.liquibase.org/t/how-to-get-compiled-scripts-output/8557/3 "2023-08-31T09:23:58Z")
Not working, below log FYR,
[2023-08-31 14:51:01] INFO [liquibase.ui] Running Changeset: Database/TABLES/MASTER\_TABLES/sample\_table.sql::4::SAMPLE
[2023-08-31 14:51:01] INFO [liquibase.changelog] Custom SQL executed
[2023-08-31 14:51:01] INFO [liquibase.changelog] ChangeSet Database/TABLES/MASTER\_TABLES/sample\_table.sql::4::SAMPLE ran successfully in 219ms
[2023-08-31 14:51:01] INFO [liquibase.util] UPDATE SUMMARY
[2023-08-31 14:51:01] INFO [liquibase.util] Run: 1
[2023-08-31 14:51:01] INFO [liquibase.util] Previously run: 3
[2023-08-31 14:51:01] INFO [liquibase.util] Filtered out: 0
[2023-08-31 14:51:01] INFO [liquibase.util] -------------------------------
[2023-08-31 14:51:01] INFO [liquibase.util] Total change sets: 4
## UPDATE SUMMARY Run: 1 Previously run: 3 Filtered out: 0
Total change sets: 4
[2023-08-31 14:51:01] INFO [liquibase.util] Update summary generated
[2023-08-31 14:51:01] INFO [liquibase.command] Update command completed successfully.
Liquibase: Update has been successful.
[2023-08-31 14:51:01] INFO [liquibase.ui] Liquibase: Update has been successful.
[2023-08-31 14:51:01] INFO [liquibase.lockservice] Successfully released change log lock
[2023-08-31 14:51:01] INFO [liquibase.lockservice] Successfully released change log lock
[2023-08-31 14:51:01] INFO [liquibase.command] Command execution complete
Liquibase command ‘update’ was executed successfully.
[2023-08-31 14:51:01] INFO [liquibase.ui] Liquibase command ‘update’ was executed successfully.
---
### Author:  [@daryldoak](https://forum.liquibase.org/u/daryldoak)
#### Post date: [August 31, 2023, 1:35pm UTC](https://forum.liquibase.org/t/how-to-get-compiled-scripts-output/8557/4 "2023-08-31T13:35:41Z")
Can you provide the full CLI command that you executed? I see all of the sql statements when sql-log-level=INFO.
---
### Author:  [@linuxerpro](https://forum.liquibase.org/u/linuxerpro)
#### Post date: [September 1, 2023, 4:28am UTC](https://forum.liquibase.org/t/how-to-get-compiled-scripts-output/8557/5 "2023-09-01T04:28:21Z")
liquibase update --changelog-file=changelog.xml --url=jdbc:oracle:thin:@10.1.1.134:1525:QADB --username=$SQA\_DB\_CRED\_USR --password=$SQA\_DB\_CRED\_PSW --log-level=INFO --sql-log-level=INFO
–changeset SAMPLE:3
–comment: Forward Alter Script
ALTER TABLE EMP\_LIST ADD (REMARKS varchar2(20));
COMMIT;
–rollback ALTER TABLE EMP\_LIST DROP COLUMN REMARKS;
–changeset SAMPLE:4
–comment: Forward Insert Script
Insert into EMP\_LIST
(NUM\_EMP\_ID, VCH\_NAME, VCH\_ADDRESS, VCH\_DESC, NUM\_DOB,
NUM\_DOJ,REMARKS)
Values
(1, ‘ASAITHAMBI’, ‘KGISL’, ‘RM’, NULL,
NULL,NULL);
COMMIT;
–rollback DELETE FROM EMP\_LIST WHERE NUM\_EMP\_ID = 1;
–changeset SAMPLE:5
–comment: Forward Update Script
UPDATE EMP\_LIST SET VCH\_DESC = ‘LEAD’ WHERE NUM\_EMP\_ID = ‘1’;
COMMIT;
–rollback UPDATE EMP\_LIST SET VCH\_DESC = ‘RM’ WHERE VCH\_NAME = ‘ASAITHAMBI’;