topic Re: Automate User Reports to Clients in APIs

Automate User Reports to Clients

bmcd113 — Fri, 02 Jun 2023 01:33:04 GMT

Hello, has anyone ever successfully setup automated reports on user enrollment and usage to external email recipients?

Looking to send reports out to clients based on their particular user counts monthly.

Re: Automate User Reports to Clients

raphka — Mon, 05 Jun 2023 02:13:06 GMT

Hi bmcd113,
The Accounts API when used with the Admin API for the child accounts would have the ability to make the calls required to get this information from Duo. You could then export/integrate the information output with your email systems.

If you are an MSP with questions about the Accounts API, please contact the Duo MSP team, who will be able to assist in more detail.

Re: Automate User Reports to Clients

Gigawatt — Fri, 21 Jul 2023 17:12:20 GMT

mbegan/Duo-PSModule: Duo Admin API Powershell Wrapper Module (github.com)

That's something we use. It's easy to setup but pretty sure this will help you on what you're needing.

After installing it you can retrieve properties such as 'last_login' & the module of their 'phone' since that would be their 2nd factor(enrolled).

I hope this helps!

$allResults = $Var | ForEach-Object {

duoGetUser -username $_ | Select-Object realname,username,status,is_enrolled,@{Name = 'last_login'; Expression = {Get-Date -UnixTimeSeconds $_.last_login }},@{name = 'Enrolled device'; Expression = { $_.phones.model -join ", " }}}