'Deleted by' details via GraphQL

Hello Albert,

in regular ONE GraphQL  you cannot find information about a deleted assset as it is simply gone once it is deleted. The information you are after lives in the Audit module, which keeps log of every operation that users perform in the MMM. You can get that info via the Audit GraphQL endpoint, but there are two conditions for it:

• Delete events are recorded by default only for select number of entities. For the rest, you have to add the trait audit:auditEnabled if you want to record the delete events. This is because the audit database can grow quickly the more action is keeps on record, thus affecting application performance. 
• Audit endpoint is accessible through playground only since version  15.4.0-patch14. If you are on an earlier version you will not be able to access the audit endpoint from Playground, but you may be able to from ONE desktop  via the JSON call step.

If you want  read more about  reaching the Audit GraphQL endpoint and see some example operations, check out our "Audit API" documentation as it has detailed description. 
I am sharing below a screenshot of a query you can use to see the deleted assets via the Audit GraphQL:
 

Note: Keep in mind that when you delete an item from the UI, ONE does not immediately remove the node from the metadata. Instead, it starts a workflow that sets a delete flag internally for the asset node. This is why the action is called “Finish_Success” instead of a “Delete”. Only items permanently deleted from the metadata would have a status “deleted”. 

Regards,

Maksim

Hey Maksim,

Thanks for your reply! This really puts me on the right track, so I can continue my investigation. I'm quite sure there will be some follow-up questions…

In my case I will use a JSON Call in One Desktop anyway, filtering on ID, for a specific metadata entity/assetType.
Besides the name I would also need the date or datetime of the deletion (so status finish_succes). In the output I see a time attribute, consisting of 13 digits. Is that a Julian date?

Kind regards,

Albert

​@Maksim Zhelyazkov 

Hey Albert,

The time attribute is not Julian, it is Unix epoch timestamps in milliseconds. If you want human-readable string directly in a report, you can convert it on client side. Depending on your use case, you can convert it via SQL statement, Javascript, Excel Sheet or directly in ONE desktop expression. 
As a quick test you can also do it in the browser too. Open DevTools → Console → paste new Date(number).toLocaleString()