Closed arunpaladin closed 1 month ago
The recent updates streamline database entries in the DB.sql
and DB_Policy.sql
files, enhancing data integrity and policy management. Key modifications include status changes for a specific entry in cf_Target
and removal, as well as updates to resolutionUrl
in cf_PolicyTable
to keep security center tagging rules current.
File Path | Change Summary |
---|---|
installer/resources/pacbot_app/files/DB.sql |
Updated cf_Target table entry: changed status to 'finding' and added on DUPLICATE key update clause. |
installer/resources/pacbot_app/files/DB_Policy.sql |
Removed INSERT statement for a security center tagging rule; updated resolutionUrl for several policies; changes in cf_PolicyParams . |
In data's dance so calm and bold,
Changes weave their tale untold.
With status 'finding', keys align,
Policies trace a clearer line.
Amidst the tables' structured flow,
Pacbot's guidance starts to grow.
Thank you for using CodeRabbit. We offer it for free to the OSS community and would appreciate your support in helping us grow. If you find it useful, would you consider giving us a shout-out on your favorite social media?
⚠️ DELETE statement found in the changes of SQL files. Requesting review from @santhosh and @arun.
Issues
0 New issues
0 Accepted issues
Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code
Description
Removed Security Center tagging Policy and updated the target type to finding. Added script in the JIRA# CORE-2059 for closing the existing violations.
Problem
Solution
After code change.
Security Center Asset type is removed from distribution list
Fixes # (issue if any)
Type of change
Please delete options that are not relevant.
How Has This Been Tested?
Please describe the tests that you ran to verify your changes. Provide instructions so we can reproduce. Please also list any relevant details for your test configuration
Checklist:
Other Information:
List any documentation updates that are needed for the Wiki
Summary by CodeRabbit
Bug Fixes
status
to 'finding' for thesecuritycenter
entry incf_Target
table to reflect accurate status updates.Improvements
resolutionUrl
for multiple policies to provide more accurate resolution paths.INSERT
statement for a security center tagging rule to ensure database integrity.Database Management
cf_PolicyParams
table with updated values for different tagging rules to improve policy parameter management.