nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need to report on all reports

AFRL_5_Shared_Account_User

I would like to generate a report that shows me what all of the reports (parameters, sql queries etc.) are within our system. This will help our admin keep tabs on everyone with access to livereports. Has anyone had to do this - or can anyone tell me where the reports are actually stored?Thanks.--Cory

Find more posts tagged with

Comments

EdwardAFBUser3_(Delete)_1421456

Message from Huie Kenneth L Contr 452 FLTS/DOE via eLinkGreetings fellow AF comrade,The Reports Volume holds the system Livelink Reports:http(s)://INSERTSERVERADDRESS/livelink/livelink.exe?func=ll&objId=2002As well, to find individual reports try creating a Live Report searching onitem Subtype type 299(aka Object Type). After you establish your baselineadd date parameters to the report and only search by reports created withina date range "last week" for example.Ken HuieTYBRIN452FLTS/ABLADMS Livelink AdminEdwards AFB5-0651-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, August 16, 2005 3:25 PMTo: eLink RecipientSubject: Need to report on all reportsNeed to report on all reportsPosted by AFRLUser5 on 08/16/2005 11:50 AMI would like to generate a report that shows me what all of the reports(parameters, sql queries etc.) are within our system. This will help ouradmin keep tabs on everyone with access to livereports. Has anyone had todo this - or can anyone tell me where the reports are actually stored?Thanks.--Cory[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

AFRL_5_Shared_Account_User

Thank you for your help.--CoryCory BeimescheAFRL/DIBCRM AdminWright-Patterson AFB5-1254

Lindsay_Davies

Message from Lindsay Davies via eLinkHi,All of the details of the Livereport are stored in the ExtendedDatacolumn in DTree - it is a long datatype, so not very handy from a nativeSQL viewpoint.I suggest you visit the Admin.Index page and click Export LiveReports -manually select every report listed and click the Export button. Thisautomatically offers all the reports that exist.That will present all the report parameters in a text file which you canimport into Excel (or an editor of your choice) to manipulate.Good luck.LindsayOpenText UK Support-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 17 August 2005 05:06To: eLink RecipientSubject: RE Need to report on all reportsRE Need to report on all reportsPosted by EdwardAFBUser3 on 08/17/2005 12:05 AMMessage from Huie Kenneth L Contr 452 FLTS/DOE via eLinkGreetings fellow AF comrade,The Reports Volume holds the system Livelink Reports:http(s)://INSERTSERVERADDRESS/livelink/livelink.exe?func=ll&objId=2002As well, to find individual reports try creating a Live Report searchingon item Subtype type 299(aka Object Type). After you establish yourbaseline add date parameters to the report and only search by reportscreated within a date range "last week" for example.Ken HuieTYBRIN452FLTS/ABLADMS Livelink AdminEdwards AFB5-0651-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Tuesday, August 16, 2005 3:25 PMTo: eLink RecipientSubject: Need to report on all reportsNeed to report on all reportsPosted by AFRLUser5 on 08/16/2005 11:50 AMI would like to generate a report that shows me what all of the reports(parameters, sql queries etc.) are within our system. This will helpour admin keep tabs on everyone with access to livereports. Has anyonehad to do this - or can anyone tell me where the reports are actuallystored?Thanks.--Cory[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: Need to report on all reportshttps://knowledge.opentext.com/knowledge/livelink.exe/open/4114299Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe/open/2249677Livelink Server:https://knowledge.opentext.com/knowledge/livelink.exeTo Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.

Lee_Butler_(lbutler_(Delete)_2946657)

Message from Lee Butler via eLinkMessage from <> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hello Airforce guys,

I believe you both have WebReports installed so you might want to make use of the following:

Add a simple LiveReport as suggested by Ken - eg:

select * from dtree where subtype=299

Add a new WebReport with that LiveReport as the datasource and browse for the attached reportview which provides the following:

SQL statement and parameters in separate columns

Button to execute the LiveReport in a separate window

Highlights any LiveReport that have the 'Danger Box' ticked in red

Hides the execute button for LiveReports with the 'Danger Box' ticked - to avoid accidents

Displays the name of the creator with a hyperlink to open their details in a new window

It only has the 9.1 style but it should not be a big job to jazz it up and add additional data.

Feel free to email me if you have any specific questions.

Thanks,
Lee.