[ADSM-L] Reporting

2015-06-29 16:02:16
Subject: [ADSM-L] Reporting
From: "Lepre, James" <james.lepre AT SOLIXINC DOT COM>
Date: Mon, 29 Jun 2015 20:00:16 +0000
Hello All -

  I run this query once a year for auditing purposes.

select date(start_time) as "Start Date",time(start_time) as "Start 
Time",date(end_time) as "End Date",time(end_time) as "End Time",number as 
"Process #",activity,schedule_name,entity,bytes,successful from summary where 

It usually produces one years worth of schedules for a node so I can see if 
there were any failures

Now with version 7.1 I am only getting one months worth of data

Any thoughts.

I have Act log retention set to 365

I also have summary retention set to 365

Any suggestions would be appreciated


Confidentiality Notice: The information in this e-mail and any attachments 
thereto is intended for the named recipient(s) only.  This e-mail, including 
any attachments, may contain information that is privileged and confidential  
and subject to legal restrictions and penalties regarding its unauthorized 
disclosure or other use.  If you are not the intended recipient, you are hereby 
notified that any disclosure, copying, distribution, or the taking of any 
action or inaction in reliance on the contents of this e-mail and any of its 
attachments is STRICTLY PROHIBITED.  If you have received this e-mail in error, 
please immediately notify the sender via return e-mail; delete this e-mail and 
all attachments from your e-mail  system and your computer system and network; 
and destroy any paper copies you may have in your possession. Thank you for 
your cooperation.

<Prev in Thread] Current Thread [Next in Thread>
  • [ADSM-L] Reporting, Lepre, James <=