You cant use variables in view points....
Viewpoint filters
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.
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,RoHoe wrote: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.
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