4,741 reputation
1850103
bio website security.stackexchange.com
location Florida
age 32
visits member for 4 years, 3 months
seen 16 hours ago

I'm not the droid you're looking for.


Oct
6
comment How did the Marriott block wifi hotspots?
It's really too broad of a question to be good for anywhere in StackExchange. Layer 1 jamming would be the most effective, but would mean that other hotspots sharing the channel your APs use would have to be left alone and you'd still have considerable cross-channel interference from the jammers. Spoofing deauth packets would let you target same-channel hotpots without significantly impacting your own, but I'm not sure how it would keep users from being able to see their own hotspots - certainly, they might not be able to join them but they should still be able to see them.
Oct
6
comment Is there a way to use Regex( or comparable solution) in Excel formulas?
I think we need to know a bit more about what data you're looking to match and how you're going to use it, and what the "data" cells will normally look like. Depending on those parameters, matching could be done to be as simple as "this line contains a stock ID (TRUE/FALSE)" or "this is the stock ID on this line".
Oct
3
comment How to find and replace text in embedded excel spreadsheets in word?
This is incredibly vague, and currently impossible to answer. At the very least, we'll need some samples of the data you're looking to change and an idea of how you're wanting to change it.
Oct
2
comment Excel, using cell text references as input for formula
Short, incomplete answer: I think you need to familiarize yourself with the Excel naming conventions for references that cross between sheets and/or workbooks. Then, fix your formula with INDIRECT and CONCATENATE. However, I'm a little unsure that I properly understand your problem. Can you re-phrase/re-format your post to be less wall-of-texty, and perhaps include some sample data and expected outputs? Also include what formula(s) you're currently using which apply to this problem.
Oct
2
comment Can I disable the warning when a group policy restricts program execution?
@trlkly Fair point. But on a managed system, you should have users see this also. It means either that something legitimate didn't make it into the whitelist, and so some functionality is probably broken that shouldn't be, or some unauthorized software has been installed and sysadmins need to be quickly notified. Event log review/alerting is great, but a user who's gotten a scary-looking notification is usually going to draw attention & action faster. You want that in the case of a possible security incident.
Oct
1
comment How to connect 100 bluetooth devices to a single pc
If nothing else, you're looking to create a metric crap-ton of RF noise with all those devices paired (I'm assuming most, if not all, will also be concurrently active) at once. Keep in mind that Bluetooth operates in the same band as 802.11b/g/n, as well as many wireless phones and many other intentional and incidental RF emitters.
Oct
1
comment Cannot load router interface in Win8.1, even though ip address, DNS, etc all set correctly
Also, until you've established access to the web interface, all troubleshooting should be done via a wired connection with WiFi on the laptop turned off. This eliminates potential interference from two possible issues: 1.) You may be inadvertently to the wrong WiFi network. 2.) Your router may be configured to disallow admin access over WiFi.
Oct
1
comment Cannot load router interface in Win8.1, even though ip address, DNS, etc all set correctly
It's possible, however generally unlikely, that your router's web address might be hosted on a different IP than the primary gateway service. Try 192.168.1.254, like @happy_soil suggested. Also, have you tried both http:// and https://? Have you tried using different browsers? Have you tried running those browsers in "Safe Mode" (not Windows' Safe Mode - the browser's Safe Mode, where all plugins are disabled)? What error(s) do you see when trying to navigate to the web interface? Output from ipconfig -all, route print, and tracert 8.8.8.8 could be useful.
Sep
26
comment Importing multiple CSV files
Please provide some example sheets so we have an idea of the data you're trying to work with. I'm not sure if Excel has built-in user-friendly features that can help with this, but it might be something that can be done with VBA or PowerShell.
Sep
24
comment Appending Year to Excel Date
If they're formatted dates, the last bit of my solution might not work - it assumes they're string values. Let me know if it's broken and I'll look into what's needed to fix it. Or, if you manage to fix it yourself, please let me know what you did.
Sep
24
comment Appending Year to Excel Date
Are the dates (e.g. "02-August") formatted as dates or text?
Sep
24
comment How to fix my local administrator?
Do you have access to an Admin-level account? Or is someone else responsible for administering the system?
Sep
24
comment Schrodinger's Contacts in Lync
@SvW That process is mired in corporate procedure involving a call center and several tiers of support. I much prefer to self-support troubleshooting of issues when I can - it's usually faster and less painful (and often more educational) that way.
Sep
24
comment Schrodinger's Contacts in Lync
@SvW Perhaps better suited for Super User? If it's a problem that doesn't require admin intervention (and I don't know that it is/isn't for sure - this is one of the reasons I'm asking), I don't see why it wouldn't belong either there or here. Either way, an answer of "this is a problem that needs to be resolved on the server or requires admin intervention" is also perfectly acceptable, if true.
Sep
24
comment Issue regarding text message privacy
@Ramhound That depends on how the app handles SSL certificate errors. If it ignores errors and accepts all certificates, an SSL proxy can step in the middle and intercept the communications. A desktop web browser would show errors stating that the certificate issuer is untrusted, unless corporate policy has been applied to force the system to trust it, but some apps (and many users) will just ignore this. I don't know the particulars about iMessage for certain, to say whether or not this is the case for that app. If you know, or find out, I suggest posting an answer that covers the topic.
Sep
24
comment Issue regarding text message privacy
From a quick Wikipedia lookup, it seems end-to-end encryption is used for iMessage. However, there's no mention about resistance to SSL proxies or similar interception technologies.
Sep
24
comment Issue regarding text message privacy
@Ramhound Not entirely true. iPhones will use iMessage by default for texting with other iOS users. iMessage will use WiFi. From there, it's just a matter of whether iMessage uses encryption for data-in-transit, and if the implementation is resistant to man-in-the-middle attacks like SSL proxies.
Sep
24
comment How to fix my local administrator?
Is this your personal computer, or a company resource? If the latter, go with the coffee & donuts solution suggested by @YetiFiasco. If the former, it's probably time for a rebuild anyway. Some very restrictive UAC configurations can prevent you from being able to run commands that require elevation without already being in an elevated session (e.g.: use an elevated CMD prompt instead of Start->Run), but you usually won't see that at home.
Sep
24
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
Sorry about the confusion in DEL /S. I must have been reading about the same switch in a different section of the TCC docs or something. As for PowerShell, you've got to go back to Windows 2000/Me before you find an OS it can't run on. (And TCC can't go that far back either, though its predecessors may.) XP/2003 can't get the latest and greatest, and some of the newer modules aren't available below the latest Windows versions even with the same PowerShell version installed, but they can all still go up to at least PowerShell 2.0 which generally covers all the essentials.
Sep
23
comment Managing a drive - searching for files that are rarely in use (so I can delete them for space)
@RubenBaden If you ran the command exactly as-is in the answer, and only changed C:\*path*, you'll find the output in a file called "xxxxxxx.csv" within the current working directory.