Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm been asked to create an app to monitor all apps for new data. I have a method I plan to use for this, but it's a bit tedious. I wanted to know if there is anything already in place on the QMC I am not aware of, or if there are fields ect that I could use to do this instead.
There is an issue that we cannot always validate if an application has updated, or even if the data load ran, we cannot tell if there are new rows.
What we want is something like:
App Name | Table Name | Last Number or Rows | Current Number of Rows | Load Date |
My formal question: Is there already something built in I should read up on?
I imagine you can get what you need from the https://community.qlik.com/t5/Qlik-Monitoring-Administration/Sense-App-Metadata-Analyzer/gpm-p/15921.... If not, you can get some ideas about how to get what you want using the QRS API.
-Rob
That's kind of what I was thinking of in my process, I just felt there had to be a better way. I was going to do an include directed to some sub routines and use them to load append and restore the QVD each time our load process is ran. Then I could load the QVD with the stats into an app and use that to monitor, however I thought that perhaps something like Rob posted would be available, I just didn't know where to look.
While making all the qvd for all your app you can make a inline table below all qvd n concat it together
Your inline script will have the columns you/your team requires for monitoring the qvd.
After your qvd stage is done before exit you can concat & store it to final qvd date wise or standalone qvd.
Lode the set of qvds/qvd in a custom app
I imagine you can get what you need from the https://community.qlik.com/t5/Qlik-Monitoring-Administration/Sense-App-Metadata-Analyzer/gpm-p/15921.... If not, you can get some ideas about how to get what you want using the QRS API.
-Rob
That's kind of what I was thinking of in my process, I just felt there had to be a better way. I was going to do an include directed to some sub routines and use them to load append and restore the QVD each time our load process is ran. Then I could load the QVD with the stats into an app and use that to monitor, however I thought that perhaps something like Rob posted would be available, I just didn't know where to look.