Highlighted
Respected Contributor.
Respected Contributor.
96 views

Pre-Post scripts in UCMDB

Hi All,

 

I was just working with the Pre-Post Scripts option in UCMDB. The Scripts executes fine and gets back the desired results in Scan files. When opening the Scan file in Viewer we can get that under "Hardware and Configuration -> Hardware Data -> Asset Data -> Custom Data". But not sure where it stores the results on the Database or on the UCMDB WebUI. 

 

Can anyone please let me know on which table the results are getting updated.

 

Thanks in advance,

0 Likes
1 Reply
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Pre-Post scripts in UCMDB

Hello Jimmy,

 

The data in "scan files" that have been processed will be stored in the database.

For details in what tables the information is stored, you  can look at C:\hp\UCMDB\UCMDBServer\runtime\log\cmdb.dal.log

i.e..

 Line 2404: 2013-04-24 16:27:24,036 [Process Results Thread-Inventory Discovery by Scanner] INFO    7ms 1354105454 1033327536 1127643928 BATCH(3) INSERT INTO CDM_FILE_SYSTEM_EXPORT_1 ...
 Line 2406: 2013-04-24 16:27:24,047 [Process Results Thread-Inventory Discovery by Scanner] INFO    8ms 1354105454 1033327536 1127643928 BATCH(63) INSERT INTO CDM_ROOT_1 ...
 Line 2407: 2013-04-24 16:27:24,083 [Process Results Thread-Inventory Discovery by Scanner] INFO   35ms 1354105454 1033327536 1127643928 BATCH(1) INSERT INTO CDM_GRAPHICS_ADAPTER_1 ...
 Line 2408: 2013-04-24 16:27:24,105 [Process Results Thread-Inventory Discovery by Scanner] INFO   21ms 1354105454 1033327536 1127643928 BATCH(4) INSERT INTO CDM_HARDWARE_BOARD_1 ...
 Line 2409: 2013-04-24 16:27:24,107 [Process Results Thread-Inventory Discovery by Scanner] INFO    1ms 1354105454 1033327536 1127643928 BATCH(2) INSERT INTO CDM_CPU_1 (...
 Line 2410: 2013-04-24 16:27:24,109 [Process Results Thread-Inventory Discovery by Scanner] INFO    1ms 1354105454 1033327536 1127643928 BATCH(1) INSERT INTO CDM_WINOSUSER_1 ...
 Line 2411: 2013-04-24 16:27:24,117 [Process Results Thread-Inventory Discovery by Scanner] INFO    7ms 1354105454 1033327536 1127643928 BATCH(1) INSERT INTO CDM_INVENTORY_SCANNER_1 ...
 Line 2412: 2013-04-24 16:27:24,126 [Process Results Thread-Inventory Discovery by Scanner] INFO    8ms 1354105454 1033327536 1127643928 BATCH(3) INSERT INTO CDM_DISK_DEVICE_1 ...... 

 

Best Regards,

Juan

 

"HP Support
If you find this or any post resolves your issue, please be sure to mark it as an accepted solution."
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.