I would like to create automated deski report which I can schedule and result would give me:
userNameA;accountNameA;groupA;groupB…etc
userNameB;accountNameB;groupA;groupB…etc
…
etc
Right now I can get this info through query builder
SELECT SI_NAME, SI_ID, SI_USERGROUPS, SI_USERFULLNAME FROM CI_SYSTEMOBJECTS Where SI_KIND=‘User’
SELECT SI_NAME FROM CI_SYSTEMOBJECTS Where SI_ID=
tannx 
(BOB member since 2006-02-20)
Do a search in the BO Downloads section on this forum and you will find a bit of Java code that will do this for you.
plessiusa 
(BOB member since 2004-03-22)
Which download do you refer? I havent found any java script that I can schedule and get needed result.
tannx (BOB member since 2006-02-20)
Check this post
You will have to enhance the code to get additional desired columns
.
haider 
(BOB member since 2005-07-18)
Yep this is the code I was thinking of, sorry I thought it was in the BOB downloads, maybe it should be???
plessiusa (BOB member since 2004-03-22)
I know this code is taken from BO dev library.
I’m unable to attach users with groups.
tannx (BOB member since 2006-02-20)
I dont think you can get them in one single query
Neither the query builder nor the VB macro link provided earlier will work since QB does not support subqueries etc
You may have to use CMS SDK to get the required info, search SDK forum for more details
.
haider (BOB member since 2005-07-18)