Some of my Favorites

Since some of you are newer to the blog, I thought I’d bring a couple of my favorite posts to your attention.

Some are older, some are newer, some are mine, some are skyyler’s, in no particular order…

Top 10 Reasons to be an IT Auditor (2012)

Here’s why I’m an IT auditor.

Top 10 Bad Jobs (2010)

I like this one for 2 reasons. First, and foremost, I stole it from my blogger colleague across the pond, the one and only UK Audit Monkey. Thanks again, bud!

Second, it describes the jobs I had prior to being an auditor, and how I view the differences between them.

Why a Wastebasket Audit? (2010)

I still think this is one of the more valuable and underused audits (probably because it doesn’t require data analytics). I also mention it because, for some reason, it really irritates some people, and I wonder how you’ll react.

Server Audit for the Dauntless (2014)

This is one of my favorites because of all the issues I identified when I performed this audit, and it was just a fun audit.

5 Things I Hate About ACL (2014 – skyyler)

They haven’t addressed any of these issues either. Oh well. I was really hoping for a user interface redesign in 2016.

Maybe it will take another 108 years, kinda like the Chicago Cubs winning the World Series.

You Might be an ACL Freak if… (2014- skyyler)

Somebody at the 2015 ACL Connections conference posted the graphic associated with this post in the ACL conference app (see below). Thanks to Mike for forwarding the screenshot to me; I redacted the names.

Also, skyyler really dreams about ACL, and not just when he’s asleep.

acl connections aclzzz

I find it interesting that no 2015 or 2016 posts jumped out at me. I think because most of those posts were technical how-to posts, and most of the ones listed above don’t fall into that category.

The only 2015 post that comes close is #1 Reason for NOT Doing Data Analytics, but it is not a favorite, as the subject still gets ME irritated. And skyyler wrote it, and I don’t want to mention more of his stuff than mine. :)

If I had to pick a 2016 post, it would be How to Describe What an IT Auditor Does? because it was fun to write, probably because I got kind of snarky. As time goes by, I’ve noticed, I’m getting snarkier on this blog.

I also noticed that I posted fewer items in 2015, and especially 2016. I haven’t run out of material, just time (I have at least 40 drafts of posts yet to be finished and published).

Let me know what you think of these posts. If you have any favorite posts, let me know which ones and why. Thanks!

Leave a comment

Filed under ACL, Audit, How to..., Security, Technology, Top 10

ACL Import Fails, No Error?

import errorToday I was adding a new table to a scripted ACL project and kept getting an error.

This project automatically opens a folder on the LAN, reads the files in the folder, and loads all of them.

All I did was add one more file to the folder. ACL refused to load that one file.

Syntax error.


Continue reading

Leave a comment

Filed under ACL, Audit, Data Analytics, Scripting (ACL), Technology

How to Review Your ACL Log

Review ACL logWhether you script your projects or use menu commands, you need to review your ACL log carefully.

Good analysts review their results and the log as they work in ACL, after they think they are done, and have others review their log before the ACL project is relied upon.

(You can’t imagine the dumb mistakes my team and I found that saved us a lot of embarrassment later.)

Continue reading


Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler

Transform Data Fast with Excel Flash Fill

Excel Flash Fill, the un-formula filler, formatter, and concatenatorYou can easily use Excel’s Flash Fill tool to transform data fast, without formulas.

Did you catch that? Without formulas!

Flash Fill has been around a few years, but few people, including auditors, seem to be aware of it.

This tool is so easy to use, you could learn it AND teach it to your mom in 4 minutes. Really.

Continue reading


Filed under Audit, Data Analytics, Excel, How to...

Dilbert Does Big Data

Dilbert does Big Data
If you like Dilbert cartoons or big data, you might enjoy Dilbert’s adventures in data analysis, data mining, data privacy, security, and dealing with a dumb manager.

Continue reading

Leave a comment

Filed under Audit, Data Analytics, Humor/Irony

Safely Check Bad URLs

If you’re looking for a way to safely check URLs for bad content, Lenny Zeltser had a great list of free online tools for you.

Continue reading

Leave a comment

Filed under Free, How to..., Security, Technology

How to Describe What an IT Auditor Does?

IT auditor shot serverIf you’re an IT auditor, how do you describe your job to those who don’t understand technology or auditing? Even more interesting, how do others describe your activities?

Here’s what I say, but I’m not satisfied with it:

I review computer systems and networks to determine whether they are secure and that access to those systems is limited to the appropriate people.

I review the policies and procedures that describe how those systems are used and determine whether those documents make sense, are up-t0-date, and are followed.

Continue reading


Filed under Audit, Employment, Humor/Irony, Technology