A reader asked me to post a cfg file for the SQL example I referred to in my recent WMI on MRTG article. Here is the relevant entry from the MRTG cfg file on one of my database servers (named “DB01“):
Target[DB01.SQL.Connections.WMI]: `cscript //nologo \vbscripts\getSQL.vbs DB01`
Title[DB01.SQL.Connections.WMI]: SQL Current Connections (WMI)
Pagetop[DB01.SQL.Connections.WMI]: SQL Current Connections (WMI)
MaxBytes[DB01.SQL.Connections.WMI]: 10000
Options[DB01.SQL.Connections.WMI]: gauge, nopercent, growright, noo
YLegend[DB01.SQL.Connections.WMI]: Current Connections
ShortLegend[DB01.SQL.Connections.WMI]: Connections:
LegendI[DB01.SQL.Connections.WMI]: Connections:
Legend1[DB01.SQL.Connections.WMI]: Current Connections