Viewpoint filters

[mauriziog]

You cant use variables in view points....

[RoHoe]

We do it like this :

Run a job -executing the script beneath- each day before the NDP:

update ecs.filtermatchings
set fieldvalue = to_char(sysdate-1,'YYMMDD')
where name = 'previous odate' and fieldname = 'ODATE';
commit;

Make sure filter 'previous odate' is created once manually.

After this you can create a viewpoint with the filter above.

Grtz, RoHoe.

[RoHoe]

Forgot to mention something :

Define your filter previous odates like this :

Odate != 080715 (date updated by the query in my previous post)
Deleted = false (optional)
Job status != Ended ok (optional)


Robie.

[arno76]

We do it like this :

Run a job -executing the script beneath- each day before the NDP:

update ecs.filtermatchings
set fieldvalue = to_char(sysdate-1,'YYMMDD')
where name = 'previous odate' and fieldname = 'ODATE';
commit;

Make sure filter 'previous odate' is created once manually.

After this you can create a viewpoint with the filter above.

Grtz, RoHoe.

hello,

sorry but can you explain a little bit more?
ecs.filtermatchiing is a table fro EM?

Must we run this job on all Em server?

is there a BMC doc on this?

thanks