Audit requirement

Etler21 · Post by **Etler21** » Mon Jun 20, 2011 1:39 pm

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

kduke · Post by **kduke** » Mon Jun 20, 2011 2:36 pm

Probably not because they are all encrypted. There is a spreadsheet which will extract some of this information. Maybe someone will post a link.

Etler21 · Post by **Etler21** » Mon Jun 20, 2011 7:49 pm

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 ??

Etler21 · Post by **Etler21** » Wed Jun 22, 2011 12:37 pm

any thoughts...anyone ???

kduke · Post by **kduke** » Thu Jun 23, 2011 6:03 am

viewtopic.php?t=132851&highlight=audit+spreadsheet