How to use concat() method in wql?

Question

I am develop wmi application to get windows logs by using WQL query. How to use CONCAT() method in that query.

Input WQL Query :

wmic -U XXX%XXX //XXX "Select CONCAT(Category, '|DHCP') from Win32_NTLogEvent where TimeWritten > '06/04/2014 13:59:00' and Logfile = 'Security'"

Output :

[wmi/wmic.c:212:main()] ERROR: Retrieve result data.
NTSTATUS: NT code 0x80041017 - NT code 0x80041017

Without using CONCAT() method, it will work perfectly. if any other way to get value using CONCAT() method in WQL.

Notes: When i using CONCAT() method in different scenario, it is not working. it will throw error code.

Please Help me Guys.

Thanks in Advance.

Answer 1

The is not CONCAT function in WQL, the WQL is just a a small subset of the SQL standard and doesn't include such function.