Can I Export the System Log?

[Anonymous]

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.

[tony.mandatori]

The closest i could get was this:

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

[Anonymous]

I get an XML error when I use that link.

[tony.mandatori]

Maybe the URL was messed up ...

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

[Anonymous]

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

[tony.mandatori]

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,