Author Topic: Sending Stats  (Read 2845 times)

DDP021

  • Sr. Member
  • ****
  • Posts: 343
    • View Profile
Sending Stats
« on: August 08, 2018, 06:36:11 AM »
Apologies if this is the wrong forum for this question.  We had a user come to us asking if there was a way to automatically send their numbers for a report the send to CMOD to feed a dashboard application.  I know this information can be 'manually' gathered as far as getting a total, which we would not want to do.  But they are looking for something automated.  Not sure if anyone else has had this question posed to them.  But in thinking, even it its possible, don't think we want to get involved with something like this.  Can foresee many others looking for something like this....Below is what was asked:

When CMOD receives the file , does the it know how many individual account records were present in the file? And how many reports were archived? Does CMOD know how many individual reports are archived per day for a specific report name?
If so, is there a way for this information to feed to a ‘dashboard application’ or to be picked up by another application (e.g. via an API)?
If not, is there a way for an automated ‘positive acknowledgement’ to be sent or picked up when the big statement file is received and archived successfully on ERR’s side?

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Sending Stats
« Reply #1 on: August 08, 2018, 10:39:08 AM »
This information is best obtained from the system that generated the report.  It's way too much work to pull this from a document in an archive, rather than having the source system run a database query or two and sending that off to your reporting/dashboarding application.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Stephen McNulty

  • Jr. Member
  • **
  • Posts: 57
    • View Profile
Re: Sending Stats
« Reply #2 on: August 09, 2018, 01:46:28 AM »
You may be able to get some of what you are looking for, from the ARSRPT utility...  but as Justin pointed out, its a lot of work.
#ISERIES #ODWEK #XML

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Sending Stats
« Reply #3 on: August 09, 2018, 03:50:35 AM »
Hey Stephen.

It sounds like 'individual account records' might be tricky depending on the type of report (I'm thinking greenbar reports).  But yes, arsrpt would be able to generate information about those statistics.

It also sounds like the System Load Application Group would be useful here as well.  It's not just possible, but quite easy to query and get useful information out of it.

-JD.

IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

DDP021

  • Sr. Member
  • ****
  • Posts: 343
    • View Profile
Re: Sending Stats
« Reply #4 on: August 09, 2018, 03:57:14 AM »
We can pull the numbers they want manually I believe...But it appears from their initial email they are looking for something automated as to where CMOD send these numbers to some dashboard application where they can go to verify what was received by CMOD matches what was sent.  I believe there is a meeting scheduled to get more details.  See what comes from that!!!  ;-)  Thanks again to all for their input!!!!!

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1200
    • View Profile
Re: Sending Stats
« Reply #5 on: August 09, 2018, 06:54:01 AM »
I have never used this or even touched it.  All I know is that I heard about this in an announcement:

https://www-01.ibm.com/support/docview.wss?uid=swg27021523

IBM System Dashboard for Enterprise Content Management integration support

    Use IBM System Dashboard for Enterprise Content Management to proactively identify and resolve potential performance problems before they occur.

Ed
#zOS #ODF

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Sending Stats
« Reply #6 on: August 09, 2018, 08:51:20 AM »
Hey Ed!

I think the product you're linking to is the Filenet System Monitor -- which, while an awesome product, also had a shock-and-awe pricetag.  :D

Dave:

I took another quick look at ARSRPT, and it seems the maximum granularity offered is per-day statistics with a breakdown by hour.

It sounds like you'll need to come up with some queries of the System Log / System Load table on your own and deliver them to your dashboard.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

DDP021

  • Sr. Member
  • ****
  • Posts: 343
    • View Profile
Re: Sending Stats
« Reply #7 on: August 09, 2018, 08:56:57 AM »
Thanks again Justin...They had a meeting with the user today...I was unable to attend so not sure what the outcome was...In the end, I'm hoping its not something we get involved with...Going back to your original remarks, this should go back to the application sending the data to CMOD...For us to do some automatic feed of these numbers they want to their own dashboard seems to be out of scale...I'll have to check with our engineers to see what came from their meeting...Thanks again to everyone!!!!

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1200
    • View Profile
Re: Sending Stats
« Reply #8 on: August 09, 2018, 09:23:03 AM »
Quote
I think the product you're linking to is the Filenet System Monitor -- which, while an awesome product, also had a shock-and-awe pricetag.

Double  :D on my end.

Glad I don't have to deliver those kinds of numbers in my present gig.

Ed
#zOS #ODF