I've been a great advocate of OCI Log Analytics for a very long time. As you all probably know, it is very easy to push your OIC activity stream logs to OCI Log Analytics. And there the magic begins!
LoganAI is a new capability that allows you to interpret your log data via a chat interface, i.e. no more need for constructing complex MQL queries - just ask and you shall receive!
For those new to OCI Log analytics, I suggest you check out the plethora of posts available here.
For those that want a deep dive into LoganAI first, then check out the excellent post from Kumar here.
All read up? Then let's start with the following project in OIC and the 4 order processing integrations we'll look at -
The integrations themselves are banal - the only one with any logic is validateOrder.'Log Source' = 'OCI Integration Activity Stream Logs' and 'Log Group' = My_OIC_LogGroup | fields -Entity, -'Entity Type', -'Host Name (Server)', -'Problem Priority', -Label, -'Log Source', -'Log Group' | fields 'Integration ID', OICStatus, Message | timestats count as logrecords by Integration | sort -logrecords
But I have my own questions -
- did any integrations fail?
- How many orders did I process in the last 3 hours?
- How many orders were created in the last 3 hours?
- what are the order numbers of the orders created in the last 3 hours?
- are there any duplicate order numbers for create order?
- Did any orders fail validation?
- Which order took the longest to fulfill? Please also return the orderNr.
- give me the orderNr of the order that was fulfilled fastest
- give me the order numbers of the orders that have passed validation, but have not yet been shipped
- what's the average execution time of the createOrder integration? Use the Message Received action as the start event.