Active Employee list (Security file)

Legacy Contributor

Hi there, I'm new to IPA development and was wondering if anyone might have an IPA flow that extracts active employees from the security file available that you would be willing to share.  The goal is to build an CSV file and email it to me (something simple for now).  We use ISS and LSF for security maintenance.

Legacy Contributor

You can use an SQL query node and query LSGEN table. Then have it return any record where active flag is set to true and put it into a message builder and put the message builder to a file.