Item count by type

Hi allI was wondering if anyone could help.I would like a report to count the number of items in our enterprise area of livelink and then a breakdown on the number of items by type e.g. folder, alias, document etc.ThanksDavid.

Find more posts tagged with

Comments

Simon_Beal

Message from Sean O'Callaghan via eLinkHi if you what to know info about the first level of the enterpriseworkspace then this should work.select subtype, count(Subtype)"Number of Items" from dtree whereparentid = '2000' group by subtypeIf you want to perform the same query to all of the enterprise and it'ssubfolders then that requires a lot more work.Sean -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 10 September 2004 10:29To: eLink RecipientSubject: Item count by typeItem count by typePosted by OPENUNIVUser2 on 09/10/2004 05:25 AMHi allI was wondering if anyone could help.I would like a report to count the number of items in our enterprisearea of livelink and then a breakdown on the number of items by typee.g. folder, alias, document etc.ThanksDavid.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe********************************************************************************This e-mail is confidential to the ordinary user of the e-mail addressand may also be privileged. If you have received it in error, pleasenotify us immediately by reply e-mail and then delete this message fromyour system. Please do not copy it or use it for any purposes, or disclose its contents to any person. Please contact our IT Departmenton +44 (0) 020 7592 0600 or e-mail at it@angeltrains.com if you needassistance. Angel Trains Limited - Portland House Stag Place VictoriaLondon SW1E 5BH Tel: 020 75920500 Fax: 020 75920519 Registered in England No 2912655www.angeltrains.com**********************************************************************************

David_Turpie

Thanks for this.I do actually need the whole of enterprise though.David

Simon_Beal

Message from Sean O'Callaghan via eLinkAre you running SQL or Oracle, and how big is your repository?Sean -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 10 September 2004 13:43To: eLink RecipientSubject: [Maybe Spam] Thanks for this.Thanks for this.Posted by OPENUNIVUser2 on 09/10/2004 08:41 AMThanks for this.I do actually need the whole of enterprise though.David[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Item count by typehttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3677979&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe********************************************************************************This e-mail is confidential to the ordinary user of the e-mail addressand may also be privileged. If you have received it in error, pleasenotify us immediately by reply e-mail and then delete this message fromyour system. Please do not copy it or use it for any purposes, or disclose its contents to any person. Please contact our IT Departmenton +44 (0) 020 7592 0600 or e-mail at it@angeltrains.com if you needassistance. Angel Trains Limited - Portland House Stag Place VictoriaLondon SW1E 5BH Tel: 020 75920500 Fax: 020 75920519 Registered in England No 2912655www.angeltrains.com**********************************************************************************

David_Turpie

We are running SQL not sure of the size of the repository but it isn't that big as we ave just started putting content into the Enterprise workspace.David

Bhupinder_Singh

Message from Bhupinder Singh via eLinkWhy not just run a system report using the instructions below? It willcontain a section that has what you are looking for, showing the numberof items of a given type of object system wide, and will appear similarto this:Node Types Info: Name SubType Number of Items ------------------------------------------------- Alias 1 10 Category 131 15 Channel 207 3 CompoundDoc 136 16 Discussion 215 2 Document 144 100 etc.Generating a System Report (Livelink version 8.1.5 onwards)1. Log in as Admin2. Edit the Livelink URL after the part 'livelink.exe' so that it is: ...../livelink.exe?func=admin.sysreport3. After the report is generated, it will display in the browser window.It is also saved as sysreport.txt in the [Livelink install path]/logssubdirectory on the Livelink server.- Bhupinder------------------------------------------------------------------------- Bhupinder Singh, B.Math., B.Ed. Senior Product Specialist, Customer Support Open Text Corporation, Waterloo, Ontario, Canada Customer support e-mail: support@opentext.com Customer Support Telephone: 800-540-7292 ------------------------------------------------------------------------- -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Friday, September 10, 2004 5:29 AMTo: eLink RecipientSubject: Item count by typeItem count by typePosted by OPENUNIVUser2 on 09/10/2004 05:25 AMHi allI was wondering if anyone could help.I would like a report to count the number of items in our enterprisearea of livelink and then a breakdown on the number of items by typee.g. folder, alias, document etc.ThanksDavid.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Simon_Beal

Message from Sean O'Callaghan via eLinkWell in that case I have acquired a stored procedure that may help butit requires creating additional tables etcIf you just want to know all the folder/documents etc then you can run asysreport....have you tried that? Sean-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 10 September 2004 14:14To: eLink RecipientSubject: We are running SQL not sure of the size of the repository butit isn't that big...We are running SQL not sure of the size of the repository but it isn'tthat big...Posted by OPENUNIVUser2 on 09/10/2004 09:12 AMWe are running SQL not sure of the size of the repository but it isn'tthat big as we ave just started putting content into the Enterpriseworkspace.David[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Item count by typehttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3677979&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe********************************************************************************This e-mail is confidential to the ordinary user of the e-mail addressand may also be privileged. If you have received it in error, pleasenotify us immediately by reply e-mail and then delete this message fromyour system. Please do not copy it or use it for any purposes, or disclose its contents to any person. Please contact our IT Departmenton +44 (0) 020 7592 0600 or e-mail at it@angeltrains.com if you needassistance. Angel Trains Limited - Portland House Stag Place VictoriaLondon SW1E 5BH Tel: 020 75920500 Fax: 020 75920519 Registered in England No 2912655www.angeltrains.com**********************************************************************************

Steve_McDonough

You might use the DVersdData table to get the report. I use this simple MSSQL in a report:SELECT FILETYPE, COUNT(*) FROM DVERSDATA GROUP BY FILETYPE ORDER BY COUNT(*) DESCHope it helps!Leon