You need to sign in to do that
Don't have an account?
Adrielle Robinson 14
query for password policy changes
Hello,
Not sure if this question posted correctly, so here it is again:
I need to append this query to show any changes made to the password policies only. What do I add to retrieve only the changes to the password policies?
SELECT Action, CreatedBy.Profile.Name, CreatedDate, DelegateUser, Display, Id, Section
FROM SetupAuditTrail
WHERE CreatedBy.Profile.Name = 'System Administrator'
p.s. I am running this query in workbench, thanks!
Not sure if this question posted correctly, so here it is again:
I need to append this query to show any changes made to the password policies only. What do I add to retrieve only the changes to the password policies?
SELECT Action, CreatedBy.Profile.Name, CreatedDate, DelegateUser, Display, Id, Section
FROM SetupAuditTrail
WHERE CreatedBy.Profile.Name = 'System Administrator'
p.s. I am running this query in workbench, thanks!
My bad, I missed 'AND'.
All Answers
SELECT Action, CreatedBy.Profile.Name, CreatedDate, DelegateUser, Display, Id, Section
FROM SetupAuditTrail
WHERE CreatedBy.Profile.Name = 'System Administrator' WHERE Action LIKE '%pass%'
Above query returns records containing "pass" in Action field.
Try below to retrieve passwordexpiry:
SELECT Action, CreatedBy.Profile.Name, CreatedDate, DelegateUser, Display, Id, Section
FROM SetupAuditTrail
WHERE CreatedBy.Profile.Name = 'System Administrator' WHERE Action = 'passwordexpiry'
CreatedBy.Profile.Name = 'System Administrator' WHERE Action = 'passwordexpiry'
^
ERROR at Row:3:Column:55
unexpected token: 'WHERE'
My bad, I missed 'AND'.