I'm working in a hybrid workplace where we have a requirement for at least three days in the office each week. We're spread across several countries and buildings, and I'm looking to implement a solution that uses PowerShell to track employee attendance. The goal is to figure out which Wi-Fi SSIDs employees connect to and send a notification to their manager if they're connected to anything other than the office Wi-Fi. Has anyone successfully done something similar?
4 Answers
Using PowerShell is definitely a possible route, but there's a lot to think about first. You might first need to integrate connection logs from a system like Intune into a database that Power BI can read. Building a dedicated parser could be crucial for cleaning up duplicates too. The real workload here may actually be on creating effective alerts and making sure managers only see relevant data. It’s a challenge for sure, but it’s doable if you plan it out!
Yes, I can definitely see how that could get complicated quickly!
Honestly, this seems more like a management issue rather than a technical one. Many folks here are suggesting that simpler methods, like badge readers or attendance applications, could be a much more straightforward way to track attendance without creating a complicated system with PowerShell and Power BI.
Absolutely! There are various attendance solutions that might be easier and more effective.
Couldn’t agree more—keeping it simple is often best!
It sounds like automating attendance tracking can be a bit more complicated than it seems. While you might get some data from SSIDs employees connect to, I think it raises some management issues. It often feels like a tech solution to a problem that might better be solved with direct communication instead. If managers are that concerned, maybe they should just check in personally instead of relying on tech?
Totally agree! Some things really shouldn't be automated. Good managers should communicate directly with their teams.
Right? Sometimes a simple walk down the hall is a way better approach than relying on software.
I think tracking via SSID is tricky because employees can easily spoof their home Wi-Fi to make it look like they're in the office. Instead, consider relying on something like the public IP to ensure more accuracy. That being said, attendance systems might be a better solution altogether. Are you looking into systems like 'Sign In App' that require users to actively check in?
Exactly! I hear those systems can be effective and might eliminate the need for over-complicated scripts.
Spot on! There are better ways than complicating things with tech.
This sounds spot on. It’s going to take a good amount of effort just to set it up correctly.