Endevor Filtering

karthi_ind · Posted: Wed Nov 04, 2009 11:55 am

Hi All,

Please explain me how to achieve this in endevor.

If I want to list out the elements particular to one date (Generate date) in endevor.
If you goto display option it will show the list of elements as below

element type environ system subsys version current Generate

aa cobs syst a b 1 01nov09 02nov09

In this I want to list out only the elements which has the Generate as 02nov09. There is a filter option in display like Apply list filter but we can filter only by CCID or proc group .

Let me know how to achieve for Generate date.

Regards
Karthik

kgrimes · Posted: Thu Nov 05, 2009 12:45 am

Hi Karthik,

Yes, Endevor has an EONLY command to filter a selection list by including or excluding rows that match the column filter value that you specify.

After you have built your selection list, enter the following command to include only the elements from the selection list that were generated on November 2, 2009: EONLY GEN 02NOV09

By the way, you can also use ESORT to sort a selection list by a specified column, such as: ESORT GEN to sort the selection list in ascending order by last generated date, or: ESORT -GEN to sort the selection list in descending order by the last generated date.

Kevin Grimes

karthi_ind · Posted: Thu Nov 05, 2009 12:25 pm

Thanks Kevin.

The command you mentioned is working. It is really helpful to me.
It is saving more time now.

karthi_ind · Posted: Thu Nov 05, 2009 12:30 pm

Hi Kevin,

Is there any other command which will save the output of selection listing to a dataset.

If you have any documents for endevor commands then please send it to me as it vll be really useful for me.

Thanks Kevin.

Karthik.

kgrimes · Posted: Thu Nov 05, 2009 11:07 pm

Hi Karthik,

Yes, Endevor also has a command to print a selection list to your ISPF listing data set. The command is EPRINT.

Sorry, due to licensing issues, I am not at liberty to share the CA Endevor manuals, but you could contact the Endevor Administrator or Endevor support person at your shop and ask them for the Endevor manuals.

Best Wishes,
Kevin

dick scherrer · Posted: Fri Nov 06, 2009 12:19 am

Hello,

If your site is licensed to use the product, all of the manuals may be downloaded for free from CA Support.

karthi_ind · Posted: Fri Nov 06, 2009 11:26 am

Thanks kevin and dick.

karthi_ind · Posted: Thu Nov 12, 2009 2:29 pm

Hi all,

With continuation of my earlier question...

I came to know that the field which I used for filtering Gendate is not the correct field. Actually my requirement is as follows

I need to send a list of elements everyday which has been modified, generated or moved to Unit and Syst regions on that particular date.
letz say today is 12th nov so I need to find out the list of elements
modified, generated or moved to syst and unit for 12th nov. But
the field Gendate is not showing the correct date. So I can't trust on this field.

If we give "M" option before the element then it will show another field DATE / TIME which is the correct field needs to be used for filtering. but this field is not showing in the initial list. Only if I give "M" it is showing this field.

Please help me out on how to achieve this in endevor. I am taking the list of elements using "M" option which is very much time consuming.

Thanks
Karthik

kgrimes · Posted: Thu Nov 12, 2009 7:21 pm

Hi karthi_ind,

If you are really looking to get a list of all elements that were processed on a given day, then you need to look at the SMF data, not the LAST ACTION data. It's possible that some elements can move more than a single stage in one day. Let's say an element moved up 3 stages in one day (not likely but possible in some cases), if you only look at the LAST ACTION information you would only see the information for the last move and you would not see any information for the move to the prior two stages. If it's one of the prior 2 stages that you are trying to list, then your list would not show this element because it has already moved on to another stage.

So a better solution is to look at the SMF data. Endevor CONRPT42 is an canned report that you can run against the SMF data to list all element activity for a given period. But you will probably have to check with your Endevor Administrator to get help setting up the batch job to your specifications.

If you want current inventory information as opposed to activity information, then there is a number of ways to get the current inventory information including some canned Endevor reports, the Endevor CSV utility, the Endevor API, and a sample batch job called BC1JAAPI.

Regards,
Kevin

karthi_ind · Posted: Fri Nov 13, 2009 2:34 pm

Thanks for your reply kevin.

Currently after filtering out the elements using CCID, which will list out all the elements in Syst and Unit, Iam giving "M" before each element and checking the DATE / TIME which has the correct date. As this list of elements is huge it is taking more time to check this.

Like the command EONLY is there any other command which will filter it out based on DATE/ TIME field. (which is displaying only if we give M before the element name)

kgrimes · Posted: Fri Nov 13, 2009 8:55 pm

Hi karthi_ind,

You can use PF10 and PF11 to display other columns of data. Then you can use the EONLY command with the columns displayed using the column name. I generally use the first 3 characters of the column name.

Regards,
Kevin

karthi_ind · Posted: Mon Nov 16, 2009 10:22 am

Hi Kevin,

I already tried with PF10 and PF11. But this particular column is not displaying and we can find this column only if we give "M" before the element name. Thanks.

kgrimes · Posted: Thu Nov 19, 2009 10:35 pm

Hi karthi_ind,

If the field that you want is not visible on any of the screen displays when you press the PF10 or PF11 keys, then obviously you can not use that field to filter your selection lists. The element information provided by the Endevor API and also the Endevor CSV utility is very extensive. So you can setup and run the Endevor CSV utility to get the desired information, or you could code your own program to get the information using the Endevor API. But don't forget, if you need a full accounting of all Endevor element activity in a given stage for a given duration, then the only way to get complete and accurate data is from the Endevor SMF reports or from the Endevor List SMF Data API or CSV utility - not from the current element information.

Best Wishes,
Kevin