Automate User Reports to Clients

[bmcd113]

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.

[raphka]

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.

Duo Security

Accounts API

Duo’s trusted access solution enables organizations to secure access to all work applications, for all users, from anywhere, with any device they choose.

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.

[Gigawatt]

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 ", " }}}