Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

SQL queries for all docs, all objects etc.

ohidnas (TechnicalUser) (OP)
29 Aug 07 14:36
Hello,

We are using Livelink 9.5 SP1 and MS SQL 2000.

Our management is asking us to provide the following info from our livelink database:

1. Count of ALL objects
2. Count of ALL versions of ALL objects
3. Count of ALL documents
4. Count of ALL versions of ALL documents

Can somebody help with the queries to accomplish these?

Many thanks in advance.

Regards,
Ohid

appnair (Programmer)
29 Aug 07 19:24
Have you looked at any of the live reports that OT supplies out of the box and seen how you could tweak one of them ?

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

ohidnas (TechnicalUser) (OP)
30 Aug 07 8:17
appnair:

Thank you for replying. Yes, we have tweaked a few Live Reports and also our DBA helped us with queries. We also discussed it with OT.

But there seems to be some confusion about the results. The numbers are coming out quite low than the higher managements' expectations.

Therefore I posted here to find out if anybody else can help us with the queries I posted above.

Regards,
Ohid
appnair (Programmer)
30 Aug 07 12:30
You need to understand how livelink uses the schema.the schema is available to you when you sign an nda.The schema is IP of OT so one is not allowed in public forums like this to actually name the tables.

so if I wrote something like this

select count(*) from documentable(i know the right name but omitting it) where subtype=144 is akin to saying give me all documents in livelink.Perhaps your managment does not care about documents in
(projects,compound documents,workflow attachments,deleted volumes,personal workspaces and a whole lot of other container objects that can have a 144) so if there is a qn on number tallies you would want to explain how things are in the system.

Thru SQL you can alawys figure out the things too by putting suitable filters.

This seems to be a problesm I have encountered.If you count all the files in the files stem and try to co-relate the ones in livelink there might be problems

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

ohidnas (TechnicalUser) (OP)
30 Aug 07 12:58
appnair:

Thank you once again. OT did tell us to try with Sub Types (i.e. 144 etc.), and we are also doing it by Sub Types.

I guess we are doing it right and the numbers are real even though they appear to be low.

I appreciate your help.

Regards,
Ohid
ggriffit (Programmer)
30 Aug 07 19:17
If you want to know what the other subtypes are, then check out http://www.greggriffiths.org/livelink/reference/subtypes/ which is a very good list. If you spot any missing ones please let us know.

Greg Griffiths
Livelink Certified Developer & ECM Global Star  Champion 2005 & 2006
http://www.greggriffiths.org/livelink/

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close