Skip to main content
Question

Identify users doesn't sync with AD

  • January 18, 2024
  • 4 replies
  • 49 views

Forum|alt.badge.img+7

Hi,

Is there any way to identify users that doesn't synchronise with AD?

4 replies

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • January 18, 2024

Hi @Sasanka 

I am affraid it isn’t possible. But maybe you can create a quick report.


Forum|alt.badge.img+7
  • Author
  • Do Gooder
  • 19 replies
  • January 18, 2024

Hi @Link 

 

I have access to the DB. do you have any idea about a Table that we can get this info?


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies
  • January 18, 2024

Hi @Sasanka 

check this view:

select * from ifsapp.ad_sync_user_log

 


Forum|alt.badge.img+10
  • Hero (Customer)
  • 63 replies
  • January 18, 2024

select * from dba_users

 

should give you an overview of users in the system.