Rumors have it that ACL will no longer be available on the desktop (laptop, or other local machine) in 5 years.
That is, according to an ACL user who attended the 2018 ACL Connections conference.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Scripting (ACL), Written by Skyyler
Tagged as 5 years, acl, analytics, cloud, Conference, connections, database, desktop, developer, download, gone, input, kimiko, output, robotics, software, text
Building a successful audit analytics program is like climbing a staircase.
The staircase is a set of steps that consist of several items having increasing levels of maturity.
The staircase steps not only help you build your program, but enable you to measure that maturity.
As you view the staircase graphic, mentally insert the word “analytics” before each step.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, How to..., Technology, Written by Skyyler
Tagged as acl, addin, alignment, analytic, Audit, automate, BI, chart, company, data, database, descriptive, diagnostic, download, education, engagement, enterprise, excel, Fuzzy Lookup, graphic, hardware, high risk, maturity, measure, menu, model, perform, pivot, power, predictive, prescriptive, program, query, software, staircase, strategic, tools, training, view, visual, visualization
At a company I worked at recently, I ran across a Sharepoint site and wondered whether I could download data that I wasn’t supposed to see.
Now I understand the purpose of SharePoint and company intranets is to share data, but even then, some data should be restricted to a limited number of people.
So I decided to check (before doing things like this, you better know How to Stay Out of Jail).
Continue reading →
Like this:
Like Loading...
Filed under Audit, Excel, How to..., Security, Security Scout, Technology
Tagged as access, account, anonymous, authentication, database, download, excel, failure, intranet, lotus notes, permission, rights, risk, search, Security, sharepoint, stay out of jail
Here’s a way to automate the download of data from Active Directory (AD), specifically group members, into ACL using adfind and the ACL Execute command.
I’ll walk you through it step-by-step.
This was posted before ACL released their own Active Directory driver, which I still haven’t figured out.
Even if you don’t use ACL, you might gain a better understanding of AD and LDAP in general….
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, How to..., Scripting (ACL), Technology, Written by Skyyler
Tagged as active directory, adfind, automate, browser, cn, command, common, dc, distinguished, dn, domain, download, execute, group, joeware, LDAP, name, organizational, ou, primer, prompt, softerra, troubleshoot, unit, Windows
Creating scripts (and editing them) is not as hard as many of you believe them to be.
Sure, it takes practice and time to learn the basics, but YOU can do it.
If you don’t learn scripting, you are NOT using ACL to it’s fullest, nor are you making the best use of your time.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, Free, Free Download, Scripting (ACL), Written by Skyyler
Tagged as acl, Anke Giegandt, best practice, command, Conference, create, design, download, error, free, log, Presentations, recorder, script, syntax, table history, table history incomplete
ISACA has a free glossary of IT, audit, and security terms that is not only helpful in studying for the CISA exam, but is a good reference guide for new and experienced auditors.
Continue reading →
Like this:
Like Loading...
Filed under Audit, Free, Security, Technology
Tagged as assurance, Audit, black box, chain, cisa, custody, define, definition, download, exam, free, glossary, guide, isaca, materiality, objectivity, reference, sampling, Security, SOD, suspense, wsdl
PSPad is a great text editor and search tool, so by default, it’s a great audit tool, and it’s free. It can also handle a million lines of text–literally. Are you interested yet? It is also a great file diff/compare tool I’ve ever seen.
PSPad works with text files, such as those ending in TXT or CSV, or any text-based file (like an ini file). It works with DOC files too.
I’ll explain how to do the following with PSPad:
- Search a file (find all lines containing X)
- List all occurrences/matches of a search term
- Export a list of occurrences
- Compare 2 documents (diff)
- Download & install PSPad
Continue reading →
Like this:
Like Loading...
Filed under Audit, Free, How to..., Security
Tagged as Audit, claro, compare, csv, diff, difference, download, export, fast, file, find, free, install, match, pricegong, pspad, regclean pro, search, software, text, tool
I recently downloaded the contents of a Lotus Notes Domino database to Excel without any access to the database. If you’ll recall, I do audit consulting, and was performing an audit at a Fortune 100 company.
Continue reading →
Like this:
Like Loading...
Filed under Audit, Excel, How to..., Security, Technology
Tagged as access, account, authentication, database, download, excel, intranet, lotus notes, rights, search
When you’re trying to load a new file into an ACL table, you’ll sometimes get this error:: “Application error. ACL Desktop cannot complete this function…contact ACL Technical Support…” (see below).

Here’s the situations in which I’ve encountered this error, and how I’ve fixed it (most common and easiest to fix situations are first).
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, Written by Skyyler
Tagged as acl, complete, csv, desktop, download, error, export, fix, function, load, skyyler, solution, table, technical support, txt, wizard
A recent Lifehacker article makes life easier (and cheaper) for users and harder for companies and their IT and security pros. Top 10 Ways to Access Blocked Stuff on The Web provides tips (not all ethical) on how to go around, over, under, or through the following fences:
Continue reading →
Like this:
Like Loading...
Filed under Security, Top 10
Tagged as bittorrent, block, bypass, download, flash, lifehacker, proxy, remote, Security, Top 10, video, web, youtube