---
title: "获取管控sql列表"
method: GET
path: "/v2/projects/{project_name}/sql_manages"
tags: ["SqlManage"]
deprecated: true
---

# 获取管控sql列表

`GET /v2/projects/{project_name}/sql_manages`

> **Deprecated.**

get sql manage list

## Path parameters

- `project_name` string, required

## Query parameters

- `fuzzy_search_sql_fingerprint` string
- `filter_assignee` string
- `filter_instance_id` string
- `filter_source` 'audit_plan' | 'sql_audit_record'
- `filter_audit_level` 'normal' | 'notice' | 'warn' | 'error'
- `filter_last_audit_start_time_from` string
- `filter_last_audit_start_time_to` string
- `filter_status` 'unhandled' | 'solved' | 'ignored' | 'manual_audited' | 'sent'
- `filter_rule_name` string
- `filter_db_type` string
- `filter_business` string
- `filter_by_environment_tag` string
- `filter_priority` 'high' | 'low'
- `fuzzy_search_endpoint` string
- `fuzzy_search_schema_name` string
- `sort_field` 'first_appear_timestamp' | 'last_receive_timestamp' | 'fp_count'
- `sort_order` 'asc' | 'desc'
- `page_index` integer, required
- `page_size` integer, required

## Response `200`

OK

---

[API](https://skmtc.net/actiontech/apis/sqle-api-docs.md) · [All operations](https://skmtc.net/actiontech/apis/sqle-api-docs/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/actiontech/sqle-api-docs/versions/704d73f5c092/schema)