Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

is there a way to generate a report of users having localauthenabled=1

GauravJain
Regular Contributor
Regular Contributor

Hi - is there a way to generate a report of users having localauthenabled=1 in Saviynt?

I tried running a query in Data analyzer but its not permitted.

 

5 REPLIES 5

armaanzahir
Valued Contributor
Valued Contributor

@GauravJain 

 

Data Analyser won't allow it. 

Better try creating an analytic report that would fetch the results for you.

select username from users where localauthenabled=1

Using SQL Query (saviyntcloud.com)

Regards,
Md Armaan Zahir

SumathiSomala
All-Star
All-Star

Create analytic report using below query

select username from users where localauthenabled=1

SELECT localauthenabled FROM users WHERE username='admin'

 

 

Regards,
Sumathi Somala
If this reply answered your question, please Accept As Solution and give Kudos.

Manu269
All-Star
All-Star

@GauravJain Please use analytics for this case.

There are some security added by product where all the tables are not exposed for query.

select username from users where localauthenabled=1

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

sk
All-Star
All-Star

@GauravJain : You cannot run the query in Data Analyzer as localauthenabled column is not exposed. Instead you need to run the query in analytics


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star
  • You can create analytics report and check
  • Query : select username,firstname,lastname,email ,localauthenabled ,passwordexpired from users where localauthenabled =1
  • rushikeshvartak_0-1702092433972.pngrushikeshvartak_1-1702092468649.png

     


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.