Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Log Database Schema
Topic Summary: Log Database Schema
Created On: 07/15/2013 10:51 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 07/15/2013 10:51 AM
User is offline View Users Profile Print this message

Author Icon
CaseyHarris
Journeyman (50-99)

Posts: 62
Joined: 07/15/2013

Greetings,

Do you publish a database schema for your logging database, and if so, then where would I find it?

Thanks in Advance,

Casey



 Category Survey


-------------------------
Thanks,

Casey
 07/15/2013 11:04 AM
User is offline View Users Profile Print this message

Author Icon
Liz Casale
AUTOMATE EMPLOYEE

Posts: 940
Joined: 05/23/2011

Hi Casey,

Unfortunately, we do not have any database schema documentation that we can provide publicly. I apologize for the inconvenience.

 Category Survey


-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4
 07/15/2013 11:19 AM
User is offline View Users Profile Print this message

Author Icon
CaseyHarris
Journeyman (50-99)

Posts: 62
Joined: 07/15/2013

Thanks, Liz.

Can I post specific questions regarding the log database schemna to this thread and have you (or another TSR) answer them?

Also, I would like to suggest that the log database schema be published. I think it would enhance the usability of the product if that information were more available to yur customers to be used to develop custom reports to better manage and/or monitor their automations.

Thanks,

Casey



 Category Survey


-------------------------
Thanks,

Casey
 07/15/2013 03:00 PM
User is offline View Users Profile Print this message

Author Icon
Liz Casale
AUTOMATE EMPLOYEE

Posts: 940
Joined: 05/23/2011

Hi Casey,

Thank you for your post. Attached is a screenshot of the BPA 9 Schema. However, we cannot provide further details about the schema, nor can we support requests based around the schema (i.e. a solution is built around the schema and something doesn't work).

We hope this helps!

 Category Survey


Click for full image
Click for larger image



-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4
 07/15/2013 03:55 PM
User is offline View Users Profile Print this message

Author Icon
CaseyHarris
Journeyman (50-99)

Posts: 62
Joined: 07/15/2013

Hi Liz,

Thanks for sharing this information, but it is not what I need. I will clarify what I am asking for.

First, I am using AutoMate 8, not BPA 9. Next, I am not asking for the entire product schema.

What I am asking for is the schema for the tables that are created when I enable logging to a database. Really, it is not even a schema that I am requesting, so much as a data dictionary - something that will tell me, for example, what is the purpose of the stepnumber column in the tasks table?

It is the tables that the product uses for logging off of which I would like to create reports. An example of the type of report I'd like to create is the execution history for a given task. Another example would be the result of the last execution for all scheduled tasks.

The remaining question, then, was whether you all would answer questions about specific coolumns or tables in the logging database (in the event that no data dictionary was available), and not about any reports that I create. I would not expect you to answer questions about reports that I might create.

Thanks,

Casey



 Category Survey


-------------------------
Thanks,

Casey
 07/16/2013 10:16 AM
User is offline View Users Profile Print this message

Author Icon
Liz Casale
AUTOMATE EMPLOYEE

Posts: 940
Joined: 05/23/2011

Hi Casey,

Thank you for your post. We are going to consult our development team for some additional information and follow up with you when possible.

You can also export all Reports from the Logs section of the Task Administrator.

 Category Survey


-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4
 07/22/2013 12:51 PM
User is offline View Users Profile Print this message

Author Icon
Liz Casale
AUTOMATE EMPLOYEE

Posts: 940
Joined: 05/23/2011

Hi Casey,

Thank you for your patience. If you can provide the specific questions you have currently, we can forward them over to our development team for review.

 Category Survey


-------------------------
Liz Casale
Technical Support Representative
(213) 738-6966
Network Automation, Inc.

--------------------------------------------------------------------------------

AM5 5.5.5.1; AM6 6.2.8.0; AM7 7.1.3.0; AM8 8.0.9.0; AM9 9.0.3.4
BPA7 7.1.3.0; BPA8 8.0.9.0; BPA9 9.0.3.4
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 2018 guests browsing this forum, which makes a total of 2018 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog