<div>
<div class="content wysiwyg-content">
Hi could someone validate this SQL query for correctness against the Rapid7 database schema? &nbsp;I'm trying to pull a customized report of assets in my environment that have Adobe Acrobat and Reader installed on them. &nbsp;I'd like to pull the following fields down in my report: &nbsp;asset_count, vendor, name of software, family, version, host_name, osType and IP_address. &nbsp;Any help is GREATLY appreciated! <br />
<br />

<pre><code id="code-10-29167062-1">SELECT count(da.asset_id) as asset_count, ds.vendor, ds.name as software_name,  ds.family, ds.version, host_name, osType, ip_address
FROM dim_asset_software das
  JOIN dim_software ds using (software_id)
  JOIN dim_asset da on da.asset_id = das.asset_id
GROUP BY ds.vendor, ds.name, ds.family, ds.version, ds.cpe
ORDER BY asset_count DESC</code></pre>
</div>
</div>


Hi could someone validate this SQL query for correctness against the Rapid7 database schema?  I'm trying to pull a customized report of assets in my environment that have Adobe Acrobat and Reader installed on them.  I'd like to pull the following fields down in my report:  asset_count, vendor, name of software, family, version, host_name, osType and IP_address.  Any help is GREATLY appreciated! 

(CODE)

Rapid7:  Customized Report

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.

Security

A vulnerability is a weakness which allows an attacker to reduce a system's information assurance. Vulnerability is the intersection of three elements: a system susceptibility or flaw, attacker access to the flaw, and attacker capability to exploit the flaw. To exploit a vulnerability, an attacker must have at least one applicable tool or technique that can connect to a system weakness, known as the attack surface. Vulnerability management is the cyclical practice of identifying, classifying, remediating, and mitigating vulnerabilities. Other vulnerabilities include security risks, security defects and constructs in programming languages that are difficult to use properly.

Vulnerabilities

Network security consists of the policies adopted to prevent and monitor authorized access, misuse, modification, or denial of a computer network and network-accessible resources. Network security involves the authorization of access to data in a network, and covers a variety of computer networks; conducting transactions and communications among businesses, government agencies and individuals. Networks can be private, such as within a company, and others which might be open to public access.

Network Security

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.