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

zee15
Tera Contributor

‎07-09-2024 03:23 AM

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.

0 Helpfuls
  • 503 Views
5 REPLIES 5

Slava Savitsky
Giga Sage
In response to zee15

‎07-12-2024 10:35 AM

What exactly do the jobs running on Jdisc side do? What is the mechanism for transferring the data to ServiceNow? Are you using a web service? Is it REST or SOAP? Is it a standard ServiceNow API or a custom one?


Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
0 Helpfuls