Question regarding ua_instance_state

[JaineelPetiwale]

Hi All,

I wanted to check with you. Whether you have any clue how is data populated in ua_instance_state table ?

I found one KB as per which there is a ootb job "UA instance info download", that runs every 6 hours and pulls data from central instance, but on instance when im trying to gind that job, im not able too.

And reason for searching this is, becuase there is some number difference between what we see on this table for db size vs what we see on hi support. Just wanted to debug, root cause of difference, since for one of my instance, it doesn't even updates, it's zero.

So please help to find this job how it works and all.

[Maik Skoddow]

Hi @JaineelPetiwale 

you can ignore that table. In none of my customer instances it reflects valid values. So if you want to see database consumption you should better refer to the support portal or use the new data management application with the Yokohama release.

Maik

[JaineelPetiwale]

No, actually, I'm looking into this table, since in my org, as periodically, we have to create a report, that list DB size for all instances and share it to the management, so, Now I plan to automate this using a scheduled job, that will fetch this number from all instances using OOTB Table API, and create a report and send it automatically to the management.

Also, maybe in future we might plan to create a dashboard in power Bi or something, which might fetch this data from all instances periodically and show the live data.

So, checking on this, if this data is incorrect on our instance, then I think, I will need to do some automation that will directly fetch from Now Support, probably.

Share your thoughts, if you have any idea.