"Available Space" Field converting the MB/GB data into KB in "cmdb_ci_file_system" Table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2024 04:27 AM
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?
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2024 11:14 PM
This data is coming from Jdisc and data is correct in jDisc its showing in MB like 402.5 MB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-10-2024 04:22 AM - edited 07-10-2024 04:23 AM
So what is the exact process for importing data from jDisc?
Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 05:26 AM
@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.