How can I export users which have instance in Infoview?

[system]

How can I use Query Builder to export users,and these users should have instance in Infoview. I use the SQL syntax in Query Builder:
select top 100000 si_name from ci_systemobjects where si_kind=‘User’ and si_instance is not null

but after I submit query,I can get all the users,I’m not sure whether the result is right and whether all the users have instances.could you help me?Thank you in advance.

---

liuhuixue (BOB member since 2011-09-07)

[system]

Hi Try if this excel can help you out with any information in the link

BOXI Repository Documentor

I have created the attached spreadsheet for XI R3 which will retrieve information about the reports, Universes, connections and categories in the BOXI environment. It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too - as returned when querying via the query builder. It should be ran under the administrator account for the best results, but also works for delegated administrators/users. The first tab has a secti…

---

kolla_ashok (BOB member since 2006-11-02)

[system]

Thank you.

It can’t be used, Compile error:can’t find project or library

---

liuhuixue (BOB member since 2011-09-07)