Object Creation Count - Not in Personal Workspace - SQL

David_Miehl

Good morning,

I am looking to create a report to count the number of objects created by users (using a date range) that were created anywhere but their Personal Workspace.  The initial part of this report is pretty basic, but has anyone had any success creating a report omitting all of the objects in users Personal Workspaces?

Thank you.

Dave

Appu_Nair

PWS are livelink objects that is termed as volume objects.Livelink has a lot of volumes

A volumes parentid=-1 so that is a clue to find all volumes

So if a user is getting created and if livelink allots the user this id 81972

then his PWS will have that dataid and its ownerid will be -(NEGATIVE) that ID.

Also the ownerid is important because everything in a volume will have that

so this is the query to find everything in that user's PWS

select dataid,name,subtype,parentid,ownerid from dtree where ownerid=-81972

So if you do not want this users to be reported it will be

where ownerid not equal to in(List of userid's each prefixed with a negative )

I wrote that as english correct it to SQL

I hope you know how to find user's in livelink if not it is

select id from kuaf where deleted=0 and type=0

if you negativize that

select -(id),name from kuaf where deleted=0 and type=0

that will be the ownerid's in dtree whose item's you do not like