Hi,
You will find, in attached file, 2 complex queries I developed (one for Oracle and the other for SQL Server 2016+). They display information as path, last execution date, output format, param values list, recipients list (to, cc and bcc), etc...
CMOBJPROPS26.DELIVOPTIONS seems to contain a list of 5 fields separated by semicolon :
- delivery option name
- property enum
- delivery option type
- number of characters of the last field
- content of delivery option in XML format
In my samples, I extract XML part of toAddress, ccAddress and bccAdress delivery options.
After namespace cleaning, I could parse XML.
I think we can go further. It's a beginning ;-)
Have a good day,
------------------------------
DAVID MOULIN
Analytics expert
Micropole
Levallois-Perret
------------------------------
Original Message:
Sent: Tue June 02, 2020 10:53 AM
From: Cosme POUSSET
Subject: Content Store: parsing delivery options
Hi,
I can't use things related to Motio here, as I need something that I can use directly in SQL, PL/SQL code, etc ..
KR
Cosme
------------------------------
Cosme POUSSET
Original Message:
Sent: Mon June 01, 2020 03:59 PM
From: Hemal Patel
Subject: Content Store: parsing delivery options
Hi Cosme,
I think you should try Motio PI free version and you would be able to get this information easily.
Best,
Hemal
------------------------------
Hemal Patel
Original Message:
Sent: Fri May 29, 2020 12:05 PM
From: Cosme POUSSET
Subject: Content Store: parsing delivery options
Hi All,
Business has requested a list (report) showing all schedules details (name, when, what, format, etc..). I am trying to extract the information from the content store.
So far, I see that most of the information is available in "cmobjprops26", in the field "delivoptions".
I'm currently trying to parse the XML contained in this field. I do manage to use this technique in Cognos for other purposes but in this case, I'm facing the following error message: "namespace prefix "xsi" is not declared".
I've been trying with: xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" but it is not recognized.
I don't know which namespace (xmlns) should be referenced for this "xsi". Can you please help?
Thanks!
PS: any other way of extracting the schedule details from the database would be welcome.
------------------------------
Cosme POUSSET
------------------------------
#CognosAnalyticswithWatson