Thank you Henrik
I see what you mean now.
________________________________
From: [email protected] [[email protected]] on behalf
of Henrik Andersen [[email protected]]
Sent: 27 August 2015 04:47 PM
To: [email protected]
Subject: [msmom] SV: Monitor in cookdown script is not changing state - Help
please
Sorry to have confused you.
Forget what I wrote in first mail.
In your monitor type, you have to replace the propertybag xpth quries with
‘Value’ like this
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="int">Value</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="int">1</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
/Henrik
Fra: [email protected] [mailto:[email protected]] På
vegne af Gareth Miles
Sendt: 27. august 2015 15:48
Til: [email protected]
Emne: [msmom] RE: Monitor in cookdown script is not changing state - Help please
Hi Henrik
I understand the “Value” is from the datagenericmapper, that makes sense to me.
The first data source use the timedscript.propertybagprovider module which
outputs propertybagdata
, the next module uses performance.datagenericmapper which transforms the
output to performance.data
The next datasource is used to filter out the jobs, this has to output
performance.data for the performance rule.
I’m a little lost as to how I would get property.bag output to the monitortype?
I’ve tried to re-write using a propertybag output, but I get problems with
datatype mismatch between the two data sources.
Am I missing something?
Thanks
Gareth
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Henrik Andersen
Sent: 27 August 2015 01:02 PM
To: [email protected]<mailto:[email protected]>
Subject: [msmom] SV: Monitor in cookdown script is not changing state - Help
please
Hi!
Yes I see want you want to accomplish. But if you take a look at the example of
the monitor creation (Especially bullet 5):
1. In the Choose Module Type box, select System.ExpressionFilter.
2. In the Module ID box, type FilterUnderThreshold. Click OK.
3. Click Configure to open the Expression dialog box.
4. Click Insert.
5. In the Parameter Name box type Value.
6. In the Operator box select Less than.
7. In the Value box type $Config/WarningThreshold$.
They use ‘Value’ but that’s not the property bag ‘Value’ but the Value that
comes from the System.Performance.DataGenericMapper.
So after all, it will be a minor change to you MP
/Henrik
Fra: [email protected]<mailto:[email protected]>
[mailto:[email protected]] På vegne af Gareth Miles
Sendt: 27. august 2015 12:41
Til: [email protected]<mailto:[email protected]>
Emne: [msmom] RE: Monitor in cookdown script is not changing state - Help please
Thanks for your input Venlig.
Can you clarify please?
The filtered data source will feed both the Rule and the monitorType.
The rule expects Performance data.
Do you mean to say that I need to have another data source between the filtered
data source and the MonitorType, in order to feed the monitortype with
propertybag data?
I based my setup on this article
https://technet.microsoft.com/en-us/library/ff381474.aspx
Thanks
Gareth
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Henrik Andersen
Sent: 27 August 2015 12:03 PM
To: [email protected]<mailto:[email protected]>
Subject: [msmom] SV: Monitor in cookdown script is not changing state - Help
please
Hi!
Your datasource has outputtype Performance!System.Performance.Data But your
monitortype expects property bag.
You have to have a datasource for Performance data and one for property bag.
You can define the script as propetype
/Henrik
Fra: [email protected]<mailto:[email protected]>
[mailto:[email protected]] På vegne af Gareth Miles
Sendt: 27. august 2015 11:48
Til: [email protected]<mailto:[email protected]>
Emne: [msmom] Monitor in cookdown script is not changing state - Help please
Hi
I have a cookdown vb script that gets property bag per SQL Instance, with a
collection of values for each SQL Job. I have a perf collection rule to collect
the “last completed run status” of the job, and I have a monitor to go healthy
if the lastrunstatus is 1 or 5, and critical if the lastrunstatus is 0.
The cookdown script collects the data as expected, and the rule is writing to
the DB as expected.
The monitor is not changing state though, it shows all the jobs as healthy,
although one is not.
It doesn’t seem to be picking up the value collected by the DataGenericMapper
module.
I’ve attached the management pack, this is what it consists of.
The Timed Script Property Bag Provider is hard coded with Interval and SynTime
as I didn’t want these overridden.
Data Source (To collect the data)
GarethCookDownSQLJob.VBScript
• (Data Source) Timed Script Property Bag Provider
• (Conditon Detection) Performance DataGenericMapper
Data Source (To Filter on the jobs)
GarethCookDownSQLJob.VBScriptFiltered
• (Data Source) GarethCookDownSQLJob.VBScript
• (Conditon Detection) System Expression Filter
MonitorType
• (Data Source) GarethCookDownSQLJob.VBScriptFiltered
• (Conditon Detection) System Expression Filter (Healthy)
• (Conditon Detection) System Expression Filter (Critical)
Monitor (To monitor Job Last Run Status)
Rule (To collect Job Last Run Status)
Any help would be appreciated
Kind Regards
[ITServiceAssurance_Logo (2)]
Gareth Miles
System Center Technical Lead
Phone: +27 31 580 1582
Mobile: +27 83 648 8559
________________________________
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please contact
the sender and delete the material from any computer.
Furthermore, the information contained in this message, and any attachments
thereto, is for information purposes only and may contain the personal views
and opinions of the author, which are not necessarily the views and opinions of
the company.
________________________________
________________________________
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please contact
the sender and delete the material from any computer.
Furthermore, the information contained in this message, and any attachments
thereto, is for information purposes only and may contain the personal views
and opinions of the author, which are not necessarily the views and opinions of
the company.
________________________________
________________________________
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please contact
the sender and delete the material from any computer.
Furthermore, the information contained in this message, and any attachments
thereto, is for information purposes only and may contain the personal views
and opinions of the author, which are not necessarily the views and opinions of
the company.
________________________________
#############################################################################################
The information transmitted is intended only for the person or entity to which
it
is addressed and may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking of any
action
in reliance upon, this information by persons or entities other than the
intended
recipient is prohibited. If you received this in error, please contact the
sender and
delete the material from any computer.
Furthermore, the information contained in this message, and any attachments
thereto, is
for information purposes only and may contain the personal views and opinions
of the
author, which are not necessarily the views and opinions of the company.
#############################################################################################
