How to see bookmark size

[giakoum]

Hi.

I have a user that created a huge bookmark (selected 1m customer names) and thus the shared file quadrupled in size. How can I find out which user or which bookmark id this is?

[giakoum · Accepted solution]

This is how it can be done :

CUSTOM CONNECT TO "Provider=QvServerObjectConnector.exe;Folder=<your public data folder>;XUserId=<your user>;XPassword=<your password>;";

Objects:

SQL SELECT

  FileName,

    ID,

    ObjectHidden,

    ObjectLength,

    ObjectTemporary,

    ObjectShared,

    ObjectType,

    ObjectUser

FROM Objects;

ObjectLength is the bookmark size if ObjectType is Bookmark