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; } } }

AuditStr values in DAuditNew table

Donna_Pellett

Is there a place I can get a listing of all the possible values for the DAuditNew.AuditStr column? We want to create some reports looking for certain actions and i want to make sure i do not miss any the client might want us to look for. I can get the unique values we currently have in our table, but I would like a complete list in case we have not used some of the functions yet and they do not show in our table.

thanks in advance for any direction you can give on this.

Donna

Find more posts tagged with

Comments

Colin_Schmidt

Yes, easily (in Oracle):

select distinct da.auditid, da.auditstr

from dauditnew da

order by da.auditid

Colin

On Wed, Aug 14, 2013 at 11:39 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

AuditStr values in DAuditNew table Posted bypelletd1@rjrt.com (Pellett, Donna)On 08-14-2013 11:35

Is there a place I can get a listing of all the possible values for the DAuditNew.AuditStr column? We want to create some reports looking for certain actions and i want to make sure i do not miss any the client might want us to look for. I can get the unique values we currently have in our table, but I would like a complete list in case we have not used some of the functions yet and they do not show in our table. thanks in advance for any direction you can give on this. Donna
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center

This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.

Bhupinder_Singh

This has been asked before, and some result sets posted here:

https://communities.opentext.com/communities/cs.dll?func=ll&objId=8992797&objAction=viewincontainer&ShowReplyEntry=8991136#forum_topic_8991136

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Systems Administrator, Cloud Services
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

Donna_Pellett

Thank you for the response. We are using SQl and I have already done that for our table. My concern is that there are other possible values that can be in the AuditStr that we are not currently using and I want to make sure i get an all inclusive list. Is there a table of all the values that 'could' be in the column? For example, if we have never used the 'ZipandDownload' it would not appear in our current DAduitNew table. How to I get the list of those that are not yet in our table?

Thanks,

Donna

Lori_Himsl

I believe in Admin there is a list of items that can be selected (checkboxes) for auditing. That list should include every auditable event.

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, August 14, 2013 11:58 AM
To: eLink Recipient
Subject: Re AuditStr values in DAuditNew table

Re AuditStr values in DAuditNew table

Posted bypelletd1@rjrt.com (Pellett, Donna) On 08-14-2013 11:55

Thanks,

Donna

[To post a comment, use the normal reply function]
Topic:	AuditStr values in DAuditNew table
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Appu_Nair1

Livelink is written in beautiful code that amaze me every time.It is possible to find what your livelink system is CAPABLE of running rather than what you have enabled and getting from database queries.I hope that is what you were asking.I also think maybe this info can be found in sysreports as well not sure

Note your system may have less/more than mine so here's a list which I ran now

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objaction=overview&objid=38972842

Quoted Donna Pellett on 2013-08-14 11:21:

thanks in advance for any direction you can give on this.

Donna

Donna_Pellett

Thank you for that very encompassing list! It is a great start for me until I can take a look at our Admin area.

Love this Forum! Always so many helpful people!