A look at Q1 Labs’ QRadar

Archive for the ‘Security Information Management’ Category

A look at Q1 Labs’ QRadar

Posted by

Information security can be fundamentally described in terms of protection, detection, and response. One can say a system is secure if it takes an attacker a very long time to break the protection. For example, in encryption, cryptanalysts claim it will take thousands of years to break certain ciphers with large keys. By the time the protection is cracked, the information is no longer relevant or worthwhile. Time is an important benchmark. InfoSec professionals spend a lot of time bolstering protection mechanisms.

For an attack to be prevented, the time protection provides has to be longer than the value of the information, or the time it takes to detect and respond to the attack. Take this month’s indictment of the computer criminals who stole some 41 million debit and credit cards from computer systems at TJX, Office Max, Boston Market, Barnes & Nobles and others. If retailers had detected the attack in less time and responded, the loss of information would have been much less.

In fact, detection within 24 hours of the attacker’s initial reconnaissance and appropriate response can stop information from being stolen at all. Thus we should spend as much time on detection as we spend on prevention. However, that is often not the case because detecting means watching what is going on in the system. For any sizeable network today, there is always more going on that one person (or even a team) can watch.

This is the need that security information management (SIM) consoles fill. They watch the network and boil down the information into the key statistics and events. Source data comes from event logs, network flow, and sensors. Performance is important here as networks get rather busy (a typical 100 computer network sees about 20 events and 200 packets per second). SIM consoles then correlate these events and report on suspicious and irregular activities. Hence the criteria for SIMs are ease of use, log and network performance, correlation and detection abilities, and reporting depth and clarity. I recently had an opportunity to evaluate a product in this space: Q1 Labs QRadar.

The breadth of their offering immediately got my attention. QRadar provides all the detection of my personal patchwork of tools. I use a C# app with a SQL database for Windows log management. There is a Syslog system for the Unix/Linux logs. On the network side, Compuware’s NetworkVantage is running for top-level reports. Yet this does not allow me to drill down into the details, which is important for doing forensics, so I have another system that captures network traffic and dumps into Wireshark for analysis. Neither provide real-time alerting. For that, I have deployed Snort and some other off-brand intrusion detection system (the name escapes me at the moment.) During investigations, I have to manually pull information out of all these systems and correlate it with pencil and Excel.

QRadar does this all automatically. The time savings is a real boost in productivity. Yet for all the functionality packed into the product, somehow Q1 Labs has managed to keep the interface clean and uncluttered. The main page is a dashboard I can customize with the feeds that matter to me. These feeds might be hosts at risk, number of attacks, top talkers, et cetera. The UI was very straightforward.

Performance is also up to snuff. QRadars pedigree includes Q1 Labs’ earlier network anomaly detection and monitoring tools, so that technology is rather mature. There are two options: netflow (switch taps) and qflow (software sniffers). If your equipment supports netflow, use it, because this option provides the best performance. Both options perform within the 200 packets per second range, and scale up to thousands of packets.

QRadar’s correlation engine is equally well developed. Forget doing analysis with a stack of printed logs and a sharpened pencil. This tool identifies known attacks quickly and has few false positives with the regular network traffic. There is also an ad hoc capability in the interface. I can specify specific content to look for, like somebody’s name, or a regular expression to match, like a credit card number. Then I can tell QRadar to look for events and packets that match, and pull back a report. QRadar can also return a packet capture that I can view in tools like Wireshark. This is handy for forensics after the attack has been detected and contained.

Of course, sometimes it is quicker to use the built-in reports. There are dozens to choose from. Each report can be ran on demand or scheduled. The output can be sent to the dashboard, saved as a file, or emailed out. This is very flexible and another time saver. Imagine, for example, running a report on failed logons every morning. This report then appears in your inbox. It can also be sent to a ticket tracking system for auditing purposes. It is very straight forward.

QRadar still has some rough spots. The product has a chimera feel produced from integrating log management and network management. The UI is inconsistent: some objects require clicks, some double-clicks, and others right-clicks. Which click is it? You often have to try all three to get the right result. The flexibility in reporting also leads to some odd results, as it is very easy to set up circular loops as you click thru reports for details. Yet these are minor details that will surely work themselves out as it evolves.

With TJX and co in the news, most security vendors that come calling this month will speak of how their solutions could have curbed the damage. The real acid test is time. How much longer will the information be protected? Alternatively, how much quicker will an attack be detected? Protection mechanisms can only provide partial security. Further, once breached, the exposure goes up dramatically with the amount of time an attacker has on your system. Detection tools are required to compensate for chinks in the armor and contain attacks. So ask the vendor the question, and check out their response.

The best response I have heard comes from Q1 Labs. If there is attack occurring on your systems, it will show up in QRadar first. Detection time drops significantly when network and host-based information is consolidated and correlated. Combining both the top-level overview, necessary for day-to-day management, with the deep-dive details, necessary for incident response and forensics, puts QRadar ahead of the pack.  QRadar is an excellent tool and its reporting and digital forensics capabilities will definitely improve an organization’s security posture.

Rolling your own SIM

Posted by

I have been looking at pay-to-play security information management tools. Reviewed Q1Labs Radar, Cisco Mars, and Novell’s offering. The costs are tad high, particularly when a lot of the basic collections I can do with WMI scripts and C# code.

OSSIM (Open Source Security Information Management) is another option that I am looking into. Or maybe I will roll my own. Here are the key tools:

Hosts:

Log monitoring: Kiwi syslog, Snare
Signature-based analysis: Nagios, OSSEC
Vulnerability assessments: Nessus

Networks:

Local monitoring: Arpwatch
Signature-based analysis: Snort
Statistical-based analysis: Spade

Correlation:

Splunk
SQL Server 2005 SSRS and SSAS

Code or configure? Where is the best return for my time? I wager rolling my own will be a good learning experience. The money saved can then be invested in training materials and resources. Further, any analysis and cleanup will not go to waste if I change course. An off-the-shelf SIM tool will plug into a cleaned up network just as easily as it would into a unmonitored network, if not easier. I am going to keep tinkering for the time being.

That sums up my thinking at the moment.

Perimeter-less Security and Clouds on the Horizon

Posted by

Cloud computing is similar to what the tech industry has been calling “on-demand” or “utility” computing, terms used to describe the ability to tap into computing power on the Web with the same ease as plugging into an electric outlet in your home. But cloud computing is also different from the older concepts in a number of ways. One is scale. Google, Yahoo!, Microsoft, and Amazon.com have vast data centers full of tens of thousands of server computers, offering computing power of a magnitude never before available. Cloud computing is also more flexible. Clouds can be used not only to perform specific computing tasks, but also to handle wide swaths of the technologies companies need to run their operations. Then there’s efficiency: The servers are hooked to each other so they operate like a single large machine, so computing tasks large and small can be performed more quickly and cheaply than ever before. A key aspect of the new cloud data centers is the concept of “multitenancy.” Computing tasks being done for different individuals or companies are all handled on the same set of computers. As a result, more of the available computing power is being used at any given time.”

Clouds are on the horizon. I know very few data centers that host everything internally. Most, including my own, deliver a mixture of desktop applications, client-server applications, and hosted (e.g., cloud) web apps. The shift has an immediate impact on security planning. Information security architectures began with terminal-server applications and focused on strong perimeters. With apps moving to the desktops, the perimeter became a little wider and a little more porous. But we could still control the information, by restricting what data was on the desktops and using technologies like end-point security. In fact, one might argue that many of our controls today are based around restricting information to the data center and keeping it off the desktops. The next major shift, which we are already starting to see, is moving the information from data centers to third-party hosting providers. This is only going to accelerate as young people, weaned on MySpace and Gmail,  join the workforce. Another accelerant which we may see in the next few years is another economic downturn. Both sociological and economical changes are moving the data from controlled perimeters to uncontrolled open spaces. The clouds on the horizon are coming nearer.

The open question is this: how do we build controls in an age of perimeter-less security?

Detecting information leakage in Windows Server

Posted by

Information leakage can occur when people with access to sensitive information copy the information to an insecure location. For example, a company’s financials may be stored on a file server. This server has restricted CIFS share permissions and restricted NTFS file system permissions. An employee with access copies these financials down and burns them to a CD. As there are no permissions or restrictions on the CD, anyone now has access to this sensitive information.

Detective controls exist in Windows Server and Windows XP to catch these types of situations.
Server-side

Simply setup SACL (system access control lists) permissions on the file server. Right-click the folder, choose Properties, click the Security tab and then click Advanced. On the Advanced dialog, click the Auditing tab and then click Edit. I recommend checking “List Folder / Read Data”, “Create Files / Write Data”, “Create Folders / Append Data”, and “Delete Subfolders and Files”. This will generate events in the Security logs when files are accessed. For example:

Event Type: Success Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
User: DOMAIN\username
Description:
Object Open:
Object Server: Security
Object Type: File
Object Name: \Device\HarddiskVolume20\Share\Sensitive Files\Financials.xls
Handle ID: 20492
Operation ID: {0,1917999625}
Process ID: 4
Image File Name:
Primary User Name: SERVER$
Primary Domain: DOMAIN
Primary Logon ID: (0x0,0x3E7)
Client User Name: username
Client Domain: DOMAIN
Client Logon ID: (0x0,0x6CEC6800)
Accesses: ReadData (or ListDirectory)
Client-side

The event log will now tell you when files are opened, copied, or modified by employees. Now watch the Window desktops to see what they are doing with these files.

The registry contains a wealth of information on external storage devices. Monitor the following keys to see if external devices are being attached.

Floppy disks – [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\FDC]
Firewire Devices– [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\sbp2]
IDE – [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\IDE]
SCSI – [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\SCSI]
USB – [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Enum\usbstor]

Monitor other registry keys to see what programs are being run. In particular, look for bulk copy utilities, backup programs, FTP clients, CD burners, and so on. Open the user’s registry file (ntuser.dat) and browse to:

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\UserAssist]

This UserAssist key will have several entries that represent recently used programs. Each entry is encoded (rot13) and formatted as follows: GUID, Index, ACTION, Session key, Number of times the app has executed, date time last executed.  The section you want is the action. Specifically, the UEME_RUNPAT<executable> entries.

 

In summary, enable SACL auditing on the Windows Servers and be prepared to spot-check Windows XP clients. By combining server-side auditing and client-side forensics, you will be able to curtail information disclosure.

Recover Office XP and Office 2003 passwords

Posted by

Excel and Word, as part of Microsoft Office XP or Office 2003, have an option to password protect the file. Sometimes you may need to recover a forgotten password, or to test the strength of a password.

I use the following free utility whenever I need to brute force these Office passwords:

http://www.freewordexcelpassword.com/

Free Word / Excel Password Recovery Wizard offers the same functionality and performance as expensive commercial Word password / Excel password software, but is a completely free download.  Unlike other supposedly “free” downloads, it is a full product, not a demo version or shareware. It contains no spyware or other malware.

We developed our own free password recovery package specifically to address the high cost of commercial password software.

Our easy to use software runs on any Windows 9x and later PC and recovers file open passwords (not sheet passwords though) for Word / Excel 97 to Word / Excel XP 2003 files.  It works by trying words from a large dictionary (included with the download) against the file, then tries character combinations to find most common file open passwords.