Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Auditing users

hi

i have a script that runs in BO to audit users list, and it ran fine until it exceed 1000 rows and i get this error :

(The program failed to run and supplied the following information, crystalEnterprise 115. FW_InfoObjects.1: Item 1001 was not found in the collection.)24:4,

is there a way of increasing the limit to over a thousand or unlimited.

here is the script:

// Get user list

var IInfoStore;

var resultquery;

var users;

IInfoStore = Session.Service("", "InfoStore");

ResultQuery = "SELECT SI_NAME, SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_KIND='User'"

Users = IInfoStore.Query(ResultQuery);

var rowcount;

var i;

rowcount=Users.ResultCount;

for(i=1; i <= rowcount; i++)

{

var line;

var info;

var dquote;

info = Users.Item(i);

line = '"' + info.Title + '"';

Script.WriteLn(line);

}

Thanks

Former Member
Former Member replied

Try

ResultQuery = "SELECT TOP 10000 SI_NAME, SI_ID FROM CI_SYSTEMOBJECTS WHERE SI_KIND='User'"

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question