CQL matching by datetime
Isidor Zeuner <[email protected]>
| Newsgroups | gmane.network.open-pegasus.general |
|---|---|
| Message-ID | <[email protected]> |
Hi!
What is the proper way to match objects by a datetime value using CQL?
I cannot figure out how to do this. It works fine when I match a
string value (sample_host). Doing the same on a datetime column
(sample_time) does not lead to a match:
$ cimcli xq 'select sample_host,sample_time
from TEST_server_performance
where sample_host="db1.quidecco.de"'
path= //dev.quidecco.de/root/cimv2:TEST_server_performance.OID=139920171280
//Instance of TEST_server_performance
instance of TEST_server_performance
{
sample_time = "20120211110507.000000+000";
sample_host = "db1.quidecco.de";
};
$ cimcli xq 'select sample_host,sample_time
from TEST_server_performance
where sample_time="20120211110507.000000+000"'
$
I'm using OpenPegasus 2.10.1. Is this even possible to do? Do I
need to use another syntax for the datetime values?
Thanks in advance!
Best regards,
Isidor Zeuner