Diligent’s acquisition of Galvanize (ACL) is another nail in the ACL analytics coffin.
First, ACL acquired another company and created Galvanize. And we were told governance, risk, and compliance (GRC) would never be the same.
And I told you that ACL analytics would never be the same. In fact, I predicted that this acquisition meant that ACL analytics was dying (when I say ACL analytics, I’m referring to the Windows desktop version that they built the original company on).
For more on this, see ACL Officially Changes Name & Spots and Is ACL Analytics Dying?
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Scripting (ACL), Technology, Written by Skyyler
Tagged as acl, acquistion, analytics, Audit, coffin, data, desktop, Diligent, dying, exchange, file, galvanize, grc, huge, large, merger, nail, persistency, robotics, sales, source
When I ‘m trying to work with text files that are so big I can’t even open them with programs like Excel, Notepad, or PSPad, I reach for the FREE file-splitter program.
Continue reading →
Like this:
Like Loading...
Filed under Audit, Free, How to..., Technology, Written by Skyyler
Tagged as acl, chunk, file, import, reduce, script, splitter
When checking system access, make sure you look at all the different items that affect the user’s access. For example, the user might need one or more of the following:
- Application ID
- Application role or group
- Membership in an local server group, Active Directory (AD) group, or UNIX Group
- Access to the application’s share and/or folder on the server
- Database ID
- Database role, including access permissions (read/write)
- Other permission (from a home-grown application code or enterprise identify management system)
Continue reading →
Like this:
Like Loading...
Filed under Audit, How to..., Security, Technology
Tagged as access, active, AD, admin, application, Audit, batch, confidential, contractor, data, database, directory, employee, file, financial, folder, format, generic, group, hipaa, HR, ID, LDAP, log, membership, new, non-personal, OS, PCI, permission, personal, role, script, setup, share, sox, system, Unix, user
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
Did you know that you can create a script to import a file into ACL? That you can automate loading a table?
I’m talking about the File > New > Table command in ACL, also known as the Data Definition Wizard. Yes, you can create such a script, and I’m going to teach you how!
The good news is that it’s so much easier than you think. The bad news is that it doesn’t APPEAR easy, but it really is, because ACL does the heavy lifting for you. I promise that if you hang in there, you’ll so be a pro. Just try it once, and you’ll be hooked!
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as acl, automate, data definition, error, field, file, How to..., ignore, import, load, safety, script, table, wizard
In Top 100 Network Security Tools and Easy Windows Scanner, I described a few Windows tools that every auditor or security analyst should know or know about. In this post, I highlight some of my other favorite Windows tools (both security and general utility software). ALL OF THEM ARE FREE.
12/26/14 Update: These are STILL my favorite programs. The only one I don’t use anymore is CutePDF Writer, which I replaced with the FREE Sumntra PDF Foxit Reader (I no longer recommend FOXit). But if you only want a PDF printer, CutePDF is still a great solution.
I also added 2 new tools: PSPad and File Splitter (see my links at the bottom).
Continue reading →
Like this:
Like Loading...
Filed under Audit, Free, How to..., Security, Technology
Tagged as bookmark, Bruce Schneier, cryptainer, cutepdf, delicious, DOD, encryption, eraser, favorite, file, file recovery, free, mobile, overwrite, password safe, pdf, process explorer, pspad, software, splitter, task manager, thumb drive