当我们使用文本文件收集器导出度量时，WMI Exporter在尝试抓取度量时出错

Question

wmi_textfile_scrape_error如果打开或读取文件时出错，则为1，否则为0

import pyodbc
import os
import sys
conn = pyodbc.connect('Driver={SQL Server};'
'Server=win-bk9m8;'
'Database=metric-db;'
'UID=sa;'
'PWD=password;')
cursor = conn.cursor()
count1 = cursor.execute("select count(*) from MissedEvents  where  TenantId > 10 and remarks like 'Mandatory%' AND RowCreatedDate >= dateadd(hh, -2, getdate())")
mandatory_items_missing_count = count1.fetchone()[0]
remarkname = "mandatory-items-missing"
#print(mandatory_items_missing_count)
print('# HELP missedevents_table_remarks {0}'.format(remarkname))    
print('# TYPE missedevents_table_remarks gauge' )
print('missedevents_table_remarks{{remark_type="{0}"}} {1}' .format(remarkname, mandatory_items_missing_count))```

Answer 1

在wmi导出器服务上启用调试后，我发现错误是由于输入流意外结束；我已经在上面的脚本中添加了换行符并修复了错误。