Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
claymen wrote:The most stable is the latest version. Without it you can't do some of the graphs and it also means less hassle with escaping input.
0.0.6 is the latest "stable" version, not sure why you would have problems with it unless your templates were not setup properly or you were migrating from an older version without taking into account a few of the changes.
The included templates in the 0.0.6 package work like a charm on 0.8.7b, which is absolutely great. Only the EVA templates from http://forums.cacti.net/about29895.html don't seem to work on 0.0.6. Could be because I've converted the templates from 0017 to 0016 (0.8.7c to 0.8.7b) though. If someone has adapted these templates or can create EVA performance templates to work for cacti-wmi 0.0.6 and cacti 0.8.7b please let us know.
It would be so cool to be able to have an option to select the EVA, disk group and stats to graph.
Would make this myself, but wouldn't know where to start...
How do I modify that command (via namespace, filter, filter value) so that it only returns DataFilesSizeKB1, LogFilesSizeKB1, and LogFilesUsedSizeKB1 for graphing?
stormonts wrote:
How do I modify that command (via namespace, filter, filter value) so that it only returns DataFilesSizeKB1, LogFilesSizeKB1, and LogFilesUsedSizeKB1 for graphing?
I believe you can use the -k option to specify the variable you want to select on and with -v the contents of that variable like this:
You are correct, by not specifying which actual value you are filtering for it simply returns everything. Which can work it just means your data input method is going to be gigantic. However this can also be useful in a couple of cases
Usage:
-h <hostname> Hostname of the server to query.
-u <credential path> Path to the credential file. See format below.
-n <namespace> What namespace to use. (optional, defaults to root\CIMV2)
-w <wmi class> WMI Class to be used.
-c <columns> What columns to select. (optional, defaults to *)
-k <filter key> What key to filter on. (optional, default is no filter)
-v <filter value> What value for the key. (required, only when using filter key)
-d <debug level> Debug level. (optional, default is none, levels are 1 & 2)
All special characters and spaces must be escaped or enclosed in single quotes!
Ideally you would structure your data input and data template such that you specify the DB name and it returns only the DataFilesSizeKB,LogFilesSizeKB,LogFilesUsedSizeKB for that one database. That way your data input method will always see the same set of values and you can then simply bang the template onto your host and add each DB as a data source. You could also go the step further and allow the actual class to be specified per data source (with a default set of course) so that your template can be reused on other hosts where the namespace is different
The problem is, Scriptomatic doesn't find a Win32_PerfRawData_MSSQLSERVER... class on the server. I tried to run wmiadap /f and then rebooted the server, but it didn't fix it.
The problem is, Scriptomatic doesn't find a Win32_PerfRawData_MSSQLSERVER... class on the server. I tried to run wmiadap /f and then rebooted the server, but it didn't fix it.
Does Scriptomatic find any SQL classes? They can use a different name if using named instances. Or just different installs etc.
It finds a number of SQL classes for each instance. I wanted the SQL performance graph to show the total performance across all instances and not just on a instance by instance basis.
stormonts wrote:It finds a number of SQL classes for each instance. I wanted the SQL performance graph to show the total performance across all instances and not just on a instance by instance basis.
Is that even possible in perfmon? If not then I doubt WMI can do it as its calling the same data.
stormonts wrote:It finds a number of SQL classes for each instance. I wanted the SQL performance graph to show the total performance across all instances and not just on a instance by instance basis.
Is that even possible in perfmon? If not then I doubt WMI can do it as its calling the same data.
Was the template/graph written assuming people would only have 1 default instance?
stormonts wrote:It finds a number of SQL classes for each instance. I wanted the SQL performance graph to show the total performance across all instances and not just on a instance by instance basis.
Is that even possible in perfmon? If not then I doubt WMI can do it as its calling the same data.
Was the template/graph written assuming people would only have 1 default instance?
Sort of, we only really had one instance per server. So for us its not too much of an issue, but to support extra instances you just need to tick the box to make the class user adjustable. Then when you add it to hosts you can edit the class if its a different instance.
No idea mate it shouldn't make any difference. We use SQL 2008 64bit and it works fine, I would say something is broken to do with the WMI classes not being registered correctly.
