1 Reply Latest reply: Mar 13, 2015 7:51 AM by ioannis giakoumakis RSS

    How to see bookmark size

    ioannis giakoumakis

      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?

        • Re: How to see bookmark size
          ioannis giakoumakis

          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