Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



PM Generation - Filter

From: John Ballnik (2012-04-20 08:05)

Hi Gang,
We would like to automate the PM Generation Cron Job.  Do you know if there is a way to set this up so we only generate a subset of PM records?  For instance, I would only like PMs where type = 'IT'
thanks,
John


From: in2data (2012-04-20 15:32)

Hi,
Open your Organizations application and go to any tab other than the list.
Then Select Action > PM Options > Stand-alone PM Work Order Generation Process Settings.
In the where clause put in a query to filter for just the PMs you want the cron task to use. For instance to reduce the time the cron task takes I've filtered the PMs for just those that are due within the number of days forward the task runs. For most sites that is the date plus 45 days. The query I use is below.
status = 'ACTIVE' and siteid = 'WR'
and nextdate - IsNull(leadtime,0) - 45 <= getdate()
You can put a query in for each site in your organization and they can be different queries.
Dave Bone
--- In MAXIMO@yahoogroups.com, John Ballnik <jballnik@...> wrote:
>
> Hi Gang,
>
> We would like to automate the PM Generation Cron Job.  Do you know if there is a way to set this up so we only generate a subset of PM records?  For instance, I would only like PMs where type = 'IT'
>
> thanks,
> John
>
>
>
>