thread1329-1755719
It would appear that the UBAT scripts from the above thread are no longer functional in MiCollab 7.2
[root@MICOLLAB ~]# ubat -e UBAT-2016-08-29.csv
Exporting data to file /var/tmp/UBAT-2016-08-29.csv ... Done.
Licensing summary:
psql:<stdin>:16: NOTICE: table "tmp_huy_license_summary" does not exist, skipping
psql:<stdin>:29: ERROR: relation "tmp_huy_output_tbl" does not exist
LINE 10: ...n (select bundle, count(bundle) as allocated from tmp_huy_ou...
^
ERROR: relation "macschema.tmp_huy_license_summary" does not exist
LINE 1: select * from macschema.tmp_huy_license_summary
^
Please download file /var/tmp/UBAT-2016-08-29.csv to your PC and open it using a spreadsheet program.
[root@MICOLLAB ~]# locate UBAT-2016-08-29.csv
[root@MICOLLAB ~]# ls /var/tmp
00071853.11564 00071c8d.19032 00071d29.18870 00071d3b.19149 00071daf.21251 00071e02.7980 00071e8b.21398 00071ea6.10621 00071ec0.18451 logcollector.lockfile ths_poolload.log
00071c0f.11453 00071d29.18654 00071d3b.15870 00071d43.19332 00071dd8.21307 00071e40.15779 00071e9d.17276 00071ebc.31234 20160828042201_cube.log queue_tns_tpdvr.log ths_userload.log
[root@MICOLLAB ~]#
Has anyone worked with this tool recently?
-b
It would appear that the UBAT scripts from the above thread are no longer functional in MiCollab 7.2
[root@MICOLLAB ~]# ubat -e UBAT-2016-08-29.csv
Exporting data to file /var/tmp/UBAT-2016-08-29.csv ... Done.
Licensing summary:
psql:<stdin>:16: NOTICE: table "tmp_huy_license_summary" does not exist, skipping
psql:<stdin>:29: ERROR: relation "tmp_huy_output_tbl" does not exist
LINE 10: ...n (select bundle, count(bundle) as allocated from tmp_huy_ou...
^
ERROR: relation "macschema.tmp_huy_license_summary" does not exist
LINE 1: select * from macschema.tmp_huy_license_summary
^
Please download file /var/tmp/UBAT-2016-08-29.csv to your PC and open it using a spreadsheet program.
[root@MICOLLAB ~]# locate UBAT-2016-08-29.csv
[root@MICOLLAB ~]# ls /var/tmp
00071853.11564 00071c8d.19032 00071d29.18870 00071d3b.19149 00071daf.21251 00071e02.7980 00071e8b.21398 00071ea6.10621 00071ec0.18451 logcollector.lockfile ths_poolload.log
00071c0f.11453 00071d29.18654 00071d3b.15870 00071d43.19332 00071dd8.21307 00071e40.15779 00071e9d.17276 00071ebc.31234 20160828042201_cube.log queue_tns_tpdvr.log ths_userload.log
[root@MICOLLAB ~]#
Has anyone worked with this tool recently?
-b