topic Re: Can I Export the System Log? in Fusion Manage Forum

Can I Export the System Log?

Anonymous — Fri, 22 Jul 2016 17:00:03 GMT

I'd like to find out when/if users have logged into the system. I can do that by searching the system log, but only one name at a time. It would be great to export the log to Excel so I can filter it quicker. In reality, it would be great to allow for reports to be created from the system log as well.

Re: Can I Export the System Log?

tony.mandatori — Fri, 22 Jul 2016 18:33:33 GMT

The closest i could get was this:

https://tenant.autodeskplm360.net/api/rest/v1/itemLog/2014-06-11T00:07:06.924-04:00

Re: Can I Export the System Log?

Anonymous — Fri, 22 Jul 2016 19:50:41 GMT

I get an XML error when I use that link.

Re: Can I Export the System Log?

tony.mandatori — Fri, 22 Jul 2016 20:54:25 GMT

Maybe the URL was messed up ...

Here is an image of what i get (after I log in)

Re: Can I Export the System Log?

Anonymous — Fri, 22 Jul 2016 21:01:26 GMT

How did you get that and how would I put it together in a readable format?

Re: Can I Export the System Log?

tony.mandatori — Fri, 22 Jul 2016 21:25:06 GMT

This is the ReST API: It's an API that you can call from a URL (so called Representational State Transter).

You can see the api documentation by adding /api/rest/application.wadl to the end of your default URL ... in my case - https://adskmandatt.autodeskplm360.net/api/rest/application.wadl

I found a few URL's that you can query - metaLog, securityLog and itemLog. The System Log isn't available, but I think the item log tracks the updates to items in the tenant. This isn't really a complete solution because it doesn't have all the fields. But you can get the rest of the Change log for each of the items if you then query each item's change log.

Your options are to either use this by saving the XML and applying XSLT to get a CSV that Excel can read (here is one example on the web - http://stackoverflow.com/questions/15226194/xml-to-csv-using-xslt?rq=1), or to code this up with some coding language or Jitterbit. Neither one is easy - and depending on the limits of the ReST API, you might not get everything you're looking for. I couldn't find a single function that would return everything in one shot. Maybe someone else can chime in to provide a better API call.

Thanks,