HPE Service Manager / Service Center Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Mining Structured arrays in BLOBs

Occasional Contributor

Mining Structured arrays in BLOBs

This isn't a question it is a bit of knowledge that I just gleaned out of HP after 3 months of bashing on the door I finally got throught to R&D. If you want to use a toolset like Crystal reports and the like to mine data stored in structured arrays inside SM7 there is a quick fix that works a treat. In quotes is the response from HP.
"I have checked this with one of our lead engineers and he has told me of the following process where you can map fields in the labor structure to a new table and you can then run your reports off that instead of the probsummary table.

Go to database dictionary and bring up the probsummary table. Double click on the labor structure which will open a popup window where you can enter a Attribute file name and unique Attribute. Add a file name in both fields, eg: laborattribute and laborunique. Click OK and OK again to exit the dbdict.
The laborattribute table will have the fields in a normal scalar fashion, ie: text, date/time, number etc. Not a blob/clob.
You can then report off of the new table from the rdbms. The unique id is also included in the new table, so you will have the ticket number."
Honored Contributor

Re: Mining Structured arrays in BLOBs

Just wanted to raise this - great tip by Andy Plant. If you need to make reports by making queries to SQL database, this is essential to get data out from for example "clocks" table. We're tracking how long different assingment groups are holding the tickets...