For what it's worth I have also had a strong need for the same report
functionality. We use the Notes field to document failures for critical servers
as part of SOX compliance reporting. Having a simple way to generate a list of
failures for a server group with any attached Notes is part of our need during
SOX audits. The shortcoming of the portal (GUI) interface is that you cannot
get a concise summary of backup job failures with the Note field included. This
is particularly problematic for backup jobs that are multistreamed and may (in
our case) contain 150-200 individual job streams. When such a job fails, for
whatever reason, the challenge becomes deciding which of the multitude of
failed jobs to assign a Note, then identifying which of those failures had the
note text during an audit.
What I requested from APTARE was the ability to create (or they could be nice
and create one for me :-)) a custom automated report that would include all
backup failures (something similar to the job summary report) and for each job
failure, include any note text associated with the job. At the time of my
inquiry I was told the Notes field was not an "exposed" field through the
auto-report SQL queries. Supposedly APTARE has acknowledged my request as being
a useful suggestion and the request has gone to into the bowels of the
organization as a future enhancement. I have no idea when/if it will ever see
the light of day, but I'm hopeful. For us, this would make our lives immensely
easier for compliance reporting and SOX auditing.
(BTW ... I really wish APTARE would "simplify" the XML report designer for
those of us who do not have the time to become SQL/XML programmers in addition
to our myriad other duties.)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#!/usr/local/man/steve green :: Storage Administration
Telephone & Data Systems, Inc.
608.664.8210 (immobile) :: 608.219.2106 (mobile)
What can be asserted without evidence may be dismissed without evidence.
________________________________
From: Philip McDougal [mailto:pmcdougal at Calamos.com]
Sent: Tuesday, February 13, 2007 12:04 PM
To: Paul Keating; veritas-bu at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] NBU and Aptare custom reports ..
Thanks Paul. I've tried that already ;-) but they want a commitment from my
company before they "allocate resources" to do this. So I'm almost forced to
do this myself.
I love the product and want to have the company purchase it but there's no way
they're gonna like me telling them that the most important report we need is
one that WE have to create.
Thanks again!
Phil.
From: veritas-bu-bounces at mailman.eng.auburn.edu [mailto:veritas-bu-bounces
at mailman.eng.auburn.edu] On Behalf Of Paul Keating
Sent: Tuesday, February 13, 2007 11:57 AM
To: Philip McDougal; veritas-bu at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] NBU and Aptare custom reports ..
Definately contact the aptare guys.
they've been very helpful with that sort of stuff.
Gives you a chance to test out the support while you're evaluating the product.
;o)
Paul
--
-----Original Message-----
From: veritas-bu-bounces at mailman.eng.auburn.edu
[mailto:veritas-bu-bounces at mailman.eng.auburn.edu] On Behalf Of Philip
McDougal
Sent: February 13, 2007 12:55 PM
To: veritas-bu at mailman.eng.auburn.edu
Subject: [Veritas-bu] NBU and Aptare custom reports ..
Hey all, I know this is more of an Aptare question but I don't know of
any other source of information to pull from.
I have been evaluating Aptare StorageConsole for a few weeks now and
love it! Unfortunately, the one report I need for auditing isn't canned and
I'm not an XML or SQL guru. Has anyone created some custom reports where
they've added a column or a way to export the Notes that can be attached to the
Job Summary Report or Backup Summary? I've looked at the XML Report
Customization and it's not helpful to me (as I've no history in XML or
development). If anyone has done this or can point me to some other pools of
knowledge, I'd be greatly appreciated!
Thank you in advance!
Phil.
CALAMOS INVESTMENTS CANNOT ACT UPON, AND WILL NOT ACCEPT, ANY
TIME-SENSITIVE ELECTRONIC MESSAGES, SUCH AS TRANSACTION ORDERS AND FUND
TRANSFER INSTRUCTIONS. ALSO, FOR YOUR PROTECTION, PLEASE DO NOT SEND ANY
IDENTIFYING INFORMATION, SUCH AS ACCOUNT NUMBERS OR SOCIAL SECURITY NUMBERS,
THROUGH THE INTERNET.
CONFIDENTIALITY NOTICE: This message is intended only for the use of
the individual or entity to which it is addressed and may contain information
that is confidential . If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is prohibited. Please notify the sender
immediately if this message was transmitted in error. Thank you.
====================================================================================
La version fran?aise suit le texte anglais.
------------------------------------------------------------------------------------
This email may contain privileged and/or confidential information, and the Bank
of
Canada does not waive any related rights. Any distribution, use, or copying of
this
email or the information it contains by other than the intended recipient is
unauthorized. If you received this email in error please delete it immediately
from
your system and notify the sender promptly by email that you have done so.
------------------------------------------------------------------------------------
Le pr?sent courriel peut contenir de l'information privil?gi?e ou
confidentielle.
La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute
diffusion,
utilisation ou copie de ce courriel ou des renseignements qu'il contient par une
personne autre que le ou les destinataires d?sign?s est interdite. Si vous
recevez
ce courriel par erreur, veuillez le supprimer imm?diatement et envoyer sans
d?lai ?
l'exp?diteur un message ?lectronique pour l'aviser que vous avez ?limin? de
votre
ordinateur toute copie du courriel re?u.
CALAMOS INVESTMENTS CANNOT ACT UPON, AND WILL NOT ACCEPT, ANY TIME-SENSITIVE
ELECTRONIC MESSAGES, SUCH AS TRANSACTION ORDERS AND FUND TRANSFER INSTRUCTIONS.
ALSO, FOR YOUR PROTECTION, PLEASE DO NOT SEND ANY IDENTIFYING INFORMATION, SUCH
AS ACCOUNT NUMBERS OR SOCIAL SECURITY NUMBERS, THROUGH THE INTERNET.
CONFIDENTIALITY NOTICE: This message is intended only for the use of the
individual or entity to which it is addressed and may contain information that
is confidential . If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution or copying of this
communication is prohibited. Please notify the sender immediately if this
message was transmitted in error. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070214/82aa6320/attachment.htm
|