{"files":{"SKILL.md":"---\nname: sqlmanagementclient\ndescription: \"SqlManagementClient API skill. Use when working with SqlManagementClient for subscriptions. Covers 12 endpoints.\"\nversion: 1.0.0\ngenerator: lapsh\n---\n\n# SqlManagementClient\nAPI version: 2017-03-01-preview\n\n## Auth\nOAuth2\n\n## Base URL\nhttps://management.azure.com\n\n## Setup\n1. Configure auth: OAuth2\n2. GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings/{blobAuditingPolicyName} -- gets an extended database's blob auditing policy.\n3. Explore available endpoints below\n\n## Endpoints\n12 endpoints across 1 group. See references/api-spec.lap for full details.\n\n### Subscriptions\n| Method | Path | Description |\n|--------|------|-------------|\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings/{blobAuditingPolicyName} | Gets an extended database's blob auditing policy. |\n| PUT | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings/{blobAuditingPolicyName} | Creates or updates an extended database's blob auditing policy. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings | Lists extended auditing settings of a database. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/extendedAuditingSettings/{blobAuditingPolicyName} | Gets an extended server's blob auditing policy. |\n| PUT | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/extendedAuditingSettings/{blobAuditingPolicyName} | Creates or updates an extended server's blob auditing policy. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/extendedAuditingSettings | Lists extended auditing settings of a server. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings/{blobAuditingPolicyName} | Gets a server's blob auditing policy. |\n| PUT | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings/{blobAuditingPolicyName} | Creates or updates a server's blob auditing policy. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings | Lists auditing settings of a server. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingSettings/{blobAuditingPolicyName} | Gets a database's blob auditing policy. |\n| PUT | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingSettings/{blobAuditingPolicyName} | Creates or updates a database's blob auditing policy. |\n| GET | /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingSettings | Lists auditing settings of a database. |\n\n## Common Questions\nMatch user requests to endpoints in references/api-spec.lap. Key patterns:\n- \"Get extendedAuditingSetting details?\" -> GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings/{blobAuditingPolicyName}\n- \"Update a extendedAuditingSetting?\" -> PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings/{blobAuditingPolicyName}\n- \"List all extendedAuditingSettings?\" -> GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings\n- \"Get auditingSetting details?\" -> GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings/{blobAuditingPolicyName}\n- \"Update a auditingSetting?\" -> PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings/{blobAuditingPolicyName}\n- \"List all auditingSettings?\" -> GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings\n- \"How to authenticate?\" -> See Auth section above\n\n## Response Tips\n- Check response schemas in references/api-spec.lap for field details\n- Create/update endpoints return the modified resource on success\n\n## References\n- Full spec: See references/api-spec.lap for complete endpoint details, parameter tables, and response schemas\n\n> Generated from the official API spec by [LAP](https://lap.sh)\n","references/api-spec.lap":"@lap v0.3\n# Machine-readable API spec. Each @endpoint block is one API call.\n@api SqlManagementClient\n@base https://management.azure.com\n@version 2017-03-01-preview\n@auth OAuth2\n@common_fields {resourceGroupName: any # The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal., serverName: any # The name of the server., subscriptionId: any # The subscription ID that identifies an Azure subscription., api-version: any # The API version to use for the request.}\n@endpoints 12\n@toc subscriptions(12)\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings/{blobAuditingPolicyName}\n@desc Gets an extended database's blob auditing policy.\n@required {databaseName: any # The name of the database., blobAuditingPolicyName: any # The name of the blob auditing policy.}\n@returns(200) Successfully retrieved the extended database blob auditing policy.\n\n@endpoint PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings/{blobAuditingPolicyName}\n@desc Creates or updates an extended database's blob auditing policy.\n@required {databaseName: any # The name of the database., blobAuditingPolicyName: any # The name of the blob auditing policy., parameters: map # The extended database blob auditing policy.}\n@returns(200) Successfully set the extended database blob auditing policy.\n@returns(201) Successfully created the extended database blob auditing policy.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extendedAuditingSettings\n@desc Lists extended auditing settings of a database.\n@required {databaseName: any # The name of the database.}\n@returns(200) Successfully retrieved the database extended auditing settings.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/extendedAuditingSettings/{blobAuditingPolicyName}\n@desc Gets an extended server's blob auditing policy.\n@required {blobAuditingPolicyName: any # The name of the blob auditing policy.}\n@returns(200) Successfully retrieved the extended server blob auditing policy.\n\n@endpoint PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/extendedAuditingSettings/{blobAuditingPolicyName}\n@desc Creates or updates an extended server's blob auditing policy.\n@required {blobAuditingPolicyName: any # The name of the blob auditing policy., parameters: map # Properties of extended blob auditing policy}\n@returns(200) Successfully updated the extended auditing settings.\n@returns(202) Updating the extended auditing settings is in progress.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/extendedAuditingSettings\n@desc Lists extended auditing settings of a server.\n@returns(200) Successfully retrieved extended server auditing settings.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings/{blobAuditingPolicyName}\n@desc Gets a server's blob auditing policy.\n@required {blobAuditingPolicyName: any # The name of the blob auditing policy.}\n@returns(200) Successfully retrieved the server blob auditing policy.\n\n@endpoint PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings/{blobAuditingPolicyName}\n@desc Creates or updates a server's blob auditing policy.\n@required {blobAuditingPolicyName: any # The name of the blob auditing policy., parameters: map # Properties of blob auditing policy}\n@returns(200) Successfully updated the auditing settings.\n@returns(202) Updating the auditing settings is in progress.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/auditingSettings\n@desc Lists auditing settings of a server.\n@returns(200) Successfully retrieved server auditing settings.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingSettings/{blobAuditingPolicyName}\n@desc Gets a database's blob auditing policy.\n@required {databaseName: any # The name of the database., blobAuditingPolicyName: any # The name of the blob auditing policy.}\n@returns(200) Successfully retrieved the database blob auditing policy.\n\n@endpoint PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingSettings/{blobAuditingPolicyName}\n@desc Creates or updates a database's blob auditing policy.\n@required {databaseName: any # The name of the database., blobAuditingPolicyName: any # The name of the blob auditing policy., parameters: map # The database blob auditing policy.}\n@returns(200) Successfully set the database blob auditing policy.\n@returns(201) Successfully created the database blob auditing policy.\n\n@endpoint GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/auditingSettings\n@desc Lists auditing settings of a database.\n@required {databaseName: any # The name of the database.}\n@returns(200) Successfully retrieved database auditing settings.\n\n@end\n"}}