Hi guys i hope everyone is well, question I need t...
# support
j
Hi guys i hope everyone is well, question I need to remove a service name in the filter this is not needed anymore 'local-host' the name of the service name in the logs page i already delete all logs. i tried this
Copy code
ALTER TABLE signoz_logs.logs_v2
DELETE WHERE resources_string['service.name'] = 'local-host';

ALTER TABLE signoz_traces.signoz_index_v2
DELETE WHERE serviceName = 'local-host';

ALTER TABLE signoz_metrics.time_series_v2
DELETE WHERE JSONExtractString(labels, 'service_name') = 'local-host';
but after this the service name 'local-host' is still displaying in the service name list. maybe someone knows how to remove it. Thank you
h
Brought up Network Inspector while the Query Builder is providing choices, and saw:
Copy code
GET /api/v3/autocomplete/attribute_values?aggregateOperator=noop&dataSource=logs&aggregateAttribute=&attributeKey=k8s.deployment.name&searchText=&filterAttributeKeyDataType=string&tagType=resource
Searched Github for that handler, followed the handler to the DB queries. You may want to check these other tables:
Copy code
defaultLogAttributeKeysTable   string        = "distributed_logs_attribute_keys"
	defaultLogResourceKeysTable    string        = "distributed_logs_resource_keys"
	defaultLogTagAttributeTableV2  string        = "distributed_tag_attributes_v2"
Since you seem to have access to your Clickhouse instance, you can always bring up the Signoz auto-complete then query Clickhouse's system.query_log to see how it got that data