Hey everyone,

After my recent post about the follower cleanup script, **@holoz0r** mentioned that it would be neat to aggregate the account authorities of the people you follow/following to see who has given authority to other accounts. I thought that was a fantastic idea, and I couldn't resist writing a script to do exactly that.

The result is a new tool that scans your social graph (followers and following) and builds a local database of all the `posting` and `active` authorities granted between those accounts. It helps you map out the "web of trust" in your corner of the Hive ecosystem.

### How it Works: Scan and Report

The script operates in two modes. First, you **scan** to collect the data, and then you **report** on what you've found.

#### 1. Scanning Your Social Graph

When you first run the script with the `scan` command, it fetches your follower and following lists. It then iterates through each unique account to record who they have granted authority to, saving it all locally in an SQLite database file (`authy.db`).

![Chunking along...](https://files.peakd.com/file/peakd-hive/thecrazygm/23t79QiJmgMbeEfBqtgLn5HAPMDiASmUZVnRtFTaN5yWWkbF1J2VJwzDVPaq9TYs7fYed.png)

After the scan is complete, it gives you a summary of the data it collected.

![Took about 15 minutes to scan them all.](https://files.peakd.com/file/peakd-hive/thecrazygm/23tRvZuKzc7wRM7BgouPoM5cDQ3ptvmMyPnZys6zNa7EVbMfYjFCPmfSjQciPUvcwKFic.png)

#### 2. Reporting on the "Web of Trust"

Once the scan is complete, you can run various reports to analyze the data. You can see who is most trusted with **posting authority** among the accounts in your social graph:

![Not too surprised. But it is a lot...](https://files.peakd.com/file/peakd-hive/thecrazygm/23tRvZr3Q7dasBz75uYZfYsqKzaX2mWQCrZgMcAXMtYpk4nVmR37BU3VwjwX6bZj1DfHT.png)

And you can do the same for **active authority**:

![There were more than I thought...](https://files.peakd.com/file/peakd-hive/thecrazygm/Eo8KedmJ15zsebLgYyhtKFbVE2T3QBxgJnMuMV4nPoYgJRiEF5QVCM7yYkW1uf4XjDd.png)

You can also drill down to see who a specific user, like `@ecoinstant`, grants authority to :

![not trying to throw you under the bus 🤣](https://files.peakd.com/file/peakd-hive/thecrazygm/Eo8KXYAF8bdDDq23XLd8iASosw6sonch4ZvZf3CpuwWRE3akjvjPNLK6ipmkQMjknu1.png)

You can also run one to see who has granted authority to a user. (I would show you the result of:
`bin/python/authy.py report --grants-to steemauto` but let's just say it would be longer than this post.)

![I'm guilty here too though, so...](https://files.peakd.com/file/peakd-hive/thecrazygm/23tRvSfCXWacGxZvi7f1snWz6L4ghyJ8CzLHq6h1QawYVuAbB2JS5L71LdpS8htuuP3qZ.png)


### Get the Script

This tool offers a fascinating glimpse into the social trust layer of Hive. You can find the script in the Gist below. As I've mentioned before, you can run it directly from the URL using `uv`.

- **GitHub Gist:** [https://gist.github.com/TheCrazyGM/1aaed40ca7d45104d982cc4fe77786b6](https://gist.github.com/TheCrazyGM/1aaed40ca7d45104d982cc4fe77786b6)
- **Example Command:** `uv run https://gist.github.com/TheCrazyGM/1aaed40ca7d45104d982cc4fe77786b6`

Just make sure to set your `POSTING_WIF` environment variable before running it, it gathers the account information from that.

As always,
Michael Garcia a.k.a. TheCrazyGM