I've been setting up various daily and weekly email reports for things like password expirations, open tickets, exchange logon failures, and IIS reports. Personally, I'm not a big fan of cluttering inboxes with emails, so I thought about creating an internal site that provides the same information. This way, the data would be real-time instead of just what was sent out early in the morning. Has anyone tried something like this?
7 Answers
Another option is to run your scripts continuously for real-time updates. Just adjust the scheduling accordingly!
I went for a similar route. I consolidated all my data from different systems into a SQL database, then built a Power BI dashboard for key metrics. If you use a premium workspace, it can also provide usage reports, which is a nice feature.
Thinking of giving Power BI a shot. Does it function like SSRS for reports?
From what I've seen, using email often leads people to ignore the reports since they just filter everything out. On the flip side, if you have a website, people might not bother checking it regularly unless it's bookmarked. Then, when issues arise, everyone blames the lack of visibility. I'd suggest looking into PowerShell Universal for setting up an internal dashboard.
We mirror our email reports in Confluence, which helps with visibility. It’s interesting to see what others are doing too—is anyone willing to share examples of dashboards in action?
Dashboards are definitely the way to go. They can keep your mailbox less cluttered and might even encourage people to actually engage with the updates instead of ignoring them like they do with emails.
I actually implemented this! Here's a video overview: [YouTube Link](https://www.youtube.com/watch?v=OmdCANL50yU) and the project can be found on GitHub. It works pretty well hosting dashboards for AD and O365, and it updates every few hours, so you can keep your reports organized and accessible.
Sounds genius! You should definitely write a blog post on it!
I dabbled with creating a web interface for helpdesk tools, and you can do essentially anything you can run with PowerShell. Check out Pode.Web for that.
If you pair it with Posh-ACME for self-updating certifications, it can really streamline your HTTPS setup.
Right? Just optimize the task frequency!