Report showing all users created within the past 30 days?
Hi all. I've been tasked with creating a K1000 report that provides the name of all users created within the past 30 days. I am not a SQL gal so if anyone can help me on this it would be greatly appreciated!
Answer Chosen by the Author
Here you go:
SELECT USER_NAME, EMAIL, FULL_NAME, CREATED FROM ORG1.USER
WHERE CREATED > DATE_SUB(NOW(), INTERVAL 1 MONTH);
If there are other fields required for your report let me know.