Save json data to vmdb for Report


#1

Hi guys. Do know how to save data to vmdb for some Custom Report? I have external data from platform in json format. And I need to use such data in custom Report. How to save data in cfme ? Is it even possible?


#2

What kind of data?

We do support storing custom data, in the form of Generic Object Definitions & Generic Object instances, but the reporting engine does not support generic object instance fields as a source.

Any chance your data fits something ManageIQ already models?

Either that, or you’d need to add your own model, migration, and include the model in manageiq/config/miq_expression.yml's base_tables secion.


#3

The data are performance data - CPU, disk usage.
Ok thanks I will look at ManageIQ models and miq_expression.yml


#4

The data are performance data - CPU, disk usage.

That would be what we call Metrics. (Used, for example, by the Compute > Containers > Overview charts.)

Normally, ManageIQ collects it from providers, but this script is what I use to generate random metric data when testing, may be useful.

(Not sure this can be populated via our API.)


#5

Thanks a lot for your help.
I will look at this script.

Yes such data are normally provided. It is not special.
But we need to get the data ‘manualy’ by powershell script from platform.


#6

@himdel
(můžeme mluvit česky? dívám se že jsi z Brna, je tu možnost poslat osobní zprávu/mail?)

Could you please help me explain how to work with this script. How do you use this script for testing?


#7

Right, the idea is, you run the script in the manageiq/ folder, it connects to the database and generates random metrics data for every Container provider and Container Project.

So if you already have the data, the script should show you everything you need to get the data into your manageiq database.

pm

Sure, I also live on our gitter :slight_smile:


#8

ok I will send you message in Linkedin


#9

Is is possible to talk via Linkedin or use another portal or have some skype call? Because I need to talk directly or share desktop. so this forum is small for this discussion.


#10

If you are a customer, I suggest going through the proper channels.

If you are not, I’m sorry, I don’t do support calls.

Feel free to describe your issue here, and people will take a look,
feel free to discuss your issue on ManageIQ gitter,
but I will not be discussing anything on LinkedIn or Skype, sorry.


#11

Hi @tapinka, as @himdel mentioned, if you are a subscription customer, you should have direct contacts for official support. Community support is best effort through this forum and on gitter. We do not offer personal support calls here. Thanks for your understanding.


#12

Hi cybette, yes I understand. thank you.