There is a SQL script example to give you exact Avtive Net from Control-EM database about one of yours Control-M Server.
declare @ctmserver varchar(15)
declare @activ varchar(20)
select @ctmserver='CTMSERVER'
select @activ="A"+ACTIVE_NET_NAME from dbo.COMM where DATA_CENTER=@ctmserver
select @activ
Result example:
A061030002_A
Find Active Net for a Control-M Server
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
moi jfait juste un sp_help sur la base EM et j'ai tous les net name existants dans la base non ?? (puisque que j'ai toutes les tables...)
*********************************************************
me I just do a sp_help on the EM database and I have all existing net name's in the database, isn't it ?? (as i have all tables ....)
*********************************************************
me I just do a sp_help on the EM database and I have all existing net name's in the database, isn't it ?? (as i have all tables ....)
Hi philmalmaison,
It's not totally true.
Active Net could change if during the day you had a Gateway failure.
For the same gateway you can have another Active Net and keep in the same time all the tables created for the oldest ActiveNet.
So, when you want to build an automatic extraction without any mistakes in case of your gateway crashed, the best way must be to extract the last ActveNte crated by Control-M.
And finaly everybody are not access right to read database content directly, using SQL command.
It's not totally true.
Active Net could change if during the day you had a Gateway failure.
For the same gateway you can have another Active Net and keep in the same time all the tables created for the oldest ActiveNet.
So, when you want to build an automatic extraction without any mistakes in case of your gateway crashed, the best way must be to extract the last ActveNte crated by Control-M.
And finaly everybody are not access right to read database content directly, using SQL command.
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
what is the difference beetween doing isql or SQL and your solution to connect the database aren't you doing a select ?fyot wrote:Hi philmalmaison,
It's not totally true.
Active Net could change if during the day you had a Gateway failure.
For the same gateway you can have another Active Net and keep in the same time all the tables created for the oldest ActiveNet.
So, when you want to build an automatic extraction without any mistakes in case of your gateway crashed, the best way must be to extract the last ActveNte crated by Control-M.
And finaly everybody are not access right to read database content directly, using SQL command.
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France