Hi York,
There is already a case opened with ILMT Support, once the investigation is done, we'll update both the case and this post.
Thank you.
------------------------------
Andrei Ionescu
IBM
Bucharest
------------------------------
Original Message:
Sent: Tue January 31, 2023 08:59 PM
From: York Ly
Subject: Question about https://hostname:9081/api/sam/v2/computers?columns[]=name&columns[]=computer_details.computer_property_1
In ILMT portal, after I created a custom Computer Properties called "GTS Serial Number". Everything works fine as expected and I could select that "GTS Serial Number" in any of ILMT reports.
It also updates this v2/computer_system schema with a name called "computer_property_1" as shown below sample.
https://hostname:9081/api/sam/v2/schemas/computer_system_properties.json?
computer_property_1
type
0 "string"
1 "array"
2 "null"
items "string"
title "GTS - Serial Number"
mappings
type "array"
association true
description "Mappings into datasource properties"
===========
I can also run the REST API call below to report that custom computer properties as well from computer_property_1. See below.
https://hostname:9081/api/sam/v2/computers?columns[]=name&columns[]=computer_details.computer_property_1
The question is which table or view inside the ILMT database that computer_property_1 is created?
From the REST API call above, it seems that it is linked or associated to a view or table called computer_details where the computer_property_1 is stored. Can you let me know which table or view that computer_details.computer_property_1
is coming from?
------------------------------
York Ly
------------------------------