Automic Workload Automation

Hi there,

I'm wondering how I can simply dump the results of an SQLI VARA to email. This feels like it should be easy, but I haven't found that way yet. I've played with PREP_PROCESS_VAR on the SQLI VARA in a CALL object, but this seems way too tedious for simply wanting all of the results from the query sent. I do not want to give end users unlimited access to the DB, so I am looking to build one off solutions that can be locked down and not abused, and also easily shared across many clients as needed. Alternatively, I realize I could build SQL jobs and send the report results, but feels like there should be an easy way to dump an SQLI to email.

For more context, many users are looking for reporting that does not seem to be offered out of the box easily, but which could be pulled from the DB. A common ask is in the form of "how can we get a daily report emailed to us of what jobs ran last night?" A Periods function would probably fit the bill, but a search didn't reveal that, which brought me to the DB itself.

We're running AE v9 SP8 with Oracle DB on Linux.

Thanks for reading; has anyone done this?

Eric

Our solution for "daily report emailed to us of what jobs ran last night" was to use the UC4 Reporting Tool on the UC4 server to define the report, and then we run UCYBDBRT to generate the predefined report.  In our case we call UCYBDBRT twice, once to build the report in html format, and again to build the report in csv format.  The post-process of this job attaches the two reports to an email via the send_mail() script function. 

We are V9 sp5 with SQLServer on Windows.

Pete

There's a limit to the output from a SQL variable as well.

One thing to think about is the impact of using the SQL variables for reporting. Since it has to come back into the cache for the AE side, it could impact performance if the number of values it's pulling back is very large.

Thanks for taking the time to respond Pete and Jennifer. We have not looked into the reporting tool, although it has come up in the past. Maybe this is the answer to what we're looking for.  I have started exploring this option.

Pete, control and set up for your solution remains with the Automic team, correct? The more this can be made accessible for users to build jobs themselves, without introducing danger, the better. I'm beginning to envision standing up a separate system with the UCYBDBRT on it, with an agent deployed that users can use to create their own reports on demand. Possibly we create and make available different reports as needed, giving us a chance to vet, or possible we provide the Reporting Tool for query building as well.

Thx again, this was a good reminder to circle back on this feature!

Eric

Eric:

Have you reviewed this recent discussion, perhaps it might help?

Hi Mark,

I had not seen that thread, thanks for including it here. It certainly adds additional details.

Eric

I don't consider the UC4 reporting tool to be useful for on demand requests.  However the "Periods" feature in the client is pretty good for most upon demand requests (as mentioned in the other thread.)  You can distribute the Periods result with rightclick/ExportToFile.

Hi Pete, 

I know what you mean. By "on demand," what I really meant was self-service, and able to be scheduled for delivery via email on a daily basis. Periods is a good, quick way of getting info, but I didn't see a function or way to schedule the output be sent via email, which is key. With the reporting tool, we might be able to build a solution that will fit this need.

Thx all for your input!

Eric