Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

export events from specific date

Does any one know the syntax to export events with idsalarms.exe from specific date in VMS2.1?

7 REPLIES
Silver

Re: export events from specific date

The Alarm Export utility (IdsAlarms.exe) is a command-line utility that provides external access to events stored in the database. You can use the Alarm Export utility to perform the following tasks:

Read events from the database and output them to an archive file.

Mark events for deletion from the database.

Unmark events currently marked for deletion in the database.

The syntax is

IdsAlarms [-f"filename"] [-l] [-o] [-s<"clause">] [-a] [-d] [-u] [-z]

New Member

Re: export events from specific date

My question is really about the "-s<"clause">" syntax and what field names available or needed to sepecify for events of certain date in the database.

In the documentation, the example is <"event_storage_time > 'Jan 24, 2002'">, so I tried something like <"event_storage_time = 'Jan 24, 2002'">, but it generated a file with no events. And I am not even sure "event_storage_time" is the correct field to choose and interested to know what other fields available.

Thanks.

New Member

Re: export events from specific date

Try putting the date in this format.

IdsAlarms -s "event_storage_time =20031203"

New Member

Re: export events from specific date

just tried. no:(

the example in the documentation works, just not what i wanted for a certain date only.

New Member

Re: export events from specific date

do you mean between a cirtain period of time, like this...

idsalarms -s"event_storage_time BETWEEN '2004-03-30 17:00' AND '2004-03-30 17:02'"

New Member

Re: export events from specific date

i was only looking to do certain date, but will be better to get to certain period of time.

New Member

Re: export events from specific date

I use this command:

Idsalarms.exe -os -s"event_storage_time > 'Dec 20, 2005' AND event_storage_time < 'Dec 27, 2005'"

137
Views
0
Helpful
7
Replies