Looking for a report for Local users created in AWS

[dlafleur]

Hello and TGIF.

I am looking for a report that would show Local Users that were created in AWS.  
For instance:  a user account called NOC_user is created in AWS.  Then that account is assigned a Key\Secret (like a username and password).  I am looking for a report that can show that.  Any suggestions?

Thanks

Dave

[francisswest]

Do you mean like, a Local Active Directory user who was created in AWS, then sync'd down?  If so, so long as you have a custom attribute in AD for that info, you can try it with this:

SELECT tblAssets.AssetID,
       tblAssets.AssetName,
       tblAssets.Domain,
       tblADusers.Username,
       tblADusers.Created,
       tblADusers.awsCreated
FROM tblAssets
INNER JOIN tblADusers ON tblAssets.AssetID = tblADusers.AssetID
WHERE tblADusers.awsCreated = 'True'
ORDER BY tblADusers.Created DESC;

In the above example, I assumed the custom attribute was named "awsCreated"