Page 1 of 1

Audit requirement

Posted: Mon Jun 20, 2011 1:39 pm
by Etler21
we have an audit requirement to find all those jobs which have hardcoded passwords for Database connection.I know I can open each job and check all the stages but this is an enormous task to carry out..

Is there any other way like a universe query to find this???

Any input will be a great help for me.

Thanks

Posted: Mon Jun 20, 2011 2:36 pm
by kduke
Probably not because they are all encrypted. There is a spreadsheet which will extract some of this information. Maybe someone will post a link.

Posted: Mon Jun 20, 2011 7:49 pm
by Etler21
Thanks duke,I understand we can't track password which are behind **** but I am more concern about those which shows up in director e.g. if some has used a truncate script in pre/post job execute command and if this script contains a password then it will show up in director logs.I want to catch these type of jobs.

Is it possible to qury job log to get this informaion out ??

Posted: Wed Jun 22, 2011 12:37 pm
by Etler21
any thoughts...anyone ???

Posted: Thu Jun 23, 2011 6:03 am
by kduke