"Available Space" Field converting the MB/GB data into KB in "cmdb_ci_file_system" Table

zee15
Tera Contributor

Hi,

I need help,

There are fields Available Space (MB) (available_space) & Capacity (MB) (capacity) in the "cmdb_ci_file_system" table, both fields are integer type so when we are trying to pull the data from the third party tool that data is in MB/GB for example 493 MB but when we are pulling that data into servicenow it converting into KB see the attachment.

zee15_0-1720520128376.png

 as you can see in the above image there are other fields like "Free Space" & "Size" which are storing the correct data because the data type of these two fields are String. I Can change the data type of  "Available Space (MB)" & "Capacity (MB)" fields to fix this problem but these are Out of the box fields.

so I just want to know if these fields are integer then why they are converting data MB to KB or GB to KB and how can i fix this without changing the field type or is there any other solution to fix this.

5 REPLIES 5

Slava Savitsky
Giga Sage

Where does the data come from? How exactly do you bring it into ServiceNow? Are you using ServiceNow Discovery, a scheduled data import, or another kind of integration?

This data is coming from Jdisc and data is correct in jDisc its showing in MB like 402.5 MB

So what is the exact process for importing data from jDisc?

@Slava Savitsky  there are jobs which is running on Jdisc side.

Also I found one script include which is StorageDataSize (global.StorageDataSize) where all the logic written over there but I am not able to find the trigger point I mean which script is responsible to calling this script include.