Hi,
Is there a way to query the notes field of the alerts window? Our operators currently put failed job information such as the ticket number in this field. I want to be able to pull that information out of the alerts window by creating a job to query the notes field.
This is for Control M version 6.2.01.04 for distributed systems
Thanks
Travo
Notes field in the Alerts window
Notes field in the Alerts window
Thanks, would you happen to know where I can find an example of the script I need to run? I'm not very good at writing scripts yet..
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
alert
depending of the informations you need (and changing * by fields of the alarm table, you can do the following:
make a controlm job in confirm mode, adding a %%PARM1=<Alert_Id>
Alert_Id can be found in Alert Details
submitting the foll. script:
#!/bin/ksh
tmp="/tmp/tmp.$$"
SQL <<EOF> ${tmp}
select * from ALARM
where
SERIAL=$1
go
EOF
echo "Log in ${tmp}"
this is just a very quick point of view ...
hope help you
make a controlm job in confirm mode, adding a %%PARM1=<Alert_Id>
Alert_Id can be found in Alert Details
submitting the foll. script:
#!/bin/ksh
tmp="/tmp/tmp.$$"
SQL <<EOF> ${tmp}
select * from ALARM
where
SERIAL=$1
go
EOF
echo "Log in ${tmp}"
this is just a very quick point of view ...
hope help you
Kamador, you can populate any of the DB fields in EM or CTM/Server using a SQL update command, but neither I or BMC would recommend it.
You must remember that these DB's are being utilized by front end applications and direct changes to the DB's may have detrimental side effects.
Besides, if BMC finds out that you are making direct updates to the database, per their support contracts, they can cut you off and say that you're invalidating your warranty/contract. Now, I don't know of anyone they've done that to, but they do have that information in their contracts.
You must remember that these DB's are being utilized by front end applications and direct changes to the DB's may have detrimental side effects.
Besides, if BMC finds out that you are making direct updates to the database, per their support contracts, they can cut you off and say that you're invalidating your warranty/contract. Now, I don't know of anyone they've done that to, but they do have that information in their contracts.