AnsweredAssumed Answered

Making a copy of alarms in external database using adogtw

Question asked by alanh on Jun 23, 2012
Latest reply on Jun 26, 2012 by alanh

I'm trying to make a copy of all alarms into an external database (SQL Express for now, eventually MySQL). I have reviewed all the documentation that I can find, but still can't figure out the proper names of all the variables that I can move to my new database.

 

I have most of the columns, but some still come up as "NULL". Where can I find a list of variable names that would work in an adogtw subscribe profile?

 

My datafile looks like this (the columns in red come out as NULL):

 

Table NameColumn NameOrdinalCol DefNulls OK?Data TypeMax chars
NewAlarmsrowid1NULLYESnchar20
NewAlarmsevent_type2NULLYESintNULL
NewAlarmsnimid3NULLYESnchar20
NewAlarmsnimts4NULLYESdatetimeNULL
NewAlarmsarrival5NULLYESdatetimeNULL
NewAlarmsprevlevel6NULLYESintNULL
NewAlarmslevel7NULLYESintNULL
NewAlarmssubsys8NULLYESnchar10
NewAlarmsmessage9NULLYESnchar50
NewAlarmssource10NULLYESnchar20
NewAlarmshostname11NULLYESnchar20
NewAlarmssid12NULLYESnchar10
NewAlarmsdomain13NULLYESnchar20
NewAlarmshub14NULLYESnchar20
NewAlarmsnas15NULLYESnchar20
NewAlarmsrobot16NULLYESnchar20
NewAlarmsorigin17NULLYESnchar20
NewAlarmsprid18NULLYESnchar10
NewAlarmssupp_key19NULLYESnchar30
NewAlarmssuppcount20NULLYESintNULL
NewAlarmstz_offset21NULLYESintNULL
NewAlarmsvisible22NULLYESintNULL
NewAlarmsi18n_dsize23NULLYESintNULL
NewAlarmsassigned_to24NULLYESnchar20
NewAlarmsassigned_by25NULLYESnchar20
NewAlarmsassigned_at26NULLYESdatetimeNULL
NewAlarmscount27NULLYESintNULL
NewAlarmsuser_tag128NULLYESvarchar50
NewAlarmsuser_tag229NULLYESvarchar50
NewAlarmsi18n_data30NULLYESvarchar500
NewAlarmssupptime31NULLYESdatetimeNULL
NewAlarmsaots32NULLYESdatetimeNULL
NewAlarmsi18n_token33NULLYESvarchar50

Outcomes