UCMDB and UD Practitioners Forum (Previously CMS)

Data in File_System_1 view in HPUD db

Frequent Contributor.

Data in File_System_1 view in HPUD db

I am working on a customization request for a customer. I don't have access to HPUD console and CMDB database. I need the following details for working on that customization, 


1) Which views should be used to extract information about softwares ? Currently I am using INSTALLED_SOFTWARES_1, RUNNING_SOFTWARES_1 to fetch the data. Does FILE_SYSTEM_1 view also contains software/executable files information ?


2) Can I join HOST_NODE_1 and FILE_SYSTEM_1 view using CMDB_ID assuming that FILE_SYSTEM_1 view contains information about files collected from all hosts by discovery tool ?


3) What is the significance of ROOT_1 view ?


Kindly provide inputs to the above questions.