Please before asking mention which version of BO are you using.. if i am not wrong you must be using XI R2 am I right ?
If you are using 3.1 you can easily use Query Results in CMC to check this out and export in .csv format
Edited by: Ravi Pai on May 13, 2010 11:35 AM
Thanks Ravi for your prompt response .
I am using version 3.1 sp2. As suggested by you I tried looking to create query under 'Query Result' but couldn't create any such query that can bring user list. I might be missing something here as I am new to 'QueryRresult'.
Pls let me know the right way of creating the desired query so that I can get the user list.
Thanks,
Chandra
I got the query now. I choose "Everone" in first section i.e. "Query Principal",in second section I selected "Don Not Quey by permission" and in last section i.e. "Query Context" I choose "Users" and this way I got the whole list of users including administrator and guest.
But, now when I am trying to take export of this output nothing is happening . It is not asking me any folder to store csv file.
Does it store the exported file to some default location??
Hi
After clicking the Export .
1.Go folders>administration tools folder
2.Right click on Administrator tools >Security query export >
3.Click on History
4 In the History tab ,you will see the program Object schedule(See screen shot2)
5.Now clicking on the Instance Time link will open a .txt file and shows you the rights
6. while saveing this file save as in CSV format.
If you want to see only users after saveing the csv , Just apply the filter on Rights collections check only system . It will dis play only the users.
Useing Query Builder also We can do
After Genrated the Report go to file and save as html in your local .
Select the HTML Page and Right click Open with Excel . The report will open in excel .
Hi Bhargav,
I am able to take excel output of user list by opening hlml file in excel (the second option that you had suggested).
Though it serve my purpose, still I am curious to know about the "Query result" option.
I could not find "Security query export" on right click on "Administrator Tools" folder. The only files that are present there are "Update Window AD Group Graph" and "Update Window AD Group Graph and Aliases". There is no other file available under the folder.
Would really appreciate if somebody help me to explore this option as well.
Thanks,
Chandra
HI Chandra,
you can find the admistration tools folder under the All folders. in side that folder you can see the Security Query Export Program object. Right click on that object see the History .
May be you deteled that object it comes with the bo Istalation. if you have anther environment please checkit there.
Hi Bhargav,
Thank you once again for the reply.
I found that program in one of our environment and successfully extracted the user list.
-Chandra
