What do you want to do with it ?
we need to create a report form.
Not really remember the exact names, check server related tables or devices related table,
May be some one else can give u the exact name.
thanks , i had check all the tables related with server and device . but i had foun none infomation.
You should be using the blcli to pull this information. Or do you have bdssa installed ?
The device table only stores some properties, the rest (including custom server properties) are in primitive_bl_value table. The relationship between the two tables is not obvious from first look; there's probably another table that maps associations, probably for bl_value_id values. Either way, what Bill suggested is much cleaner, easier, and most importantly - supported:
blcli_execute Server getFullyResolvedPropertyValue [server] HOST
blcli_execute Server getFullyResolvedPropertyValue [server] FQ_HOST