Need to fetch system information through rest api,  is there any table which consists of this data.

Thanks.

Hi Suman,

The data about installed components is stored in maxvars table. You can retrieve it using REST API like that:

curl --location 'https://hostname/maximo/rest/mbo/maxvars?_maxItems=20&_rsStart=0&_compact=1&_urs=0&_uw=varname%20like%20%27%25UPG%27&_format=json' \
--header 'apikey: ...'

The output will look like this:

{
    "MAXVARSMboSet": {
        "rsStart": 0,
        "rsCount": 14,
        "rsTotal": 14,
        "MAXVARS": [
            {
                "VARNAME": "AHUPG",
                "VARVALUE": "V8820-2",
                "MAXVARSID": 1063
            },
... more results ...
        ]
    }
}

System information is not held in one particular table. However, Maximo has an API to aggregate much of what you're looking for.

GET /maximo/api/systeminfo?lean=1
apikey: xxxxxxxxxx

The response will look something like this:

{
    "href": "/maximo/oslc/systeminfo",
    "appServer": "IBM WebSphere Liberty Server 23.0.0.6",
    "database": {
        "dbProductName": "DB2/LINUXX8664",
        "dbVersion": "SQL110580",
        "dbMajorVersion": 11,
        "dbMinorVersion": 5
    },
    "os": {
        "osName": "Linux",
        "osVersion": "4.18.0-513.24.1.el8_9.x86_64",
        "architecture": "amd64",
        "availableProcessors": 6
    },
    "appVersion": {
        "member": [
            {
                "versionKey": "Maximo Integration Framework 8.6.0 Build 20231218-1344 DB Build V8600-03"
            },
            {
                "versionKey": "IBM Maximo Mobile 8.10.0 Build 20231218-1340 DB Build V81000-29 HFDB Build HF81000-18"
            },
            {
                "versionKey": "Maximo Application Framework 8.10.0 Build 20231207-1229 DB Build V7600-27"
            },
            {
                "versionKey": "Maximo Manage 8.6.8 Build 20231218-1344 DB Build V8600-01 HFDB Build HF8680-02"
            },
            {
                "versionKey": "Maximo Process Automation Engine 8.6.8 Build 20231218-1344 DB Build V8600-60"
            }
        ]
    }
}

... which is similar to what you see in the System Information dialog inside of the Maximo UI.

Hope this helps,