How to retrieve ThingWorx Login Audit details

[Siddharth_Jhs]

Hi Community,

I need to access following information from ThingWorx Number of users logged in and their time. 

For this I am trying following service: "QueryAuditHistoryWithQueryCriteria" following ptc article: 

https://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/index.html#page/ThingWorx/Help/Composer/System/Subsystems/AuditSubsystemSearchAuditData.html#

Could you all please help me provide correct json input as filter I should provide for same. 

Attaching screenshot for same.

json query: 

{
"filters": {
"type": "LIKE",
"fieldName": "Audit",
"value": "Login%"
}
}

Error:  Unable to Invoke Service QueryAuditHistoryWithQueryCriteria on AuditSubsystem : com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]

Thanks,

Sid

[Velkumar]

Hi @Siddharth_Jhs 

Try below query

{
    "filters": {
        "type": "And",
        "filters": [
            {
                "fieldName": "message",
                "type": "LIKE",
                "value": "*Login*"
            }
        ]
    }
}

/VR

[Siddharth_Jhs]

Hi @Velkumar ,

 Thanks it worked. Could you please tell why we are specifying message in fieldName when we don't have this in header received?

Regards,

Sid

[Velkumar · Accepted solution]

Hi @Siddharth_Jhs 

FieldName displayed in the result is a DataShape Friendly name. You can find the actual fieldName by creating DataShape from the result

/VR