I repeatedly wrote and used a fairly big pile of scripts, over various platforms. Shell, but mostly Powershell on Windows, starting from when it was just available.
It worked wonders: I made information gathering scripts to scrape ALL available sources, dynamically queried from the devices, or static from other sources, including whatever crooked enterprise solution was already wasting electricity. I had them run one a or a few times per day generating raw results.
Then a second layer of scripts would make useful combinations and comparison lists.
A third layer would then form presentation lists.
I made the third type available to complete idiots, the second to lesser idiots, and the first to nobody (no higher level available...)
It worked wonders, everybody wanted and used that information, I could usually provide any "report" almost on the spot, whereas previously, making such a "report" would have been a regularly repeated onetime action (!), requireing a small project, weeks of time, and mostly lots of networking, server, and most of all database "experts" claiming it was difficult and infighting each other.
The only thing is: do it under the radar of management, they need their enterprise systems and projects to be able to claim success.