Query for Bobj query tool to find the pinned reports of Bo User in BO-Launchpad

[wobi]

Can anyone post a query tool sql to find the following info:

List of Users pinned >Reports in the Launchpad Bo 4.x

😉

I am sure it exists - but since it was not migrated - some users don't even know what they had pinned up but they are sure they dearly miss this information 😉

- Wobi

[wobi]

Thank you -it seems that the info I am lookin for is stored in the SerializedTabs!

wobi

[TJe]

Hi Wobi,

this information is stored with the user InfoObject. Here a sample query.

select si_id, si_name, SI_RECENT_DOCUMENTS from ci_systemobjects where si_kind='user' and si_name in ('Administrator')

regards
Thomas