cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dlafleur
Engaged Sweeper II

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

1 REPLY 1
francisswest
Champion Sweeper

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"