Hello, I am new to One Identity i want to query a certain data using SQL editor under the Designer tool. Does anyone here knows how does the SQL works in that environment. Thank you so much.

Error during execution of statement: Select Firstname, Lastname
from person
Database error 1: SQL logic error
no such table: person

I use "Select firstname, Lastname from Person" SQL and i get that error i want to know how the sql editor gets the data. Can you please help me.

As described in the documentation here https://support.oneidentity.com/technical-documents/identity-manager/8.1.4/user-guide-for-one-identity-manager-tools-user-interface/24#TOPIC-1530138 you can only run statements against the internal SQLite database of the Designer.

So this would work:

select FullPath, ConfigParm, Value, Enabled from DialogConfigParm
Order By Fullpath

Hi Markus, Thank you for answering my question, Is it also possible to connect the powershell to one identity? I will be glad to hear from you again.

Yes, there is a PowerShell module available on GitHub. https://github.com/OneIdentity/IdentityManager.PoSh

You will find a short introduction in one of our videos on our official YouTube channel. The link should point you to the correct time in the video.

https://youtu.be/ohqiTbctoQU?t=692