<@U0178JY9A81>
```osquery> SELECT username, apd...
# generalf
fritz
11/02/2020, 1:30 PM@Macear
Copy code
osquery> SELECT username, apd.* FROM account_policy_data apd, users USING(uid);
+-----------------+------------+------------------+--------------------+------------------------+------------------------+
| username | uid | creation_time | failed_login_count | failed_login_timestamp | password_last_set_time |
+-----------------+------------+------------------+--------------------+------------------------+------------------------+
| fritz | 501 | 1520000969.91084 | 0 | 0.0 | 1594391295.15938 |
| nobody | 4294967294 | | | | |
| root | 0 | 1537895434.27449 | | | |
+-----------------+------------+------------------+--------------------+------------------------+------------------------+2 Views