Can I get a list of users for whom a certain update in user field happened on a certain day

[Debankita]

Hi Team,

Is it possible to get the list of users for whom a certain user field got updated on a certain day with the help of analytics control or any functionality.

[SumathiSomala]

@Debankita Sample query

select
u.username,
u.userkey as userkey,
uh.changelog
from
users u inner join usershistory uh on u.userkey = uh.userkey
where
username is NOT NULL
and uh.UPDATEDATE >= DATE_SUB(CURDATE(), INTERVAL 5 DAY)
and u.username is NOT NULL
and changelog like '%customproperty1%'

[rushikeshvartak]

Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...