Update of Statistic table RSBKDTPSTAT?
I´d like to built a query, which will show me in the first step all inactive DTPs and in the next step all inactive IPs, too.
I found a table named RSBKDTPSTAT. There is a field named OBJSTAT, that will give me the needed information for DTPs.
Does anybody know, how often the table will be updated? How can I change the time interval?
Thanks for your help!
Florian Schwaiger replied
not sure whether it's still relevant for you but as it is an system table it should be updated at each change of a DTP. Even a change to an infoprovider or an transformation might update the table as a DTP might become inactive. So this information sould always be up to date.
But take care: it might be that some DTPs are listed in RSBKDTPSTAT but are not in the RSBKDTP at all. So for a complete list of inactive DTPs join both tables.
P.S.: assing points if this answer was useful for you