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