Not sure how to find from DB but you can find dependencies on objects from BladeLogic Console.
Example : if you are looking for dependency for NSH script job, you can create a smart group , where Type equal 1.
Right click on object (NSH Script) and select "Show Dependency". This will show you both Upward and Downward dependency on that object.
Thank you for your answer.
I must modify many many scripts (more than 2500).
I looked for their location in the depot server.
Now, I want to know if each script found is used by a job. If yes then I want to know the job name and when it has been used for the last time.
A search in the GUI with a smartgroup would last really too long. It is the reason why I want to look in the database.
I am not sure , how to get dependency information from DB. May be some body else might be able to respond
there's an unreleased blcli command called 'Delete.getAllDependentObjects' that you could use.
how do you need to modify the scripts and why does it matter when the job last ran ?
Today, we are in BSA8.0SP9
Our database is very big. Cleanup cannot run for one year.
Then, we intend to migrate in BSA8.2SP3
However, we have another problem. The modification of several NSH commands in BSA8.2SP3 obliges us to rewrite many scripts. With the BMC support, we were able to locate the impacted scripts in depot server.
As our cleanup do not work, we do not know if the found scripts are still used. That is why we want to know the jobs which are linked to them as well as the last one execution of the job to prioritize our works.
Maybe, you can ask to Sean Berry. He knows our problem.
Thank you very much.
i've already provided him some sql and nsh scripts to give you a list of your script files/depot objects that are using the changed nsh commands.
But, we don't have the jobs linked with this list of objects
i can add that.
actually - what version of bsa is this for ? i gave sean a update script for bsa that included the job run count - has he sent that over ?